db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavel Bortnovskiy <PBortnovs...@Jefferies.com>
Subject Re: NullPointerException deep in Derby
Date Wed, 09 Feb 2011 15:49:35 GMT
Additional information:

the message "executing statement after shutdown" is misleading. There was 
no shutdown occurring and the connection was open and valid.

Our query (which I cannot show here for now) was complex, with case 
statements and group by.
Interestingly, as soon as the query was reworked to remove group by 
clause, the code worked flawlessly.

P.



From:
Pavel Bortnovskiy <PBortnovskiy@Jefferies.com>
To:
Derby Discussion <derby-user@db.apache.org>
Date:
02/09/2011 10:43 AM
Subject:
NullPointerException deep in Derby



Hello: 

I just got the following NullPointerException, seemingly inside Derby 
code: 

2011-02-09 10:39:13,576 ERROR DataProcessor  - SQL Exception due to 
executing statement after shutdown 
java.sql.SQLException: The exception 'java.lang.NullPointerException' was 
thrown while evaluating an expression. 
        at 
org.apache.derby.impl.jdbc.SQLExceptionFactory40.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.EmbedResultSet.closeOnTransactionError(Unknown 
Source) 
        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown 
Source) 
        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) 
        at 
com.jefco.processors.DataProcessor.process(DataProcessor.java:189) 
        at java.lang.Thread.run(Thread.java:619) 
Caused by: java.sql.SQLException: The exception 
'java.lang.NullPointerException' was thrown while evaluating an 
expression. 
        at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
Source) 
        at 
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown 
Source) 
        ... 13 more 
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.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown 
Source) 
        at 
org.apache.derby.impl.jdbc.SQLExceptionFactory40.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) 
        ... 10 more 
Caused by: java.lang.NullPointerException 
        at 
org.apache.derby.exe.ac96c5c136x012ex0b13x5d52xffff9ccc25960.e9(Unknown 
Source) 
        at 
org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source) 
        at 
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.doProjection(Unknown 
Source) 
        at 
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown 
Source) 
        at 
org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.getNextRowFromSource(Unknown

Source) 
        at 
org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.getNextRowCore(Unknown 
Source) 
        at 
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown 
Source) 
        ... 5 more 



Jefferies archives and monitors outgoing and incoming e-mail. The contents 
of this email, including any attachments, are confidential to the ordinary 
user of the email address to which it was addressed. If you are not the 
addressee of this email you may not copy, forward, disclose or otherwise 
use it or any part of it in any form whatsoever. This email may be 
produced at the request of regulators or in connection with civil 
litigation. Jefferies accepts no liability for any errors or omissions 
arising as a result of transmission. Use by other than intended recipients 
is prohibited. In the United Kingdom, Jefferies operates as Jefferies 
International Limited; registered in England: no. 1978621; registered 
office: Vintners Place, 68 Upper Thames Street, London EC4V 3BJ. Jefferies 
International Limited is authorised and regulated by the Financial 
Services Authority.





Jefferies archives and monitors outgoing and incoming e-mail. The contents of this email,
including any attachments, are confidential to the ordinary user of the email address to which
it was addressed. If you are not the addressee of this email you may not copy, forward, disclose
or otherwise use it or any part of it in any form whatsoever. This email may be produced at
the request of regulators or in connection with civil litigation. Jefferies accepts no liability
for any errors or omissions arising as a result of transmission. Use by other than intended
recipients is prohibited.  In the United Kingdom, Jefferies operates as Jefferies International
Limited; registered in England: no. 1978621; registered office: Vintners Place, 68 Upper Thames
Street, London EC4V 3BJ.  Jefferies International Limited is authorised and regulated by the
Financial Services Authority.
Mime
View raw message