Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: java.sql.SQLException: Closed Connection: next

    I am encoutering the following exception:
    java.sql.SQLException: Closed Connection: next

    My code calls a Oracle stored procedure which returns a cursor back with the results of some queries. The procedure also does some inserts in to audit tables which are commited by the App Server Transaction container as part of the EJB. The retrieved cursor is processed in the EJB which takes quite some time before the JDBC statement object is closed and the container commits the transaction.

    Below is the stack trace of the exception:

    java.sql.SQLException: Closed Connection: next
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE
    at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava:1130)
    at com.syntegra.nasp.etpadmin.db.DBAccessor.selectRec ords(
    at com.syntegra.nasp.etpadmin.extract.MainClass.extra ctRecords(
    at com.syntegra.nasp.etpadmin.service.ETPAdminBean.ex tractRecords(
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unkno wn Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De
    at java.lang.reflect.Method.invoke(
    at com.sun.ejb.containers.EJBLocalObjectInvocationHan dler.invoke( 28)
    at $Proxy9.extractRecords(Unknown Source)

    Please help me!!

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts