The tJDBCConnection component is configured to use "AthenaJDBC42_2.0.5.jar" that contains log4j which is conflicting with the one used by the Job.
Could you please try to configure tJDBCConnection to use "AthenaJDBC41-1.1.0.jar" and adjust driver class name to be "com.amazonaws.athena.jdbc.AthenaDriver"?
Feel free to let us know if it doesn't work for you.
Tried switching to AthenaJDBC41-1.1.0.jar and adjusting the driver class but the error still appears. Error is listed below.
Any other possible solutions?
Thanks
log4j:ERROR Could not create an Appender. Reported error follows. java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be cast to com.simba.athena.shaded.apache.log4j.Appender at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:248) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:191) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:523) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseCategory(DOMConfigurator.java:436) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1004) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:872) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:778) at com.simba.athena.shaded.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526) at com.simba.athena.shaded.apache.log4j.LogManager.<clinit>(LogManager.java:127) at com.simba.athena.shaded.apache.log4j.Logger.getLogger(Logger.java:104) at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:262) at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:108) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1025) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:844) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:541) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:292) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:269) at com.simba.athena.shaded.apache.commons.logging.LogFactory.getLog(LogFactory.java:655) at com.simba.athena.amazonaws.util.VersionInfoUtils.<clinit>(VersionInfoUtils.java:47) at com.simba.athena.amazonaws.ClientConfiguration.<clinit>(ClientConfiguration.java:70) at com.simba.athena.athena.core.AJSettings.<init>(Unknown Source) at com.simba.athena.athena.core.AJConnection.connect(Unknown Source) at com.simba.athena.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source) at com.simba.athena.jdbc.common.AbstractDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnection(JdbcRuntimeUtils.java:65) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnectionOrGetFromSharedConnectionPoolOrDataSource(JdbcRuntimeUtils.java:194) at org.talend.components.jdbc.runtime.JDBCSourceOrSink.connect(JDBCSourceOrSink.java:217) at org.talend.components.jdbc.runtime.setting.JdbcRuntimeSourceOrSinkDefault.initConnection(JdbcRuntimeSourceOrSinkDefault.java:46) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.validate(JdbcRuntimeUtils.java:89) at org.talend.components.jdbc.runtime.JDBCSourceOrSink.validate(JDBCSourceOrSink.java:121) at ipave_data_load.athena_query_1_1_0_jar_0_1.Athena_Query_1_1_0_JAR.tDBConnection_2Process(Athena_Query_1_1_0_JAR.java:466) at ipave_data_load.athena_query_1_1_0_jar_0_1.Athena_Query_1_1_0_JAR.runJobInTOS(Athena_Query_1_1_0_JAR.java:1487) at ipave_data_load.athena_query_1_1_0_jar_0_1.Athena_Query_1_1_0_JAR.main(Athena_Query_1_1_0_JAR.java:1326)
I am also getting the same error. I tried with both the drivers but no luck.
Do you have any resolution to this?
Starting job kpi_summary_talend_poc at 10:28 10/02/2020.
[statistics] connecting to socket on port 3900 [statistics] connected log4j:ERROR Could not create an Appender. Reported error follows. java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be cast to com.simba.athena.shaded.apache.log4j.Appender at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:248) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:191) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:523) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseCategory(DOMConfigurator.java:436) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1004) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:872) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:778) at com.simba.athena.shaded.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526) at com.simba.athena.shaded.apache.log4j.LogManager.<clinit>(LogManager.java:127) at com.simba.athena.shaded.apache.log4j.Logger.getLogger(Logger.java:104) at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:262) at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:108) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1025) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:844) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:541) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:292) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:269) at com.simba.athena.shaded.apache.commons.logging.LogFactory.getLog(LogFactory.java:655) at com.simba.athena.amazonaws.util.VersionInfoUtils.<clinit>(VersionInfoUtils.java:47) at com.simba.athena.amazonaws.ClientConfiguration.<clinit>(ClientConfiguration.java:70) at com.simba.athena.athena.core.AJSettings.<init>(Unknown Source) at com.simba.athena.athena.core.AJConnection.connect(Unknown Source) at com.simba.athena.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source) at com.simba.athena.jdbc.common.AbstractDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnection(JdbcRuntimeUtils.java:77) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnectionOrGetFromSharedConnectionPoolOrDataSource(JdbcRuntimeUtils.java:206) at org.talend.components.jdbc.runtime.JDBCSourceOrSink.connect(JDBCSourceOrSink.java:217) at org.talend.components.jdbc.runtime.setting.JdbcRuntimeSourceOrSinkDefault.initConnection(JdbcRuntimeSourceOrSinkDefault.java:46) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.validate(JdbcRuntimeUtils.java:101) at org.talend.components.jdbc.runtime.JDBCSourceOrSink.validate(JDBCSourceOrSink.java:121) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tDBConnection_1Process(kpi_summary_talend_poc.java:759) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tChronometerStart_1Process(kpi_summary_talend_poc.java:593) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tPrejob_1Process(kpi_summary_talend_poc.java:441) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.runJobInTOS(kpi_summary_talend_poc.java:1447) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.main(kpi_summary_talend_poc.java:1258) log4j:ERROR Could not create an Appender. Reported error follows. java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be cast to com.simba.athena.shaded.apache.log4j.Appender at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:248) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:191) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:523) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:492) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1006) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:872) at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:778) at com.simba.athena.shaded.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526) at com.simba.athena.shaded.apache.log4j.LogManager.<clinit>(LogManager.java:127) at com.simba.athena.shaded.apache.log4j.Logger.getLogger(Logger.java:104) at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:262) at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:108) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1025) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:844) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:541) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:292) at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:269) at com.simba.athena.shaded.apache.commons.logging.LogFactory.getLog(LogFactory.java:655) at com.simba.athena.amazonaws.util.VersionInfoUtils.<clinit>(VersionInfoUtils.java:47) at com.simba.athena.amazonaws.ClientConfiguration.<clinit>(ClientConfiguration.java:70) at com.simba.athena.athena.core.AJSettings.<init>(Unknown Source) at com.simba.athena.athena.core.AJConnection.connect(Unknown Source) at com.simba.athena.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source) at com.simba.athena.jdbc.common.AbstractDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnection(JdbcRuntimeUtils.java:77) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnectionOrGetFromSharedConnectionPoolOrDataSource(JdbcRuntimeUtils.java:206) at org.talend.components.jdbc.runtime.JDBCSourceOrSink.connect(JDBCSourceOrSink.java:217) at org.talend.components.jdbc.runtime.setting.JdbcRuntimeSourceOrSinkDefault.initConnection(JdbcRuntimeSourceOrSinkDefault.java:46) at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.validate(JdbcRuntimeUtils.java:101) at org.talend.components.jdbc.runtime.JDBCSourceOrSink.validate(JDBCSourceOrSink.java:121) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tDBConnection_1Process(kpi_summary_talend_poc.java:759) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tChronometerStart_1Process(kpi_summary_talend_poc.java:593) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tPrejob_1Process(kpi_summary_talend_poc.java:441) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.runJobInTOS(kpi_summary_talend_poc.java:1447) at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.main(kpi_summary_talend_poc.java:1258)
Setup an Athena connection with "AthenaJDBC42_2.0.9.jar" and class path "com.simba.athena.jdbc42.Driver" and then in tDbConnection with a select statement we get the "log4j:ERROR Could not create an Appender. Reported error follows." error.
