Hi,

I trying to use Firebird with OpenJPA.

I made a small master/detail test.

@Entity
public class Master implements Serializable {

@Id
@Column(name = "MASTERID", nullable = false)
private Long id;

@Column(name = "DESCRIPTION")
private String description;

@OneToMany(mappedBy = "fkMasterId")
private List<Detail> detailCollection;

....

}


@Entity
public class Detail implements Serializable {

@Id
@Column(name = "DETAILID", nullable = false)
private Long id;

@ManyToOne
@JoinColumn(name = "FK_MASTERID", referencedColumnName = "MASTERID")
private Master fkMasterId;

@Column(name = "DESCRIPTION", nullable = false)
private String description;

...
}

Then i have inserted some rows in both table, 'Master' and 'Detail'.
The problem appear when i try to update a row in 'Master' table:

List<Master> masterList = null;
EntityManager em = getEntityManagerFactory().createEntityManager();
try {
Query query = em.createQuery("SELECT m FROM Master m");
masterList = query.getResultList();
} finally {
em.close();
em = null;
}

System.out.println("masterList.size(): " + masterList.size());

Master modified = masterList.get(0);
modified.setDescription("master updated");

em = getEntityManagerFactory().createEntityManager();
try {
EntityTransaction tx = em.getTransaction();
try {
tx.begin();
Master merged = em.merge(modified);
tx.commit();
} finally {
if (tx.isActive()) {
tx.rollback();
}
}
} finally {
em.close();
em = null;
}

The stack trace is:
-------
Exception in thread "main" <openjpa-1.1.0-r422266:657916 nonfatal
general error> org.apache.openjpa.persistence.PersistenceException:
The result set is closed
at
org.apache.openjpa.jdbc.sql.SQLExceptions.narrow(SQLExceptions.java:146)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4150)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:526)
at
org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:116)
at
org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:78)
at
org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:2911)
at
org.apache.openjpa.kernel.StateManagerImpl.loadField(StateManagerImpl.java:2989)
at
org.apache.openjpa.kernel.StateManagerImpl.fetchObjectField(StateManagerImpl.java:2238)
at
org.apache.openjpa.kernel.AttachStrategy.attachField(AttachStrategy.java:212)
at
org.apache.openjpa.kernel.VersionAttachStrategy.attach(VersionAttachStrategy.java:161)
at
org.apache.openjpa.kernel.AttachManager.attach(AttachManager.java:241)
at
org.apache.openjpa.kernel.AttachManager.attach(AttachManager.java:101)
at
org.apache.openjpa.kernel.BrokerImpl.attach(BrokerImpl.java:3206)
at
org.apache.openjpa.kernel.DelegatingBroker.attach(DelegatingBroker.java:1158)
at
org.apache.openjpa.persistence.EntityManagerImpl.merge(EntityManagerImpl.java:769)
at Main.testMasterUpdate(Main.java:109)
at Main.main(Main.java:167)
Caused by: 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
Java Result: 1


-------

My environment: Swing app, openJPA 1.1.0, jdk1.6.0_06, Firebird 2.1.1,
Windows 2000.

<persistence-unit name="TestPU" transaction-type="RESOURCE_LOCAL">

<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<class>entity.Detail</class>
<class>entity.Master</class>
<properties>
<property name="openjpa.ConnectionUserName" value="sysdba"/>
<property name="openjpa.ConnectionPassword" value="xxx"/>
<property name="openjpa.ConnectionURL"
value="jdbc:firebirdsql://localhost/d:/test.fdb"/>
<property name="openjpa.ConnectionDriverName"
value="org.firebirdsql.jdbc.FBDriver"/>
</properties>
</persistence-unit>


With OpenJPA version 1.0.2 and TopLink works fine.

Any idea ?

Thanks.