Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.1.0, 1.2.0
    • Fix Version/s: 1.3.0, 2.0.0-M2
    • Component/s: docs
    • Labels:
      None

      Description

      When using OpenJPA with Firebird JDBC drivers after version "1.5.6", due to this driver fix: http://tracker.firebirdsql.org/browse/JDBC-91 the following exception will be thrown:
      org.firebirdsql.jdbc.FBSQLException: The result set is closed
      at org.firebirdsql.jdbc.AbstractResultSet.checkCursorMove(AbstractResultSet.java:217)
      at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:249)
      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:2285)
      at org.apache.openjpa.jdbc.sql.AbstractResult.next(AbstractResult.java:169)
      at org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrategy.load(StoreCollectionFieldStrategy.java:476)
      at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:802)
      at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:520)
      ... 14 more

      To use OpenJPA with new Firedird JDBC drivers, defaultResultSetHoldable argument should be set to overcome the issue. It can be either set in JDBC url as follows:
      jdbc:firebirdsql:embedded:M:/Lib/__Data/firebird/TE-FULL.gdb?defaultResultSetHoldable=True
      Or it can be passed as a parameter to Firebird data source. For examle setting Firebird XA connection pool in Apache Tomcat 5.5 looks like:
      <Resource name="jdbc/ODEdatabaseConnection" auth="Container" scope="Shareable"
      factory="org.firebirdsql.pool.FBConnectionPoolDataSource"
      type="org.firebirdsql.pool.FBConnectionPoolDataSource"
      userName="SYSDBA" password="masterkey"
      database="M:\Lib__Data\firebird\TE-FULL.gdb" defaultResultSetHoldable="true"
      nonStandard="type=embedded"/>

        Issue Links

          Activity

          Alexey Ousov created issue -
          Milosz Tylenda made changes -
          Field Original Value New Value
          Link This issue is related to OPENJPA-853 [ OPENJPA-853 ]
          Milosz Tylenda made changes -
          Link This issue is part of OPENJPA-983 [ OPENJPA-983 ]
          Hide
          Milosz Tylenda added a comment -

          The dictionary attached to OPENJPA-983 fixes this problem by setting supportsMultipleNontransactionalResultSets = false.

          Show
          Milosz Tylenda added a comment - The dictionary attached to OPENJPA-983 fixes this problem by setting supportsMultipleNontransactionalResultSets = false.
          Hide
          Milosz Tylenda added a comment -

          Resolved in OPENJPA-983.

          Show
          Milosz Tylenda added a comment - Resolved in OPENJPA-983 .
          Milosz Tylenda made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 1.3.0 [ 12313326 ]
          Fix Version/s 2.0.0 [ 12313483 ]
          Resolution Fixed [ 1 ]
          Donald Woods made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Resolved Resolved
          142d 14h 59m 1 Milosz Tylenda 10/Apr/09 20:01
          Resolved Resolved Closed Closed
          332d 23h 29m 1 Donald Woods 09/Mar/10 18:31

            People

            • Assignee:
              Unassigned
              Reporter:
              Alexey Ousov
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development