From dev-return-11443-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Fri Apr 10 19:02:50 2009 Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 14686 invoked from network); 10 Apr 2009 19:02:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Apr 2009 19:02:50 -0000 Received: (qmail 24483 invoked by uid 500); 10 Apr 2009 19:02:50 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 24407 invoked by uid 500); 10 Apr 2009 19:02:50 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 24376 invoked by uid 99); 10 Apr 2009 19:02:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Apr 2009 19:02:50 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Apr 2009 19:02:36 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id E9E63234C054 for ; Fri, 10 Apr 2009 12:02:14 -0700 (PDT) Message-ID: <359457780.1239390134956.JavaMail.jira@brutus> Date: Fri, 10 Apr 2009 12:02:14 -0700 (PDT) From: "Milosz Tylenda (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Resolved: (OPENJPA-775) Some Firedird setup tricks In-Reply-To: <617825449.1227067364618.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on 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: > 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.