You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Fay Wang (JIRA)" <ji...@apache.org> on 2009/11/25 23:57:39 UTC
[jira] Created: (OPENJPA-1401) Inheritance using Join Strategy may
fail in cross join JPQL
Inheritance using Join Strategy may fail in cross join JPQL
-----------------------------------------------------------
Key: OPENJPA-1401
URL: https://issues.apache.org/jira/browse/OPENJPA-1401
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Affects Versions: 2.0.0
Reporter: Fay Wang
Cross joining two entities with join table inheritance strategy may fail in the following test case: Contractor extends from Employee with Join table strategy. A JPQL "SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'Accounting' will fail with the exception below:
3922 inheritance2 TRACE [main] openjpa.Query - Executing query: SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'IT'
3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> executing prepstmnt 24489446 SELECT t1.OID FROM Department t0 JOIN Contractor t1 ON (1 = 1) WHERE (t0.OID = t1.Dept_No AND t0.description = ?) [params=(String) IT]
3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> [0 ms] spent
3984 inheritance2 TRACE [main] openjpa.jdbc.JDBC - <t 8970973, conn 0> [0 ms] close
Exception in thread "main" <openjpa-0.0.0-rnull nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Employee: e ({e|Contractor=1, Department=0})
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4677)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4630)
at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:539)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:138)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2068)
at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:150)
at org.apache.openjpa.lib.rop.AbstractNonSequentialResultList$Itr.hasNext(AbstractNonSequentialResultList.java:171)
at org.apache.openjpa.lib.rop.ResultListIterator.hasNext(ResultListIterator.java:53)
at org.apache.openjpa.kernel.DelegatingResultList$DelegatingListIterator.hasNext(DelegatingResultList.java:391)
at inheritance2.TestInheritance2.main(TestInheritance2.java:71)
Caused by: java.sql.SQLException: Employee: e ({e|Contractor=1, Department=0})
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.findObject(SelectImpl.java:2402)
at org.apache.openjpa.jdbc.sql.ResultSetResult.translate(ResultSetResult.java:497)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:362)
at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
at org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:300)
at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:187)
at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:146)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:941)
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:280)
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2328)
at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:890)
at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:873)
at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObject(ProjectionResultObjectProvider.java:79)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2032)
at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:131)
... 4 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OPENJPA-1401) Inheritance using Join Strategy may
fail in cross join JPQL
Posted by "Catalina Wei (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Catalina Wei resolved OPENJPA-1401.
-----------------------------------
Resolution: Fixed
Fix Version/s: 2.0.0
1.3.0
Assignee: Catalina Wei
> Inheritance using Join Strategy may fail in cross join JPQL
> -----------------------------------------------------------
>
> Key: OPENJPA-1401
> URL: https://issues.apache.org/jira/browse/OPENJPA-1401
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0
> Reporter: Fay Wang
> Assignee: Catalina Wei
> Fix For: 1.3.0, 2.0.0
>
> Attachments: OPENJPA-1401-testcase.jar, OPENJPA-1401.patch
>
>
> Cross joining two entities with join table inheritance strategy may fail in the following test case: Contractor extends from Employee with Join table strategy. A JPQL "SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'Accounting' will fail with the exception below:
> 3922 inheritance2 TRACE [main] openjpa.Query - Executing query: SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'IT'
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> executing prepstmnt 24489446 SELECT t1.OID FROM Department t0 JOIN Contractor t1 ON (1 = 1) WHERE (t0.OID = t1.Dept_No AND t0.description = ?) [params=(String) IT]
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> [0 ms] spent
> 3984 inheritance2 TRACE [main] openjpa.jdbc.JDBC - <t 8970973, conn 0> [0 ms] close
> Exception in thread "main" <openjpa-0.0.0-rnull nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4677)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4630)
> at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:539)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:138)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
> at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2068)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:150)
> at org.apache.openjpa.lib.rop.AbstractNonSequentialResultList$Itr.hasNext(AbstractNonSequentialResultList.java:171)
> at org.apache.openjpa.lib.rop.ResultListIterator.hasNext(ResultListIterator.java:53)
> at org.apache.openjpa.kernel.DelegatingResultList$DelegatingListIterator.hasNext(DelegatingResultList.java:391)
> at inheritance2.TestInheritance2.main(TestInheritance2.java:71)
> Caused by: java.sql.SQLException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.findObject(SelectImpl.java:2402)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.translate(ResultSetResult.java:497)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:362)
> at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
> at org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:300)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:187)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:146)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:941)
> at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:280)
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2328)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:890)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:873)
> at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObject(ProjectionResultObjectProvider.java:79)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2032)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:131)
> ... 4 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1401) Inheritance using Join Strategy may
fail in cross join JPQL
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1401:
----------------------------------
Affects Version/s: (was: 2.0.0)
2.0.0-M3
2.0.0-beta
Fix Version/s: (was: 2.0.0)
2.0.0-beta2
> Inheritance using Join Strategy may fail in cross join JPQL
> -----------------------------------------------------------
>
> Key: OPENJPA-1401
> URL: https://issues.apache.org/jira/browse/OPENJPA-1401
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-M3, 2.0.0-beta
> Reporter: Fay Wang
> Assignee: Catalina Wei
> Fix For: 1.3.0, 2.0.0-beta2
>
> Attachments: OPENJPA-1401-testcase.jar, OPENJPA-1401.patch
>
>
> Cross joining two entities with join table inheritance strategy may fail in the following test case: Contractor extends from Employee with Join table strategy. A JPQL "SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'Accounting' will fail with the exception below:
> 3922 inheritance2 TRACE [main] openjpa.Query - Executing query: SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'IT'
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> executing prepstmnt 24489446 SELECT t1.OID FROM Department t0 JOIN Contractor t1 ON (1 = 1) WHERE (t0.OID = t1.Dept_No AND t0.description = ?) [params=(String) IT]
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> [0 ms] spent
> 3984 inheritance2 TRACE [main] openjpa.jdbc.JDBC - <t 8970973, conn 0> [0 ms] close
> Exception in thread "main" <openjpa-0.0.0-rnull nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4677)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4630)
> at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:539)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:138)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
> at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2068)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:150)
> at org.apache.openjpa.lib.rop.AbstractNonSequentialResultList$Itr.hasNext(AbstractNonSequentialResultList.java:171)
> at org.apache.openjpa.lib.rop.ResultListIterator.hasNext(ResultListIterator.java:53)
> at org.apache.openjpa.kernel.DelegatingResultList$DelegatingListIterator.hasNext(DelegatingResultList.java:391)
> at inheritance2.TestInheritance2.main(TestInheritance2.java:71)
> Caused by: java.sql.SQLException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.findObject(SelectImpl.java:2402)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.translate(ResultSetResult.java:497)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:362)
> at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
> at org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:300)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:187)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:146)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:941)
> at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:280)
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2328)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:890)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:873)
> at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObject(ProjectionResultObjectProvider.java:79)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2032)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:131)
> ... 4 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OPENJPA-1401) Inheritance using Join Strategy
may fail in cross join JPQL
Posted by "Xiaoqin Feng (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12792659#action_12792659 ]
Xiaoqin Feng commented on OPENJPA-1401:
---------------------------------------
I am on vacation from 12/20/2009 Â to 12/26/2009.
If you have any question on deployment and JEE bugs, please contact Saurabh Arora or my manager Maruthi Nuthikattu.
For emergency, contact me at 925-209-5517.
> Inheritance using Join Strategy may fail in cross join JPQL
> -----------------------------------------------------------
>
> Key: OPENJPA-1401
> URL: https://issues.apache.org/jira/browse/OPENJPA-1401
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0
> Reporter: Fay Wang
> Assignee: Catalina Wei
> Fix For: 1.3.0, 2.0.0
>
> Attachments: OPENJPA-1401-testcase.jar, OPENJPA-1401.patch
>
>
> Cross joining two entities with join table inheritance strategy may fail in the following test case: Contractor extends from Employee with Join table strategy. A JPQL "SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'Accounting' will fail with the exception below:
> 3922 inheritance2 TRACE [main] openjpa.Query - Executing query: SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'IT'
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> executing prepstmnt 24489446 SELECT t1.OID FROM Department t0 JOIN Contractor t1 ON (1 = 1) WHERE (t0.OID = t1.Dept_No AND t0.description = ?) [params=(String) IT]
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> [0 ms] spent
> 3984 inheritance2 TRACE [main] openjpa.jdbc.JDBC - <t 8970973, conn 0> [0 ms] close
> Exception in thread "main" <openjpa-0.0.0-rnull nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4677)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4630)
> at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:539)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:138)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
> at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2068)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:150)
> at org.apache.openjpa.lib.rop.AbstractNonSequentialResultList$Itr.hasNext(AbstractNonSequentialResultList.java:171)
> at org.apache.openjpa.lib.rop.ResultListIterator.hasNext(ResultListIterator.java:53)
> at org.apache.openjpa.kernel.DelegatingResultList$DelegatingListIterator.hasNext(DelegatingResultList.java:391)
> at inheritance2.TestInheritance2.main(TestInheritance2.java:71)
> Caused by: java.sql.SQLException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.findObject(SelectImpl.java:2402)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.translate(ResultSetResult.java:497)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:362)
> at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
> at org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:300)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:187)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:146)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:941)
> at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:280)
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2328)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:890)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:873)
> at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObject(ProjectionResultObjectProvider.java:79)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2032)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:131)
> ... 4 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1401) Inheritance using Join Strategy may
fail in cross join JPQL
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang updated OPENJPA-1401:
------------------------------
Attachment: OPENJPA-1401-testcase.jar
Attach test case.
> Inheritance using Join Strategy may fail in cross join JPQL
> -----------------------------------------------------------
>
> Key: OPENJPA-1401
> URL: https://issues.apache.org/jira/browse/OPENJPA-1401
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0
> Reporter: Fay Wang
> Attachments: OPENJPA-1401-testcase.jar
>
>
> Cross joining two entities with join table inheritance strategy may fail in the following test case: Contractor extends from Employee with Join table strategy. A JPQL "SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'Accounting' will fail with the exception below:
> 3922 inheritance2 TRACE [main] openjpa.Query - Executing query: SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'IT'
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> executing prepstmnt 24489446 SELECT t1.OID FROM Department t0 JOIN Contractor t1 ON (1 = 1) WHERE (t0.OID = t1.Dept_No AND t0.description = ?) [params=(String) IT]
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> [0 ms] spent
> 3984 inheritance2 TRACE [main] openjpa.jdbc.JDBC - <t 8970973, conn 0> [0 ms] close
> Exception in thread "main" <openjpa-0.0.0-rnull nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4677)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4630)
> at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:539)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:138)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
> at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2068)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:150)
> at org.apache.openjpa.lib.rop.AbstractNonSequentialResultList$Itr.hasNext(AbstractNonSequentialResultList.java:171)
> at org.apache.openjpa.lib.rop.ResultListIterator.hasNext(ResultListIterator.java:53)
> at org.apache.openjpa.kernel.DelegatingResultList$DelegatingListIterator.hasNext(DelegatingResultList.java:391)
> at inheritance2.TestInheritance2.main(TestInheritance2.java:71)
> Caused by: java.sql.SQLException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.findObject(SelectImpl.java:2402)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.translate(ResultSetResult.java:497)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:362)
> at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
> at org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:300)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:187)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:146)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:941)
> at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:280)
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2328)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:890)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:873)
> at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObject(ProjectionResultObjectProvider.java:79)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2032)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:131)
> ... 4 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1401) Inheritance using Join Strategy may
fail in cross join JPQL
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang updated OPENJPA-1401:
------------------------------
Attachment: OPENJPA-1401.patch
> Inheritance using Join Strategy may fail in cross join JPQL
> -----------------------------------------------------------
>
> Key: OPENJPA-1401
> URL: https://issues.apache.org/jira/browse/OPENJPA-1401
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0
> Reporter: Fay Wang
> Attachments: OPENJPA-1401-testcase.jar, OPENJPA-1401.patch
>
>
> Cross joining two entities with join table inheritance strategy may fail in the following test case: Contractor extends from Employee with Join table strategy. A JPQL "SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'Accounting' will fail with the exception below:
> 3922 inheritance2 TRACE [main] openjpa.Query - Executing query: SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'IT'
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> executing prepstmnt 24489446 SELECT t1.OID FROM Department t0 JOIN Contractor t1 ON (1 = 1) WHERE (t0.OID = t1.Dept_No AND t0.description = ?) [params=(String) IT]
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> [0 ms] spent
> 3984 inheritance2 TRACE [main] openjpa.jdbc.JDBC - <t 8970973, conn 0> [0 ms] close
> Exception in thread "main" <openjpa-0.0.0-rnull nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4677)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4630)
> at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:539)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:138)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
> at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2068)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:150)
> at org.apache.openjpa.lib.rop.AbstractNonSequentialResultList$Itr.hasNext(AbstractNonSequentialResultList.java:171)
> at org.apache.openjpa.lib.rop.ResultListIterator.hasNext(ResultListIterator.java:53)
> at org.apache.openjpa.kernel.DelegatingResultList$DelegatingListIterator.hasNext(DelegatingResultList.java:391)
> at inheritance2.TestInheritance2.main(TestInheritance2.java:71)
> Caused by: java.sql.SQLException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.findObject(SelectImpl.java:2402)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.translate(ResultSetResult.java:497)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:362)
> at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
> at org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:300)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:187)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:146)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:941)
> at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:280)
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2328)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:890)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:873)
> at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObject(ProjectionResultObjectProvider.java:79)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2032)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:131)
> ... 4 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1401) Inheritance using Join Strategy may
fail in cross join JPQL
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1401:
----------------------------------
Affects Version/s: (was: 2.0.0-beta)
Fix Version/s: (was: 2.0.0-beta2)
2.0.0-beta
> Inheritance using Join Strategy may fail in cross join JPQL
> -----------------------------------------------------------
>
> Key: OPENJPA-1401
> URL: https://issues.apache.org/jira/browse/OPENJPA-1401
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-M3
> Reporter: Fay Wang
> Assignee: Catalina Wei
> Fix For: 1.3.0, 2.0.0-beta
>
> Attachments: OPENJPA-1401-testcase.jar, OPENJPA-1401.patch
>
>
> Cross joining two entities with join table inheritance strategy may fail in the following test case: Contractor extends from Employee with Join table strategy. A JPQL "SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'Accounting' will fail with the exception below:
> 3922 inheritance2 TRACE [main] openjpa.Query - Executing query: SELECT e FROM Department d, Contractor e where d.OID = e.dept.OID and d.description = 'IT'
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> executing prepstmnt 24489446 SELECT t1.OID FROM Department t0 JOIN Contractor t1 ON (1 = 1) WHERE (t0.OID = t1.Dept_No AND t0.description = ?) [params=(String) IT]
> 3969 inheritance2 TRACE [main] openjpa.jdbc.SQL - <t 8970973, conn 12468716> [0 ms] spent
> 3984 inheritance2 TRACE [main] openjpa.jdbc.JDBC - <t 8970973, conn 0> [0 ms] close
> Exception in thread "main" <openjpa-0.0.0-rnull nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4677)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4630)
> at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:539)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:138)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
> at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2068)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:150)
> at org.apache.openjpa.lib.rop.AbstractNonSequentialResultList$Itr.hasNext(AbstractNonSequentialResultList.java:171)
> at org.apache.openjpa.lib.rop.ResultListIterator.hasNext(ResultListIterator.java:53)
> at org.apache.openjpa.kernel.DelegatingResultList$DelegatingListIterator.hasNext(DelegatingResultList.java:391)
> at inheritance2.TestInheritance2.main(TestInheritance2.java:71)
> Caused by: java.sql.SQLException: Employee: e ({e|Contractor=1, Department=0})
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.findObject(SelectImpl.java:2402)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.translate(ResultSetResult.java:497)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:362)
> at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
> at org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:300)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:187)
> at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:146)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:941)
> at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:280)
> at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2328)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:890)
> at org.apache.openjpa.jdbc.kernel.exps.PCPath.load(PCPath.java:873)
> at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObject(ProjectionResultObjectProvider.java:79)
> at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2032)
> at org.apache.openjpa.lib.rop.WindowResultList.getInternal(WindowResultList.java:131)
> ... 4 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.