I don't know if you ever found the solution to this post you put up on the
hsqldb-developers list, I didn't see any replies. I hit the same problem
today and dug into the code and found the problem. In the TransferDb.java
class, getTableStructure(TransferTable TTable, DataAccessPoint Dest) method
(near the middle) there is a line that reads:
select_rs =
stmt.executeQuery(TTable.Stmts.sSourceSelect);
which executes a query against the Oracle database using query syntax it
does not seem to like (resulting in the following SQL Exception):
ORA-00911: invalid character
Cause: Special characters are valid only in certain places. If special
characters other than $, _, and # are used in a name and the name is not
enclosed in double quotation marks ("), this message will be issued. One
exception to this rule is for database names; in this case, double quotes
are stripped out and ignored.
Action: Remove the invalid character from the statement or enclose the
object name in double quotation marks.
Basically, it is objecting to the fact that there is a semicolon on the end
of the query. I modified my own code as follows:
select_rs =
stmt.executeQuery(TTable.Stmts.sSourceSelect.substring(0,TTable.Stmts.sSourc
eSelect.length()-1));
to remove the semicolon and things seem to work fine after that. It shows
up as a bland NullPointerException because the exception handling is written
to permit you to continue on uninterrupted after the failure despite never
getting a valid ResultSet in the col variable (there is an 'if' clause in
the catch block).
Perhaps an HSQL developer would be willing to have a look at the situation
and create a real patch?
Jon
>From: Sanjeev Tripathi <[EMAIL PROTECTED]>
>RE: out of memory Error When trying to insert1 million row in to the HSQL
Database
>2005-04-06 15:54 I am getting following error when transferring data from
oracle to
>hsqldb using hsqldb transfer util.
>
> Sanjeev tripathi
>
> 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(Unknown Source)
> at org.hsqldb.util.TransferTable.extractTableStructure(Unknown
Source)
> at org.hsqldb.util.Transfer.RefreshMainDisplay(Unknown Source)
> at org.hsqldb.util.Transfer.ProcessNextStep(Unknown Source)
> at org.hsqldb.util.Transfer.SchemaToSelect(Unknown Source)
> at org.hsqldb.util.Transfer.ProcessNextStep(Unknown Source)
> at org.hsqldb.util.Transfer.CatalogToSelect(Unknown Source)
> at org.hsqldb.util.Transfer.ProcessNextStep(Unknown Source)
> at org.hsqldb.util.Transfer.actionPerformed(Unknown Source)
> at java.awt.Button.processActionEvent(Button.java:382)
> at java.awt.Button.processEvent(Button.java:350)
> at java.awt.Component.dispatchEventImpl(Component.java:3615)
> at java.awt.Component.dispatchEvent(Component.java:3477)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
> at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:201)
> at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:151)
> at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
> at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
-------------------------------------------------------
This SF.Net email is sponsored by: New Crystal Reports XI.
Version 11 adds new functionality designed to reduce time involved in
creating, integrating, and deploying reporting solutions. Free runtime info,
new features, or free trial, at: http://www.businessobjects.com/devxi/728
_______________________________________________
hsqldb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
