Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#64 NPE in TransferTool (Oracle -> HSQLDB)

open
nobody
None
6
2009-08-22
2009-08-20
I S
No

HSQLDB 1.9 RC4

I have tried to transfer an oracle schema to hsqldb, but it does not work.

using the Oracle helper
simple init of OracleTransferHelper
dateFormatStmnt: ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'
java.lang.NullPointerException
at org.hsqldb.util.TransferDb.getTableStructure(TransferDb.java:763)
at org.hsqldb.util.TransferTable.extractTableStructure(TransferTable.java:138)
at org.hsqldb.util.Transfer.RefreshMainDisplay(Transfer.java:515)
at org.hsqldb.util.Transfer.ProcessNextStep(Transfer.java:758)
at org.hsqldb.util.Transfer.actionPerformed(Transfer.java:828)
at java.awt.Button.processActionEvent(Unknown Source)
at java.awt.Button.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Discussion

  • I S
    I S
    2009-08-20

    • priority: 5 --> 6
     
  • I S
    I S
    2009-08-20

    Exception reading source tables: java.lang.NullPointerException

     
  • I S
    I S
    2009-08-20

    • assigned_to: nobody --> unsaved
     
  • I S
    I S
    2009-08-20

    • assigned_to: unsaved --> fredt
     
  • I S
    I S
    2009-08-20

    I think the problem is the semicolon at the end of the sSourceSelect statement
    in TransferDb.java line 745

    select_rs = stmt.executeQuery(TTable.Stmts.sSourceSelect);

     
  • Fred Toussi
    Fred Toussi
    2009-08-22

    • labels: 325100 -->
    • milestone: 116102 -->
    • assigned_to: fredt --> nobody