db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Ward (JIRA)" <j...@apache.org>
Subject [jira] Closed: (DERBY-4333) Exception in getMaxRows() after NullPointerException in SQLClob.readExternal() during query in table with CLOB column
Date Tue, 04 Aug 2009 12:18:15 GMT

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

Jason Ward closed DERBY-4333.

verified fixed in

> Exception in getMaxRows() after NullPointerException in  SQLClob.readExternal() during
query in table with CLOB column
> ----------------------------------------------------------------------------------------------------------------------
>                 Key: DERBY-4333
>                 URL: https://issues.apache.org/jira/browse/DERBY-4333
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:
>            Reporter: Jason Ward
>            Assignee: Kristian Waagan
>             Fix For:,
>         Attachments: derby.log, derby_10.5_debug.zip
> Observed derby throwing exception in getMaxRows() when querying table with greater
than ~20K rows and CLOB column.
> The exception is : 
> java.sql.SQLException: No current connection.
> 	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.Statement.getMaxRows(Unknown Source)
> 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1200)
> 	at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298)
> 	at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)
> 	at org.hibernate.loader.Loader.getResultSet(Loader.java:1826)
> 	at org.hibernate.loader.Loader.doQuery(Loader.java:697)
> 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
> 	at org.hibernate.loader.Loader.doList(Loader.java:2232)
> 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
> 	at org.hibernate.loader.Loader.list(Loader.java:2124)
> 	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
> 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)
> 	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
> 	at com.jw.TestMain.query(TestMain.java:175)
> 	at com.jw.TestMain.main(TestMain.java:189)
> Caused by: org.apache.derby.client.am.SqlException: No current connection.
> 	at org.apache.derby.client.am.Statement.checkForClosedStatement(Unknown Source)
> In digging into the stacktrace a little more it seems that hibernates call to getMaxRows()
blows up because checkForClosedStatement() throws the SQLException, but I have no idea why.
(I've verified the connection is open prior to executing hibenates list(), and it happens
too quickly to be a true timeout.) 
> It only happens once my table reaches any significant size ( > 20K rows), and only
on this particular table which includes a CLOB column. 
> Curiously does not exhibit this behavior. 
> I have prepared a small eclipse project which repros the error and will attach.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message