openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey (JIRA)" <j...@apache.org>
Subject [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.
Date Mon, 12 May 2008 23:02:55 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Patrick Linskey updated OPENJPA-209:
------------------------------------

    Fix Version/s:     (was: 1.1.0)
                   1.2.0

> 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
>             Fix For: 1.0.3, 1.2.0
>
>         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.


Mime
View raw message