You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Shelly McGowan (JIRA)" <ji...@apache.org> on 2008/05/01 17:26:55 UTC
[jira] Commented: (DERBY-3464) NPE is seemingly simple query
[ https://issues.apache.org/jira/browse/DERBY-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12593556#action_12593556 ]
Shelly McGowan commented on DERBY-3464:
---------------------------------------
This is fixed in 10.4 but would be interesting to know the "duplicate" or related issue to the resolution as Kathey notes above.
> NPE is seemingly simple query
> -----------------------------
>
> Key: DERBY-3464
> URL: https://issues.apache.org/jira/browse/DERBY-3464
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.4
> Reporter: Steve Ebersole
>
> Not sure if this is specifically a regression caused by DERBY-1624, however I noticed this as a regression to our tests in an attempt to verify the fixes for DERBY-1624 with release 10.3.1.4.
> The offending query seems very simple and innocuous:
> select count(customer0_.ID) as col_0_0_ from CUSTOMER_TABLE customer0_ group by customer0_.code having customer0_.code in ('GBR' , 'CHA')
> leading the the following NPE:
> 2008-02-25 14:55:56,062 DEBUG [org.hibernate.util.JDBCExceptionReporter:69] could not execute query [select count(customer0_.ID) as col_0_0_ from CUSTOMER_TABLE customer0_ group by customer0_.code having customer0_.code in ('GBR' , 'CHA')]
> java.sql.SQLException: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
> at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> at org.apache.derby.client.am.PreparedStatement.executeQuery(Unknown Source)
> at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:235)
> at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
> at org.hibernate.loader.Loader.doQuery(Loader.java:674)
> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
> at org.hibernate.loader.Loader.doList(Loader.java:2220)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
> at org.hibernate.loader.Loader.list(Loader.java:2099)
> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
> at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
> at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
> at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)
> at com.sun.ts.tests.ejb30.persistence.query.language.Client.test_groupByHaving(Client.java:5197)
> Caused by: org.apache.derby.client.am.SqlException: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
> at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
> at org.apache.derby.client.net.NetStatementReply.parseOpenQueryError(Unknown Source)
> at org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(Unknown Source)
> at org.apache.derby.client.net.NetStatementReply.readOpenQuery(Unknown Source)
> at org.apache.derby.client.net.StatementReply.readOpenQuery(Unknown Source)
> at org.apache.derby.client.net.NetStatement.readOpenQuery_(Unknown Source)
> at org.apache.derby.client.am.Statement.readOpenQuery(Unknown Source)
> at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
> at org.apache.derby.client.am.PreparedStatement.executeQueryX(Unknown Source)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.