You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "George Hongell (JIRA)" <ji...@apache.org> on 2007/04/07 00:54:32 UTC
[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.
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.
[jira] Updated: (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.
Posted by "George Hongell (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
George Hongell updated OPENJPA-209:
-----------------------------------
Attachment: 1_1CacheBugWineryTest.zip
run main method of BugSmallWineryTest in attached application to reproduce error
> 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
> Attachments: 1_1CacheBugWineryTest.zip
>
>
> 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.