When exporting from Oracle, the resulting insert statements for Timestamp columns is something like :
oracle.sql.TIMESTAMPTZ@1d314263
I've tried several JDBC drivers but the result was alreys the same.
Any suggestions what might be the reason?
Below see some log file entries. If you need something special please let me know.
Thanks
export.log start with:
2017-10-05 08:13:00,502 [jailer-main] INFO - arguments: export extractionmodel/KeyEntry.jm oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@tldb0007vm.bmwgroup.net:1620:stor01i DB_RESOURCE "<password>" -jdbcjar libs/ojdbc6-11.2.0.2.0.jar -e INT1KeyEntryExport.sql -UTF8 -no-rowid -threads 1 -entities 1 -format SQL -schemamapping = -source-schemamapping = -scope SESSION_LOCAL -datamodel datamodel/INT2
2017-10-05 08:13:00,507 [jailer-main] INFO - Jailer 7.4
2017-10-05 08:13:00,519 [jailer-main] INFO - exporting 'file:/Users/petraL/Applications/jailer/extractionmodel/KeyEntry.jm' to 'INT1KeyEntryExport.sql'
2017-10-05 08:13:00,671 [jailer-main] INFO - reading file 'tmp/up-be25b4ae-c6fa-4aee-a821-e3170711c0d0'
2017-10-05 08:13:01,446 [jailer-main] INFO - 13 statements (100%)
2017-10-05 08:13:01,446 [jailer-main] INFO - successfully read file 'tmp/up-be25b4ae-c6fa-4aee-a821-e3170711c0d0'
2017-10-05 08:13:01,447 [jailer-main] INFO - SQLDialect [needsValuesKeywordForDeletes=false, supportsInClauseForDeletes=true, supportsMultiRowInserts=false, upsertMode=MERGE]
2017-10-05 08:13:01,455 [jailer-main] INFO - gather statistics after 0 inserted rows...</password>
jailer.log:
2017-10-05 08:12:02,143 [AWT-EventQueue-0] INFO - added '[file:/Users/petraL/Applications/jailer/libs/ojdbc6-11.2.0.2.0.jar]' to classpath
2017-10-05 08:12:21,091 [AWT-EventQueue-0] INFO - set auto commit to true
2017-10-05 08:12:21,121 [AWT-EventQueue-0] INFO - can't set isolation level to UR. Reason: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels
2017-10-05 08:12:21,121 [AWT-EventQueue-0] INFO - driver name: Oracle JDBC driver
2017-10-05 08:12:21,121 [AWT-EventQueue-0] INFO - driver version: 11.2.0.2.0
2017-10-05 08:12:21,121 [AWT-EventQueue-0] INFO - DB name: Oracle (net.sf.jailer.configuration.DBMS@8b70f17e)
2017-10-05 08:12:21,121 [AWT-EventQueue-0] INFO - DB version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
2017-10-05 08:13:00,089 [AWT-EventQueue-0] INFO - set auto commit to true
2017-10-05 08:13:00,090 [AWT-EventQueue-0] INFO - can't set isolation level to UR. Reason: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels
2017-10-05 08:13:00,090 [AWT-EventQueue-0] INFO - driver name: Oracle JDBC driver
2017-10-05 08:13:00,090 [AWT-EventQueue-0] INFO - driver version: 11.2.0.2.0
2017-10-05 08:13:00,090 [AWT-EventQueue-0] INFO - DB name: Oracle (net.sf.jailer.configuration.DBMS@8b70f17e)
2017-10-05 08:13:00,090 [AWT-EventQueue-0] INFO - DB version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
2017-10-05 08:13:00,091 [AWT-EventQueue-0] INFO - Select jvalue from JAILER_CONFIG where jkey='magic' and jvalue='837065098274756382534403654245288'
2017-10-05 08:13:00,124 [AWT-EventQueue-0] INFO - 1 row(s)
2017-10-05 08:13:00,125 [AWT-EventQueue-0] INFO - closing connection...
2017-10-05 08:13:00,128 [AWT-EventQueue-0] INFO - connection closed
2017-10-05 08:13:00,145 [AWT-EventQueue-0] INFO - closing connection...
2017-10-05 08:13:00,148 [AWT-EventQueue-0] INFO - connection closed
2017-10-05 08:13:00,271 [AWT-EventQueue-0] INFO - set auto commit to true
2017-10-05 08:13:00,271 [AWT-EventQueue-0] INFO - can't set isolation level to UR. Reason: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels
2017-10-05 08:13:00,271 [AWT-EventQueue-0] INFO - driver name: Oracle JDBC driver
2017-10-05 08:13:00,271 [AWT-EventQueue-0] INFO - driver version: 11.2.0.2.0
2017-10-05 08:13:00,271 [AWT-EventQueue-0] INFO - DB name: Oracle (net.sf.jailer.configuration.DBMS@8b70f17e)
2017-10-05 08:13:00,271 [AWT-EventQueue-0] INFO - DB version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
2017-10-05 08:13:00,271 [AWT-EventQueue-0] INFO - Select jvalue from JAILER_CONFIG where jkey='magic' and jvalue='837065098274756382534403654245288'
2017-10-05 08:13:00,275 [AWT-EventQueue-0] INFO - 1 row(s)
2017-10-05 08:13:00,275 [AWT-EventQueue-0] INFO - closing connection...
2017-10-05 08:13:00,277 [AWT-EventQueue-0] INFO - connection closed
2017-10-05 08:13:00,502 [jailer-main] INFO - arguments: export extractionmodel/KeyEntry.jm oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@tldb0007vm.bmwgroup.net:1620:stor01i DB_RESOURCE "<password>" -jdbcjar libs/ojdbc6-11.2.0.2.0.jar -e INT1KeyEntryExport.sql -UTF8 -no-rowid -threads 1 -entities 1 -format SQL -schemamapping = -source-schemamapping = -scope SESSION_LOCAL -datamodel datamodel/INT2
2017-10-05 08:13:00,507 [jailer-main] INFO - Jailer 7.4
2017-10-05 08:13:00,519 [jailer-main] INFO - exporting 'file:/Users/petraL/Applications/jailer/extractionmodel/KeyEntry.jm' to 'INT1KeyEntryExport.sql'
2017-10-05 08:13:00,643 [jailer-main] INFO - set auto commit to true
2017-10-05 08:13:00,644 [jailer-main] INFO - can't set isolation level to UR. Reason: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels
2017-10-05 08:13:00,644 [jailer-main] INFO - driver name: Oracle JDBC driver
2017-10-05 08:13:00,644 [jailer-main] INFO - driver version: 11.2.0.2.0
2017-10-05 08:13:00,644 [jailer-main] INFO - DB name: Oracle (net.sf.jailer.configuration.DBMS@8b70f17e)
2017-10-05 08:13:00,644 [jailer-main] INFO - DB version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
2017-10-05 08:13:00,671 [jailer-main] INFO - reading file 'tmp/up-be25b4ae-c6fa-4aee-a821-e3170711c0d0'</password>
Anonymous
Fixed in release 7.5.2