openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Hongell (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-209) Query returning 2 entities w/unidir 1-1 relationship gets openjpa.persistence.ArgumentException: Address with the same id already exists in the L1 cache.
Date Fri, 06 Apr 2007 22:54:32 GMT
Query returning 2 entities w/unidir 1-1 relationship gets openjpa.persistence.ArgumentException:
Address with the same id already exists in the L1 cache.
---------------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: OPENJPA-209
                 URL: https://issues.apache.org/jira/browse/OPENJPA-209
             Project: OpenJPA
          Issue Type: Bug
    Affects Versions: 0.9.7
         Environment: 0.9.7-incubating-SNAPSHOT,  windows, db2
            Reporter: George Hongell


Query returning 2 entities w/unidir 1-1 relationship gets openjpa.persistence.ArgumentException:
Address with the same id already exists in the L1 cache.

ok if 1-1 relationship is bi-directional.

found with test_1_1relationshipQuery_Winery_Address()
same behavior with test_1_1relationshipQuery_EmpBean_AddressBean()

Starting getEntityManager()
60  bugsmall  INFO   [main] openjpa.Runtime - Starting OpenJPA 0.9.7-incubating-SNAPSHOT
220  bugsmall  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.DB2Dictionary".
2423  bugsmall  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 1207977984> executing
prepstmnt 223874392 SELECT SEQSCHEMA AS SEQUENCE_SCHEMA, SEQNAME AS SEQUENCE_NAME FROM SYSCAT.SEQUENCES
2433  bugsmall  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 1207977984> [10
ms] spent
0  bugsmall  INFO   [main] openjpa.Runtime - Starting OpenJPA 0.9.7-incubating-SNAPSHOT
10  bugsmall  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.DB2Dictionary".
Starting getEntityManager()
741  bugsmall  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 698362272> executing
prepstmnt 223087948 SELECT SEQSCHEMA AS SEQUENCE_SCHEMA, SEQNAME AS SEQUENCE_NAME FROM SYSCAT.SEQUENCES
741  bugsmall  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 698362272> [0 ms]
spent
982  bugsmall  TRACE  [main] openjpa.Query - Executing query: [SELECT r.address,r FROM Winery
r WHERE r.wineryid = ?1] with parameters: {1=1}
1082  bugsmall  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 698362272> executing
prepstmnt 1433294190 SELECT t1.phone, t1.city, t1.state, t1.street, t1.zip, t0.wineryid FROM
bugsmallWinery t0 LEFT OUTER JOIN bugsmallAddress t1 ON t0.address_phone = t1.phone WHERE
(t0.wineryid = ?) [params=(int) 1]

====================================
Starting test_1_1relationshipQuery_Winery_Address()
====================================
Shows a winery and its address
String sql = "SELECT r.address,r FROM Winery r WHERE r.wineryid = :wineryid "
Caution: requires _em.find(Winery.class,parm1) to avoid cache exception
-----------------------------------------------------------------------------
1092  bugsmall  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 698362272> [0 ms]
spent
<4|false|0.9.7-incubating-SNAPSHOT> org.apache.openjpa.persistence.ArgumentException:
Cannot load object with id "1".  Instance "com.ibm.websphere.ejb3sample.winetour.bugsmall.Address-1"
with the same id already exists in the L1 cache.  This can occur when you assign an existing
id to a new instance, and before flushing attempt to load the existing instance for that id.
FailedObject: com.ibm.websphere.ejb3sample.winetour.bugsmall.Address-1
	at org.apache.openjpa.kernel.BrokerImpl$ManagedCache.add(BrokerImpl.java:4418)
	at org.apache.openjpa.kernel.BrokerImpl.setStateManager(BrokerImpl.java:3773)
	at org.apache.openjpa.kernel.StateManagerImpl.initialize(StateManagerImpl.java:297)
	at org.apache.openjpa.kernel.StateManagerImpl.initialize(StateManagerImpl.java:258)
	at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:327)
	at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:252)
	at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:108)
	at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:54)
	at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:873)
	at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:831)
	at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:753)
	at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:773)
	at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:254)
	at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2115)
	at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:684)
	at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:672)
	at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObject(ProjectionResultObjectProvider.java:73)
	at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:33)
	at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1214)
	at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:981)
	at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:791)
	at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:761)
	at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:528)
	at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:222)
	at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:264)
	at com.ibm.websphere.ejb3sample.winetour.bugsmall.BugSmallWineryTest.test_1_1relationshipQuery_Winery_Address(BugSmallWineryTest.java:344)
	at com.ibm.websphere.ejb3sample.winetour.bugsmall.BugSmallWineryTest.main(BugSmallWineryTest.java:91)


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


Mime
View raw message