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.

Oracle Community | 3004 | 1 decade ago
  1. 0

    Simple query problem

    Oracle Community | 1 decade ago | 3004
    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.
  2. 0

    Please help: cmp with DB2 type 4 driver problem

    Google Groups | 1 decade ago | Michael Lu
    com.ibm.db2.jcc.c.SQLException: Invalid argument: parameter index 3 is out of range.
  3. 0

    Please help: cmp with DB2 type 4 driver problem

    Oracle Community | 1 decade ago | 3004
    com.ibm.db2.jcc.c.SQLException: Invalid argument: parameter index 3 is out of range.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Please help: cmp with DB2 type 4 driver problem

    Google Groups | 1 decade ago | Michael Lu
    com.ibm.db2.jcc.c.SQLException: Invalid argument: paramet er index 3 is out of range.
  6. 0

    Please help: cmp with DB2 type 4 driver problem

    Oracle Community | 1 decade ago | 3004
    com.ibm.db2.jcc.c.SQLException: Invalid argument: parameter index 3 is out of range.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. com.ibm.db2
      l.close
      1. com.ibm.db2.jcc.c.l.j(l.java:575)
      2. com.ibm.db2.jcc.c.l.close(l.java:559)
      2 frames
    3. com.solarmetric.datasource
      PoolConnection.close
      1. com.solarmetric.datasource.ConnectionWrapper.close(ConnectionWrapper.java:288)
      2. com.solarmetric.datasource.DataSourceImpl$AbstractPool.close(DataSourceImpl.java:711)
      3. com.solarmetric.datasource.DataSourceImpl.close(DataSourceImpl.java:356)
      4. com.solarmetric.datasource.DataSourceImpl.close(DataSourceImpl.java:330)
      5. com.solarmetric.datasource.PoolConnection.close(PoolConnection.java:70)
      5 frames
    4. com.solarmetric.kodo
      LazyResultList.get
      1. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.close(SQLExecutionManagerImpl.java:890)
      2. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.release(JDBCStoreManager.java:797)
      3. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager$2.free(JDBCStoreManager.java:879)
      4. com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.free(LazyResultList.java:411)
      5. com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.checkComplete(LazyResultList.java:310)
      6. com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.instantiateRow(LazyResultList.java:207)
      7. com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.get(LazyResultList.java:142)
      7 frames
    5. Java RT
      AbstractList$Itr.next
      1. java.util.AbstractList$Itr.next(AbstractList.java:431)
      1 frame
    6. com.solarmetric.kodo
      ExtentImpl$MultipleSubclassIterator.newIterator
      1. com.solarmetric.kodo.runtime.objectprovider.ResultListIterator.next(ResultListIterator.java:49)
      2. com.solarmetric.kodo.impl.jdbc.runtime.ResultListFactory.createResultList(ResultListFactory.java:107)
      3. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.executeQuery(JDBCStoreManager.java:864)
      4. com.solarmetric.kodo.impl.jdbc.ormapping.ClassMapping.getExtentResultList(ClassMapping.java:1083)
      5. com.solarmetric.kodo.impl.jdbc.runtime.JDBCExtent.getResultList(JDBCExtent.java:71)
      6. com.solarmetric.kodo.impl.jdbc.runtime.JDBCExtent.getIterator(JDBCExtent.java:47)
      7. com.solarmetric.kodo.runtime.ExtentImpl$MultipleSubclassIterator.newIterator(ExtentImpl.java:344)
      7 frames
    7. Serp
      MultiIterator.hasNext
      1. serp.util.MultiIterator.setIterator(MultiIterator.java:74)
      2. serp.util.MultiIterator.hasNext(MultiIterator.java:29)
      3. serp.util.LookaheadIterator.setNext(LookaheadIterator.java:133)
      4. serp.util.LookaheadIterator.initialize(LookaheadIterator.java:118)
      5. serp.util.LookaheadIterator.hasNext(LookaheadIterator.java:48)
      6. serp.util.MultiIterator.setIterator(MultiIterator.java:73)
      7. serp.util.MultiIterator.hasNext(MultiIterator.java:29)
      7 frames
    8. com.solarmetric.kodo
      ExtentImpl$TransactionAwareIterator.hasNext
      1. com.solarmetric.kodo.runtime.ExtentImpl$TransactionAwareIterator.hasNext(ExtentImpl.java:403)
      1 frame
    9. au.com.aig
      StandaloneJDODemo.main
      1. au.com.aig.aiaa.jdoDemo.StandaloneJDODemo.findAllItems(StandaloneJDODemo.java:103)
      2. au.com.aig.aiaa.jdoDemo.StandaloneJDODemo.main(StandaloneJDODemo.java:176)
      2 frames