Kristian/Rick I've included 2 attachments. One is the full stack trace for the NullPointerException. The other is the file the call is trying to use. The file is zero bytes and does not contain any characters. Our platform is Windows and we are using Java to run the call. Below is the full import call.
CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('SA', 'CHACRGE',
'C:\bea\projects\claims-dev\unzippedclaims\CHACRGE.rcsv','|','``',null,1)
Thanks
Jessica Allgeyer
(513) 763 - 8523
-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Wednesday, November 04, 2009 9:14 AM
To: Derby Discussion
Cc: Combs, Jeremy; McGrath, Phil; Ritchie, Erin; Lewis, Chris; Allgeyer, Jessica
Subject: Re: Upgrading Issues
Allgeyer, Jessica wrote:
> Recently we have upgraded our Derby DB from 10.3.1.4 to 10.5.3.0. With the
> latest version, api CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE is throwing the error
> 'java.lang.NullPointerException' when a file is empty. After investigation,
> any version above our previous version of 10.3.1.4 causes this error. Can you
> provide us with a solution or adjustments we need to make on our end? Please
> let me know if you need more information provided.
>
>
Hello Jessica,
I'm not able to reproduce with neither 10.5 nor the development trunk, so more
information would be useful.
(Just noticed Rick reporting the same.)
I simply tried importing a file of size zero bytes, and that worked (i.e.
nothing happened).
Some suggestions:
- Can you provide the stack trace from the NullPointerException?
(remove traces you don't want to reveal if necessary)
- Is the file zero bytes, or is there at least one character/byte (visible or
non-visible) in there?
- Can you specify the full import call?
- What's your platform? Do you already now that the bug occurs at any platform?
The best thing you can do is to provide a small repro script :)
Regards,
--
Kristian
> Thanks
> Jessica Allgeyer
> (513) 763 - 8523
>
>
>
>
>
>
> **********************************************************************
> The content of this e-mail message and any attachments are
> confidential and may be legally privileged, intended solely for the
> addressee. If you are not the intended recipient, be advised that any
> use, dissemination, distribution, or copying of this e-mail is
> strictly prohibited. If you receive this message in error, please
> notify the sender immediately by reply email and destroy the message
> and its attachments.
> **********************************************************************
>
>
********************************************************************** The
content of this e-mail message and any attachments are confidential and may be
legally privileged, intended solely for the addressee. If you are not the
intended recipient, be advised that any use, dissemination, distribution, or
copying of this e-mail is strictly prohibited. If you receive this message in
error, please notify the sender immediately by reply email and destroy the
message and its attachments.
**********************************************************************
CHACRGE.rcsv
Description: CHACRGE.rcsv
There was a data transfer problem with the database.
Click Details to obtain more information that can be provided to Tech Support.
To copy this entire message, highlight any line and right click for options.
SQL State Code: XIE0R
Error Message: Import error on line 1 of file
C:\bea\projects\claims-dev\unzippedclaims\CHACRGE.rcsv: Java exception: ':
java.lang.NullPointerException'.
Stack Trace:
java.sql.SQLException: Import error on line 1 of file
C:\bea\projects\claims-dev\unzippedclaims\CHACRGE.rcsv: Java exception: ':
java.lang.NullPointerException'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source)
at
com.greatag.claims.standalone.download.DerbyDataLoader.importData(DerbyDataLoader.java:65)
at
com.greatag.claims.standalone.download.DerbyDataLoader.replaceData(DerbyDataLoader.java:49)
at
com.greatag.claims.standalone.download.DerbyDataLoader.process(DerbyDataLoader.java:80)
at
com.greatag.claims.standalone.download.ClaimsDownloadDataInstaller.processDownloadedFile(ClaimsDownloadDataInstaller.java:116)
at
com.greatag.claims.standalone.download.ClaimsDownloadDataInstaller.storeData(ClaimsDownloadDataInstaller.java:77)
at
com.greatag.claims.standalone.download.ClaimsDownloadProcessor.performDownload(ClaimsDownloadProcessor.java:52)
at
com.greatag.claims.standalone.ui.DownloadClaimsHandler.run(DownloadClaimsHandler.java:105)
Caused by: java.sql.SQLException: Java exception: ':
java.lang.NullPointerException'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at org.apache.derby.impl.load.Import.performImport(Unknown Source)
at org.apache.derby.impl.load.Import.importTable(Unknown Source)
at org.apache.derby.catalog.SystemProcedures.SYSCS_IMPORT_TABLE(Unknown
Source)
at
org.apache.derby.exe.ac34cc0261x0124xbae6x7f2cx00000bf080be3f.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 11 more
Caused by: java.lang.NullPointerException
at org.apache.derby.impl.sql.execute.InsertResultSet.emptyIndexes(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.updateAllIndexes(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.bulkInsertCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 26 more
