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

    DB2 Sample with Transaction Errors

    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

    When creating a new correlation with large resource support an exception is thrown when clicking finish on the dialog

    Eclipse Bugzilla | 1 decade ago | tfoun
    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.
  3. 0

    communication errors - Jazz Forum

    jazz.net | 11 months ago
    com.ibm.db2.jcc.c.SqlException: Invalid operation: Connection is closed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Update exception using JDBC on DB2

    Stack Overflow | 4 years ago | Vitalij Zadneprovskij
    com.ibm.db2.jcc.c.SqlException: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.
  6. 0

    Error when I try to connect to DB2 from JAVA

    Google Groups | 1 decade ago | shivas
    com.ibm.db2.jcc.c.SqlException: IO Exception opening socket to server papdevdb on port 6004. The DB2 Server may be down.

    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.l()
    2. com.ibm.db2
      l.close
      1. com.ibm.db2.jcc.c.l.l(l.java:526)
      2. com.ibm.db2.jcc.c.l.close(l.java:516)
      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:416)
      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. samples.ormapping.oneToMany
      CompanyDemo.main
      1. samples.ormapping.oneToMany.CompanyDemo.runDemo(CompanyDemo.java:67)
      2. samples.ormapping.oneToMany.CompanyDemo.main(CompanyDemo.java:99)
      2 frames