db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3464) NPE is seemingly simple query
Date Fri, 25 Jul 2008 16:59:31 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kathey Marsden updated DERBY-3464:
----------------------------------

    Component/s: Network Client

I wonder if we can go ahead and close this out as a dup?   Unless I hear back. I will close
it Monday.


> NPE is seemingly simple query
> -----------------------------
>
>                 Key: DERBY-3464
>                 URL: https://issues.apache.org/jira/browse/DERBY-3464
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    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.


Mime
View raw message