You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Catalina Wei (JIRA)" <ji...@apache.org> on 2009/01/09 01:08:59 UTC
[jira] Created: (OPENJPA-853) Informix cursor not open problem if
synchronizeMapping set true
Informix cursor not open problem if synchronizeMapping set true
---------------------------------------------------------------
Key: OPENJPA-853
URL: https://issues.apache.org/jira/browse/OPENJPA-853
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Affects Versions: 1.2.0
Reporter: Catalina Wei
Assignee: Catalina Wei
Informix JDBC driver default resultSet Holdability is 2 (CLOSE_CURSORS_OVER_COMMIT), which causes SQLException :Cursor not open.
<openjpa-1.2.1-SNAPSHOT-r422266:723087 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Cursor not open.
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:771)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:254)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
at com.ibm.ws.query.utils.SetupQueryTestCase.setUpEmpDept(SetupQueryTestCase.java:1359)
at com.ibm.ws.query.utils.SetupQueryTestCase.setUp(SetupQueryTestCase.java:436)
at com.ibm.ws.query.tests.ano.JUBulkUpdateTest.setUp(JUBulkUpdateTest.java:42)
Caused by: java.sql.SQLException: Cursor not open.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:348)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3000)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3310)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2263)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2183)
at com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:1835)
at com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4015)
at com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:533)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.next(DelegatingResultSet.java:106)
at org.apache.openjpa.jdbc.sql.ResultSetResult.nextInternal(ResultSetResult.java:222)
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.nextInternal(SelectImpl.java:2451)
at org.apache.openjpa.jdbc.sql.AbstractResult.next(AbstractResult.java:173)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.next(SelectResultObjectProvider.java:99)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:35)
... 21 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OPENJPA-853) Informix cursor not open problem if
synchronizeMapping set true
Posted by "Catalina Wei (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Catalina Wei resolved OPENJPA-853.
----------------------------------
Resolution: Fixed
Fix Version/s: 2.0.0
1.3.0
1.2.1
fix checked in under OpenJPA svn:
trunk - r733204,
1.3.x - r733205
1.2.x - r733206
> Informix cursor not open problem if synchronizeMapping set true
> ---------------------------------------------------------------
>
> Key: OPENJPA-853
> URL: https://issues.apache.org/jira/browse/OPENJPA-853
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 1.2.0
> Reporter: Catalina Wei
> Assignee: Catalina Wei
> Fix For: 1.2.1, 1.3.0, 2.0.0
>
>
> Informix JDBC driver default resultSet Holdability is 2 (CLOSE_CURSORS_OVER_COMMIT), which causes SQLException :Cursor not open.
> <openjpa-1.2.1-SNAPSHOT-r422266:723087 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Cursor not open.
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
> at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
> at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:771)
> at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:254)
> at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
> at com.ibm.ws.query.utils.SetupQueryTestCase.setUpEmpDept(SetupQueryTestCase.java:1359)
> at com.ibm.ws.query.utils.SetupQueryTestCase.setUp(SetupQueryTestCase.java:436)
> at com.ibm.ws.query.tests.ano.JUBulkUpdateTest.setUp(JUBulkUpdateTest.java:42)
> Caused by: java.sql.SQLException: Cursor not open.
> at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:348)
> at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3000)
> at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3310)
> at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2263)
> at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2183)
> at com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:1835)
> at com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4015)
> at com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:533)
> at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
> at org.apache.openjpa.lib.jdbc.DelegatingResultSet.next(DelegatingResultSet.java:106)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.nextInternal(ResultSetResult.java:222)
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.nextInternal(SelectImpl.java:2451)
> at org.apache.openjpa.jdbc.sql.AbstractResult.next(AbstractResult.java:173)
> at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.next(SelectResultObjectProvider.java:99)
> at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:35)
> ... 21 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.