You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Alexey Ousov (JIRA)" <ji...@apache.org> on 2008/11/19 05:02:44 UTC
[jira] Created: (OPENJPA-775) Some Firedird setup tricks
Some Firedird setup tricks
--------------------------
Key: OPENJPA-775
URL: https://issues.apache.org/jira/browse/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: 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"/>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OPENJPA-775) Some Firedird setup tricks
Posted by "Milosz Tylenda (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Milosz Tylenda resolved OPENJPA-775.
------------------------------------
Resolution: Fixed
Fix Version/s: 2.0.0
1.3.0
Resolved in OPENJPA-983.
> Some Firedird setup tricks
> --------------------------
>
> Key: OPENJPA-775
> URL: https://issues.apache.org/jira/browse/OPENJPA-775
> Project: OpenJPA
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.1.0, 1.2.0
> Reporter: Alexey Ousov
> Priority: Minor
> Fix For: 1.3.0, 2.0.0
>
>
> 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"/>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.