openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexey Ousov (JIRA)" <>
Subject [jira] Created: (OPENJPA-775) Some Firedird setup tricks
Date Wed, 19 Nov 2008 04:02:44 GMT
Some Firedird setup tricks

                 Key: OPENJPA-775
             Project: OpenJPA
          Issue Type: Improvement
          Components: docs
    Affects Versions: 1.2.0, 1.1.0
            Reporter: Alexey Ousov
            Priority: Minor

When using OpenJPA with Firebird JDBC drivers after version "1.5.6", due to this driver fix: the following exception will be thrown:
org.firebirdsql.jdbc.FBSQLException: The result set is closed
       at org.firebirdsql.jdbc.AbstractResultSet.checkCursorMove(
       at org.apache.openjpa.jdbc.sql.ResultSetResult.nextInternal(
       at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.nextInternal(
       at org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrategy.load(
       at org.apache.openjpa.jdbc.meta.FieldMapping.load(
       at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(
       ... 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:
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"
  userName="SYSDBA" password="masterkey"
  database="M:\Lib\__Data\firebird\TE-FULL.gdb" defaultResultSetHoldable="true"

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message