Johoo, liebe Gemeinde, 😀
zwischenzeitig habe ich einfach mal eine Testinstallation mit einer MariaDB gewagt und will nun meine bisherige lokale Datenbank nach MySQL/MariaDB konvertieren.
Nachdem ich herausgefunden habe, dass dies ausschließlich bis JAVA 8 geht, habe ich das aktuelle JRE8 (OpenJDK) installiert und meine Standard-Java-Umgebung in Arch Linux entsprechend umgestellt. Dennoch schmeißt mir das Tool immer denselben Fehler raus. Vielleicht besteht ein Fehler in Hinblick auf die Verbindung zur Datenbank?
Jedenfalls habe ich vorher – wie beschrieben – entsprechende Anpassungen in den .grf-Dateien vorgenommen. Aber nichts geht. Folgende Debugging-Infos wirft die Konsole aus:
INFO [main] - CloverETL, (c) 2002-2017 Javlin a.s. INFO [main] - Running with CloverETL version 4.7.0 build#010 compiled 10/10/2017 12:07:19 INFO [main] - Running on 8 CPU(s), OS Linux, architecture amd64, max available memory for JVM 7.290.880 KB INFO [main] - Running on OpenJDK Runtime Environment, 1.8.0_392, Oracle Corporation (JDK) INFO [main] - Loading default properties from: defaultProperties DEBUG [main] - Plugin org.jetel.connection loaded. id - org.jetel.connection version - 4.7.0 provider-name - Javlin a.s. connection { className = org.jetel.connection.jdbc.DBConnectionImpl; type = JDBC; } connection { className = org.jetel.connection.jms.JmsConnection; type = JMS; } DEBUG [main] - Plugin org.jetel.ctlfunction loaded. id - org.jetel.ctlfunction version - 4.7.0 provider-name - Javlin a.s. ctlfunction { libraryName = math; className = org.jetel.ctl.extensions.MathLib; } ctlfunction { libraryName = date; className = org.jetel.ctl.extensions.DateLib; } ctlfunction { libraryName = string; className = org.jetel.ctl.extensions.StringLib; } ctlfunction { libraryName = convert; className = org.jetel.ctl.extensions.ConvertLib; } ctlfunction { libraryName = container; className = org.jetel.ctl.extensions.ContainerLib; } ctlfunction { libraryName = random; className = org.jetel.ctl.extensions.RandomLib; } ctlfunction { libraryName = util; className = org.jetel.ctl.extensions.UtilLib; } ctlfunction { libraryName = dynamic; className = org.jetel.ctl.extensions.DynamicLib; } ctlfunction { libraryName = string; className = org.jetel.ctl.extensions.StringLibExt; } ctlfunction { libraryName = mapping; className = org.jetel.ctl.extensions.MappingLib; } ctlfunction { libraryName = dynamic; className = org.jetel.ctl.extensions.DynamicLibExt; } DEBUG [main] - Plugin org.jetel.engine loaded. id - org.jetel.engine version - 4.7.0 provider-name - Javlin a.s. dictionaryType { className = org.jetel.graph.dictionary.StringDictionaryType; type = string; } dictionaryType { className = org.jetel.graph.dictionary.ObjectDictionaryType; type = object; } dictionaryType { className = org.jetel.graph.dictionary.ReadableChannelDictionaryType; type = readable.channel; } dictionaryType { className = org.jetel.graph.dictionary.WritableChannelDictionaryType; type = writable.channel; } dictionaryType { className = org.jetel.graph.dictionary.IntegerDictionaryType; type = integer; } dictionaryType { className = org.jetel.graph.dictionary.LongDictionaryType; type = long; } dictionaryType { className = org.jetel.graph.dictionary.DecimalDictionaryType; type = decimal; } dictionaryType { className = org.jetel.graph.dictionary.NumberDictionaryType; type = number; } dictionaryType { className = org.jetel.graph.dictionary.DateDictionaryType; type = date; } dictionaryType { className = org.jetel.graph.dictionary.BooleanDictionaryType; type = boolean; } dictionaryType { className = org.jetel.graph.dictionary.ByteDictionaryType; type = byte; } dictionaryType { className = org.jetel.graph.dictionary.ListDictionaryType; type = list; } dictionaryType { className = org.jetel.graph.dictionary.MapDictionaryType; type = map; } tlCompiler { className = org.jetel.ctl.TLCompiler; type = simple.compiler; } ctlfunction { libraryName = record; className = org.jetel.ctl.extensions.IntegralLib; } urlResolver { className = org.jetel.util.file.SMBPathResolver; type = SMB; } urlResolver { className = org.jetel.util.protocols.amazon.S3PathResolver; type = S3; } authorityProxy { className = org.jetel.graph.runtime.PrimitiveAuthorityProxy; type = PrimitiveAuthorityProxy; priority = 0; } DEBUG [main] - Plugin org.jetel.jdbc loaded. id - org.jetel.jdbc version - 4.8.0. provider-name - Javlin a.s. jdbcSpecific { database = GENERIC; name = Generic; class = org.jetel.connection.jdbc.specific.impl.DefaultJdbcSpecific; } jdbcSpecific { database = HSQLDB; name = HSQLDB; class = org.jetel.connection.jdbc.specific.impl.DefaultJdbcSpecific; } jdbcSpecific { database = REDSHIFT; name = Amazon Redshift; class = org.jetel.connection.jdbc.specific.impl.RedshiftSpecific; } jdbcSpecific { database = DB2; name = DB2; class = org.jetel.connection.jdbc.specific.impl.DB2Specific; } jdbcSpecific { database = DERBY; name = Derby; class = org.jetel.connection.jdbc.specific.impl.DerbySpecific; productName = Apache Derby; } jdbcSpecific { database = EXASOLUTION; name = EXASolution; class = org.jetel.connection.jdbc.specific.impl.ExasolSpecific; } jdbcSpecific { database = FIREBIRD; name = Firebird; class = org.jetel.connection.jdbc.specific.impl.FirebirdSpecific; } jdbcSpecific { database = GENERICODBC; name = Generic ODBC; class = org.jetel.connection.jdbc.specific.impl.GenericODBCSpecific; } jdbcSpecific { database = HIVE; name = Hive; class = org.jetel.connection.jdbc.specific.impl.HiveSpecific; } jdbcSpecific { database = INFORMIX; name = Informix; class = org.jetel.connection.jdbc.specific.impl.InformixSpecific; } jdbcSpecific { database = MSACCESS; name = Microsoft Access ODBC; class = org.jetel.connection.jdbc.specific.impl.MSAccessSpecific; } jdbcSpecific { database = MSACCESSJAVA; name = Microsoft Access; class = org.jetel.connection.jdbc.specific.impl.MSAccessPureJavaSpecific; } jdbcSpecific { database = MSSQL; name = MS SQL Server 2008-2012; class = org.jetel.connection.jdbc.specific.impl.MSSQLSpecific; productName = Microsoft SQL Server; } jdbcSpecific { database = MSSQL2005; name = MS SQL Server 2000-2005; class = org.jetel.connection.jdbc.specific.impl.MSSQLSpecific2005; } jdbcSpecific { database = MYSQL; name = MySQL; class = org.jetel.connection.jdbc.specific.impl.MySQLSpecific; productName = MySQL; } jdbcSpecific { database = ORACLE; name = Oracle; class = org.jetel.connection.jdbc.specific.impl.OracleSpecific; productName = Oracle; } jdbcSpecific { database = PERVASIVE; name = Pervasive; class = org.jetel.connection.jdbc.specific.impl.PervasiveSpecific; } jdbcSpecific { database = POSTGRE; name = PostgreSQL; class = org.jetel.connection.jdbc.specific.impl.PostgreSpecific; } jdbcSpecific { database = SYBASE; name = Sybase; class = org.jetel.connection.jdbc.specific.impl.SybaseSpecific; } jdbcSpecific { database = SQLITE; name = SQLite; class = org.jetel.connection.jdbc.specific.impl.SQLiteSpecific; } jdbcSpecific { database = VERTICA; name = Vertica; class = org.jetel.connection.jdbc.specific.impl.VerticaSpecific; } jdbcDriver { database = MYSQL; urlHint = jdbc:mysql://hostname:3306/database; jdbc.zeroDateTimeBehavior = convertToNull; name = MySQL; driverLibrary = lib/mysql/mysql-connector-java-5.1.26-bin.jar; jdbcSpecific = MYSQL; dbDriver = org.gjt.mm.mysql.Driver; } jdbcDriver { database = HSQLDB; urlHint = jdbc:hsqldb:hsql://hostname:9001/database; jdbc.zeroDateTimeBehavior = convertToNull; name = HSQLDB; driverLibrary = lib/hsqldb/hsqldb.jar; jdbcSpecific = HSQLDB; dbDriver = org.hsqldb.jdbc.JDBCDriver; } jdbcDriver { database = ORACLE; urlHint = jdbc:***@cluster-alias:1521/service_name,jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service_name))),jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cluster_alias)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service_name))),jdbc:oracle:thin:@host:1521/service_name; name = Oracle; driverLibrary = lib/oracle/ojdbc6.jar; jdbcSpecific = ORACLE; dbDriver = oracle.jdbc.OracleDriver; } jdbcDriver { database = POSTGRE; urlHint = jdbc:postgresql://hostname/database; name = PostgreSQL; driverLibrary = lib/postgre/postgresql-9.3-1102.jdbc41.jar; jdbcSpecific = POSTGRE; dbDriver = org.postgresql.Driver; } jdbcDriver { database = REDSHIFT; urlHint = jdbc:redshift://cluster_id.redshift.amazonaws.com:5439/database; name = Amazon Redshift; driverLibrary = lib/redshift/RedshiftJDBC41-1.1.17.1017.jar; jdbcSpecific = REDSHIFT; dbDriver = com.amazon.redshift.jdbc41.Driver; } jdbcDriver { database = MSSQL; urlHint = jdbc:jtds:sqlserver://hostname:1433/database;instance=instanceName,jdbc:jtds:sqlserver://hostname:1433/database; name = Microsoft SQL Server; driverLibrary = lib/jtds/jtds-1.2.8.jar; jdbcSpecific = MSSQL; dbDriver = net.sourceforge.jtds.jdbc.Driver; } jdbcDriver { database = GENERICODBC; urlHint = jdbc:odbc:dsn_source;; name = Generic ODBC; driverLibrary = sun.jdbc.odbc.JdbcOdbcDriver; jdbcSpecific = GENERICODBC; dbDriver = sun.jdbc.odbc.JdbcOdbcDriver; } jdbcDriver { database = MSACCESS; urlHint = jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=database_file,jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=database_file,jdbc:odbc:odbc_source_name; name = Microsoft Access ODBC; driverLibrary = sun.jdbc.odbc.JdbcOdbcDriver; jdbcSpecific = MSACCESS; dbDriver = sun.jdbc.odbc.JdbcOdbcDriver; } jdbcDriver { database = MSACCESSJAVA; urlHint = jdbc:ucanaccess://database_file,jdbc:ucanaccess://database_file;newdatabaseversion=V2010; name = Microsoft Access; driverLibrary = lib/msaccess/ucanaccess-4.0.2.jar;lib/msaccess/jackcess-2.1.6.jar;lib/msaccess/hsqldb.jar; jdbcSpecific = MSACCESSJAVA; dbDriver = net.ucanaccess.jdbc.UcanaccessDriver; } jdbcDriver { database = SYBASE; urlHint = jdbc:jtds:sybase://hostname:7100/database; name = Sybase; driverLibrary = lib/jtds/jtds-1.2.8.jar; jdbcSpecific = SYBASE; dbDriver = net.sourceforge.jtds.jdbc.Driver; } jdbcDriver { database = SQLITE; urlHint = jdbc:sqlite:C:/database; name = SQLite; driverLibrary = lib/sqlite/sqlite-jdbc-3.6.20.1.jar; jdbcSpecific = SQLITE; dbDriver = org.sqlite.JDBC; } jdbcDriver { database = DERBY; urlHint = jdbc:derby://hostname:1527/derby.db; name = Derby; driverLibrary = lib/derby/derbyclient-10.11.1.1.jar; jdbcSpecific = DERBY; dbDriver = org.apache.derby.jdbc.ClientDriver; } jdbcDriver { database = FIREBIRD; urlHint = jdbc:firebirdsql:localhost/3050:/firebird/test.gdb; name = Firebird; driverLibrary = lib/firebird/jaybird-full-2.2.1.jar; jdbcSpecific = FIREBIRD; dbDriver = org.firebirdsql.jdbc.FBDriver; } jdbcDriver { database = VERTICA70; urlHint = jdbc:vertica://hostname:5433/database; name = Vertica 7.0; driverLibrary = lib/vertica/vertica-jdbc-7.0.2-1.jar; jdbcSpecific = VERTICA; dbDriver = com.vertica.jdbc.Driver; } jdbcDriver { database = VERTICA71; urlHint = jdbc:vertica://hostname:5433/database; name = Vertica 7.1; driverLibrary = lib/vertica/vertica-jdbc-7.1.1-0.jar; jdbcSpecific = VERTICA; dbDriver = com.vertica.jdbc.Driver; } DEBUG [main] - Plugin org.jetel.lookup loaded. id - org.jetel.lookup version - 4.7.0 provider-name - Javlin a.s. lookup { className = org.jetel.lookup.SimpleLookupTable; type = simpleLookup; } lookup { className = org.jetel.lookup.DBLookupTable; type = dbLookup; } lookup { className = org.jetel.lookup.RangeLookupTable; type = rangeLookup; } DEBUG [main] - Plugin org.jetel.sequence loaded. id - org.jetel.sequence version - 4.7.0 provider-name - Javlin a.s. sequence { className = org.jetel.sequence.SimpleSequence; type = SIMPLE_SEQUENCE; } sequence { className = org.jetel.sequence.PrimitiveSequence; type = PRIMITIVE_SEQUENCE; } DEBUG [main] - Plugin org.jetel.component loaded. id - org.jetel.component version - 4.7.0 provider-name - Javlin a.s. component { className = org.jetel.component.DataReader; name = UniversalDataReader; type = DATA_READER; } component { className = org.jetel.component.DataWriter; name = UniversalDataWriter; type = DATA_WRITER; } component { className = org.jetel.component.DataReader; name = FlatFileReader; type = FLAT_FILE_READER; } component { className = org.jetel.component.DataWriter; name = FlatFileWriter; type = FLAT_FILE_WRITER; } component { className = org.jetel.component.DelimitedDataReader; name = DelimitedDataReader; type = DELIMITED_DATA_READER; } component { className = org.jetel.component.DelimitedDataWriter; name = DelimitedDataWriter; type = DELIMITED_DATA_WRITER; } component { className = org.jetel.component.SimpleCopy; name = SimpleCopy; type = SIMPLE_COPY; } component { className = org.jetel.component.Concatenate; name = Concatenate; type = CONCATENATE; } component { className = org.jetel.component.SimpleGather; name = SimpleGather; type = SIMPLE_GATHER; } component { className = org.jetel.component.Reformat; name = Reformat; type = REFORMAT; } component { className = org.jetel.component.DBInputTable; name = DBInputTable; type = DB_INPUT_TABLE; } component { className = org.jetel.component.Sort; name = Sort; type = SORT; } component { className = org.jetel.component.DBOutputTable; name = DBOutputTable; type = DB_OUTPUT_TABLE; } component { className = org.jetel.component.FixLenDataWriter; name = FixLenDataWriter; type = FIXLEN_DATA_WRITER; } component { className = org.jetel.component.Dedup; name = Dedup; type = DEDUP; } component { className = org.jetel.component.FixLenDataReader; name = FixLenDataReader; type = FIXLEN_DATA_READER; } component { className = org.jetel.component.Merge; name = Merge; type = MERGE; } component { className = org.jetel.component.CrossJoin; name = CrossJoin; type = CROSS_JOIN; } component { className = org.jetel.component.MergeJoin; name = MergeJoin; type = MERGE_JOIN; } component { className = org.jetel.component.MergeJoin; name = ExtMergeJoin; type = EXT_MERGE_JOIN; } component { className = org.jetel.component.MergeJoin; type = SORTED_JOIN; } component { className = org.jetel.component.Trash; name = Trash; type = TRASH; } component { className = org.jetel.component.Trashifier; type = TRASHIFIER; } component { className = org.jetel.component.DBExecute; name = DBExecute; type = DB_EXECUTE; } component { className = org.jetel.component.HashJoin; name = HashJoin; type = HASH_JOIN; } component { className = org.jetel.component.HashJoin; name = ExtHashJoin; type = EXT_HASH_JOIN; } component { className = org.jetel.component.CheckForeignKey; name = CheckForeignKey; type = CHECK_FOREIGN_KEY; } component { className = org.jetel.component.DBFDataReader; name = DBFDataReader; type = DBF_DATA_READER; } component { className = org.jetel.component.DBFDataWriter; name = DBFDataWriter; type = DBF_DATA_WRITER; } component { className = org.jetel.component.ExtFilter; name = Filter; type = EXT_FILTER; } component { className = org.jetel.component.ExtSort; name = ExtSort; type = EXT_SORT; } component { className = org.jetel.component.SortWithinGroups; name = SortWithinGroups; type = SORT_WITHIN_GROUPS; } component { className = org.jetel.component.Partition; name = Partition; type = PARTITION; } component { className = org.jetel.component.DataIntersection; name = DataIntersection; type = DATA_INTERSECTION; } component { className = org.jetel.component.Aggregate; name = Aggregate; type = AGGREGATE; } component { className = org.jetel.component.SystemExecute; name = SystemExecute; type = SYS_EXECUTE; } component { className = org.jetel.component.RunGraph; name = RunGraph; type = RUN_GRAPH; } component { className = org.jetel.component.HttpConnector; name = HTTPConnector; type = HTTP_CONNECTOR; } component { className = org.jetel.component.KeyGenerator; name = KeyGenerator; type = KEY_GEN; } component { className = org.jetel.component.AproxMergeJoin; name = ApproximativeJoin; type = APROX_MERGE_JOIN; } component { className = org.jetel.component.DBJoin; name = DBJoin; type = DBJOIN; } component { className = org.jetel.component.XLSReader; name = XLSDataReader; type = XLS_READER; } component { className = org.jetel.component.XLSWriter; name = XLSDataWriter; type = XLS_WRITER; } component { className = org.jetel.component.CloverDataWriter; name = CloverDataWriter; type = CLOVER_WRITER; } component { className = org.jetel.component.CloverDataReader; name = CloverDataReader; type = CLOVER_READER; } component { className = org.jetel.component.StructureWriter; name = StructuredDataWriter; type = STRUCTURE_WRITER; } component { className = org.jetel.component.Normalizer; name = Normalizer; type = NORMALIZER; } component { className = org.jetel.component.Denormalizer; name = Denormalizer; type = DENORMALIZER; } component { className = org.jetel.component.Rollup; name = Rollup; type = ROLLUP; } component { className = org.jetel.component.JmsReader; name = JMSReader; type = JMS_READER; } component { className = org.jetel.component.JmsWriter; name = JMSWriter; type = JMS_WRITER; } component { className = org.jetel.component.LookupJoin; name = LookupJoin; type = LOOKUP_JOIN; } component { className = org.jetel.component.LookupTableReaderWriter; name = LookupTableReaderWriter; type = LOOKUP_TABLE_READER_WRITER; } component { className = org.jetel.component.DataGenerator; name = DataGenerator; type = DATA_GENERATOR; } component { className = org.jetel.component.SequenceChecker; name = SequenceChecker; type = SEQUENCE_CHECKER; } component { className = org.jetel.component.TextTableWriter; type = TEXT_TABLE_WRITER; } component { className = org.jetel.component.XmlXPathReader; name = XMLXPathReader; type = XML_XPATH_READER; } component { className = org.jetel.component.XMLExtract; name = XMLExtract; type = XML_EXTRACT; } component { className = org.jetel.component.JsonExtract; name = JSONExtract; type = JSON_EXTRACT; } component { className = org.jetel.component.XmlReader; name = XMLReader; type = XML_READER; } component { className = org.jetel.component.SpeedLimiter; name = SpeedLimiter; type = SPEED_LIMITER; } component { className = org.jetel.component.SpeedLimiter; name = Sleep; type = SLEEP; } component { className = org.jetel.component.JavaExecute; name = JavaExecute; type = JAVA_EXECUTE; } component { className = org.jetel.component.GenericComponent; name = CustomJavaReader; type = GENERIC_READER; } component { className = org.jetel.component.GenericComponent; name = CustomJavaWriter; type = GENERIC_WRITER; } component { className = org.jetel.component.GenericComponent; name = CustomJavaTransformer; type = GENERIC_TRANSFORMER; } component { className = org.jetel.component.GenericComponent; name = CustomJavaComponent; type = GENERIC_COMPONENT; } component { className = org.jetel.component.XmlWriter; name = XMLWriter (deprecated); type = XML_WRITER; } component { className = org.jetel.component.ExtXmlWriter; name = XMLWriter; type = EXT_XML_WRITER; } component { className = org.jetel.component.XSLDataTransformer; name = XSLTransformer; type = XSL_TRANSFORMER; } metadata { id = UniversalDataReader_Error; } metadata { id = HTTPConnector_Request; } metadata { id = HTTPConnector_Response; } metadata { id = HTTPConnector_Error; } metadata { id = RunGraph_Input; } metadata { id = RunGraph_Output; } DEBUG [main] - Plugin org.jetel.bulkloader loaded. id - org.jetel.bulkloader version - 4.7.0 provider-name - Javlin a.s. component { className = org.jetel.component.OracleDataWriter; name = OracleDataWriter; type = ORACLE_DATA_WRITER; } component { className = org.jetel.component.DB2DataWriter; name = DB2DataWriter; type = DB2_DATA_WRITER; } component { className = org.jetel.component.InformixDataWriter; name = InformixDataWriter; type = INFORMIX_DATA_WRITER; } component { className = org.jetel.component.MsSqlDataWriter; name = MSSQLDataWriter; type = MS_SQL_DATA_WRITER; } component { className = org.jetel.component.MysqlDataWriter; name = MySQLDataWriter; type = MYSQL_DATA_WRITER; } component { className = org.jetel.component.PostgreSqlDataWriter; name = PostgreSQLDataWriter; type = POSTGRESQL_DATA_WRITER; } component { className = org.jetel.component.InfobrightDataWriter; name = InfobrightDataWriter; type = INFOBRIGHT_DATA_WRITER; } DEBUG [main] - Plugin org.jetel.hadoop loaded. id - org.jetel.hadoop version - 4.7.0 provider-name - Javlin a.s. connection { className = org.jetel.hadoop.connection.HadoopConnection; type = HADOOP; } component { className = org.jetel.hadoop.component.HadoopWriter; name = HadoopWriter; type = HADOOP_WRITER; } component { className = org.jetel.hadoop.component.HadoopReader; name = HadoopReader; type = HADOOP_READER; } urlResolver { className = org.jetel.hadoop.service.filesystem.HadoopPathResolver; type = HADOOP_HDFS; } DEBUG [main] - Plugin org.jetel.smb2 loaded. id - org.jetel.smb2 version - 4.7.0 provider-name - Javlin a.s. urlResolver { className = org.jetel.util.protocols.smb2.SMB2PathResolver; type = SMB2; } DEBUG [main] - Plugin com.cloveretl.tableau.TableauWriter loaded. id - com.cloveretl.tableau.TableauWriter version - 4.7.0 provider-name - Javlin, a.s. component { className = com.cloveretl.tableau.TableauWriter; name = TableauWriter; type = TABLEAU_WRITER; } DEBUG [main] - Plugin org.jetel.thirdparty loaded. id - org.jetel.thirdparty version - 4.7.0 provider-name - Javlin a.s. component { className = org.jetel.component.Filter; name = Filter; type = FILTER; } component { className = com.linagora.component.LdapReader; name = LDAPReader; type = LDAP_READER; } component { className = com.linagora.component.LdapWriter; name = LDAPWriter; type = LDAP_WRITER; } INFO [main] - Graph definition file: migration.grf INFO [main] - Checking graph configuration... WARN [main] - Graph configuration is invalid. ERROR [main] - Error during graph initialization ! Graph configuration is invalid. Issue in component [DBOutputTable:DBOUTPUT_TABLE] Cannot connect to the DB: java.lang.NullPointerException Unexpected null value. ERROR [main] - Error details: Element [1516149394050:migration]-Graph configuration is invalid. at org.jetel.graph.runtime.EngineInitializer.checkConfig(EngineInitializer.java:282) at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:266) at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:250) at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:240) at org.jetel.main.runGraph.runGraph(runGraph.java:445) at org.jetel.main.runGraph.main(runGraph.java:413) Caused by: org.jetel.exception.ConfigurationException: Issue in component [DBOutputTable:DBOUTPUT_TABLE] at org.jetel.exception.ConfigurationProblem.toException(ConfigurationProblem.java:154) at org.jetel.exception.ConfigurationStatus.toException(ConfigurationStatus.java:183) ... 6 more Caused by: org.jetel.exception.JetelRuntimeException at org.jetel.exception.ConfigurationException.<init>(ConfigurationException.java:43) ... 8 more Caused by: org.jetel.exception.JetelRuntimeException: Cannot connect to the DB: java.lang.NullPointerException at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnectionImpl.java:903) at org.jetel.connection.jdbc.DBConnectionImpl.connect(DBConnectionImpl.java:926) at org.jetel.connection.jdbc.DBConnectionImpl.getConnection(DBConnectionImpl.java:362) at org.jetel.component.DBOutputTable.checkConfig(DBOutputTable.java:1255) at org.jetel.graph.Phase.checkConfig(Phase.java:339) at org.jetel.graph.TransformationGraph.checkConfig(TransformationGraph.java:1354) at org.jetel.graph.runtime.EngineInitializer.checkConfig(EngineInitializer.java:279) ... 5 more Caused by: java.sql.SQLException: java.lang.NullPointerException at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1074) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3593) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2534) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) at org.jetel.connection.jdbc.specific.impl.AbstractJdbcSpecific.connect(AbstractJdbcSpecific.java:111) at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnectionImpl.java:901) ... 11 more Caused by: java.lang.NullPointerException at java.util.TreeMap.put(TreeMap.java:563) at com.mysql.jdbc.Util.resultSetToMap(Util.java:508) at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1004) ... 25 more ERROR [main] - --------------------------------- Error details ---------------------------------- Error during graph initialization ! Graph configuration is invalid. Issue in component [DBOutputTable:DBOUTPUT_TABLE] Cannot connect to the DB: java.lang.NullPointerException Unexpected null value. ----------------------------------------------------------------------------------
Ist der Fehler vielleicht jemandem ein Begriff? Ich komme nicht weiter. 🙁
Danke und beste Grüße
Schmitti