[go: up one dir, main page]

Menu

#22 Oracle TIMESTAMP export TIMESTAMP(6) WITH TIME ZONE as oracle.sql.TIMESTAMPTZ@1d314263 which can' be imported

v1.0_(example)
pending-fixed
nobody
5
2017-10-18
2017-10-05
Anonymous
No

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>

Discussion

  • Ralf Wisser

    Ralf Wisser - 2017-10-18

    Fixed in release 7.5.2

     
  • Ralf Wisser

    Ralf Wisser - 2017-10-18
    • status: open --> pending-fixed
     

Anonymous
Anonymous

Add attachments
Cancel