com.ibm.db2.jcc.c.SQLException

java.sql.Connection.close() requested while a transaction is in progress on the connection.The transaction remains active, and the connection cannot be closed.

Solutions on the web3

  • via Oracle Community by 3004, 1 year ago
    java.sql.Connection.close() requested while a transaction is in progress on the connection.The transaction remains active, and the connection cannot be closed.
  • via Oracle Community by 3004, 1 year ago
    Invalid argument: paramet er index 3 is out of range.
  • via Google Groups by Michael Lu, 1 month ago
    Invalid argument: parameter index 3 is out of range.
  • Stack trace

    • com.ibm.db2.jcc.c.SQLException: java.sql.Connection.close() requested while a transaction is in progress on the connection.The transaction remains active, and the connection cannot be closed. at com.ibm.db2.jcc.c.l.j(l.java:575) at com.ibm.db2.jcc.c.l.close(l.java:559) at com.solarmetric.datasource.ConnectionWrapper.close(ConnectionWrapper.java:288) at com.solarmetric.datasource.DataSourceImpl$AbstractPool.close(DataSourceImpl.java:711) at com.solarmetric.datasource.DataSourceImpl.close(DataSourceImpl.java:356) at com.solarmetric.datasource.DataSourceImpl.close(DataSourceImpl.java:330) at com.solarmetric.datasource.PoolConnection.close(PoolConnection.java:70) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.close(SQLExecutionManagerImpl.java:890) at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.release(JDBCStoreManager.java:797) at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager$2.free(JDBCStoreManager.java:879) at com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.free(LazyResultList.java:411) at com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.checkComplete(LazyResultList.java:310) at com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.instantiateRow(LazyResultList.java:207) at com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.get(LazyResultList.java:142) at java.util.AbstractList$Itr.next(AbstractList.java:431) at com.solarmetric.kodo.runtime.objectprovider.ResultListIterator.next(ResultListIterator.java:49) at com.solarmetric.kodo.impl.jdbc.runtime.ResultListFactory.createResultList(ResultListFactory.java:107) at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.executeQuery(JDBCStoreManager.java:864) at com.solarmetric.kodo.impl.jdbc.ormapping.ClassMapping.getExtentResultList(ClassMapping.java:1083) at com.solarmetric.kodo.impl.jdbc.runtime.JDBCExtent.getResultList(JDBCExtent.java:71) at com.solarmetric.kodo.impl.jdbc.runtime.JDBCExtent.getIterator(JDBCExtent.java:47) at com.solarmetric.kodo.runtime.ExtentImpl$MultipleSubclassIterator.newIterator(ExtentImpl.java:344) at serp.util.MultiIterator.setIterator(MultiIterator.java:74) at serp.util.MultiIterator.hasNext(MultiIterator.java:29) at serp.util.LookaheadIterator.setNext(LookaheadIterator.java:133) at serp.util.LookaheadIterator.initialize(LookaheadIterator.java:118) at serp.util.LookaheadIterator.hasNext(LookaheadIterator.java:48) at serp.util.MultiIterator.setIterator(MultiIterator.java:73) at serp.util.MultiIterator.hasNext(MultiIterator.java:29) at com.solarmetric.kodo.runtime.ExtentImpl$TransactionAwareIterator.hasNext(ExtentImpl.java:403) at au.com.aig.aiaa.jdoDemo.StandaloneJDODemo.findAllItems(StandaloneJDODemo.java:103) at au.com.aig.aiaa.jdoDemo.StandaloneJDODemo.main(StandaloneJDODemo.java:176)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.