[
https://issues.apache.org/jira/browse/OPENJPA-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Donald Woods updated OPENJPA-1012:
----------------------------------
Assignee: (was: Donald Woods)
Still fails with latest code, with OpenJPA complied with Java 6 but tests run
with Java 5 (-Ptest-java5,test-derbymem).
Java 5 does -
CREATE TABLE ManagedInterfaceSup_SIMPLE_ENTITY
while Java 6 does -
CREATE TABLE ManagedInterfaceSup_setPC
which then causes other differences to follow. and eventually test failures
with -
Caused by: <openjpa-2.1.0-SNAPSHOT-r422266:930888M fatal general error>
org.apache.openjpa.persistence.PersistenceException: 'PC_ID' is not a column in
table or VTI 'APP.MANAGEDINTERFACESUP'. {INSERT INTO ManagedInterfaceSup (id,
intFieldSup, intField, embedIntField, PC_ID, SELF_ID) VALUES (?, ?, ?, ?, ?,
?)} [code=20000, state=42X14]
Some SQL tracing with Java 5 -
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.apache.openjpa.persistence.managedinterface.TestManagedInterfaces
2252 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 15938779 CREATE TABLE ManagedInterfaceOwner (id INTEGER NOT
NULL, intField INTEGER, embedIntField INTEGER, IFACE_ID INTEGER, PRIMARY KEY
(id))
2281 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [29 ms]
spent
2282 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 10260243 CREATE TABLE ManagedInterfaceSup (id INTEGER NOT NULL,
intFieldSup INTEGER, intField INTEGER, embedIntField INTEGER, PC_ID BIGINT,
SELF_ID INTEGER, PRIMARY KEY (id))
2288 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [6 ms]
spent
2289 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 7660121 CREATE TABLE ManagedInterfaceSup_ManagedInterfaceSup
(MANAGEDIFACE_ID INTEGER, SETI_ID INTEGER)
2291 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [2 ms]
spent
2293 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 5914691 CREATE TABLE ManagedInterfaceSup_setInteger
(MANAGEDIFACE_ID INTEGER, element INTEGER)
2302 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [5 ms]
spent
2303 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 2889349 CREATE TABLE ManagedInterfaceSup_SIMPLE_ENTITY
(MANAGEDIFACE_ID INTEGER, SETPC_ID BIGINT)
2306 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [3 ms]
spent
2306 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 12176281 CREATE TABLE MixedInterface (id INTEGER NOT NULL,
intField INTEGER, PRIMARY KEY (id))
2311 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [5 ms]
spent
2311 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 14307195 CREATE TABLE MixedInterfaceImpl (id INTEGER NOT NULL,
intField INTEGER, PRIMARY KEY (id))
2322 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [11 ms]
spent
2323 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 12280460 CREATE TABLE NonMappedInterfaceImpl (id BIGINT NOT
NULL, -- datastore id
mismatch INTEGER, PRIMARY KEY (id))
2328 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [5 ms]
spent
2329 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 6342568 CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID SMALLINT NOT
NULL, SEQUENCE_VALUE BIGINT, PRIMARY KEY (ID))
2341 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [7 ms]
spent
2341 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 2356421 CREATE TABLE SIMPLE_ENTITY -- simple
(ID BIGINT NOT NULL, NAME VARCHAR(255), VALUE VARCHAR(255), PRIMARY KEY
(ID))
2347 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [6 ms]
spent
2348 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 5094191 CREATE INDEX I_MNGDWNR_IFACE ON ManagedInterfaceOwner
(IFACE_ID)
2353 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [5 ms]
spent
2354 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 5182037 CREATE INDEX I_MNGDCSP_PC ON ManagedInterfaceSup (PC_ID)
2362 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [7 ms]
spent
2362 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 919075 CREATE INDEX I_MNGDCSP_SELF ON ManagedInterfaceSup
(SELF_ID)
2365 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [3 ms]
spent
2365 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 13263705 CREATE INDEX I_MNGDCSP_ELEMENT ON
ManagedInterfaceSup_ManagedInterfaceSup (SETI_ID)
2371 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [6 ms]
spent
2371 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 10522027 CREATE INDEX I_MNGDCSP_MANAGEDIFACE_ID ON
ManagedInterfaceSup_ManagedInterfaceSup (MANAGEDIFACE_ID)
2376 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [3 ms]
spent
2377 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 1219197 CREATE INDEX I_MNGDTGR_MANAGEDIFACE_ID ON
ManagedInterfaceSup_setInteger (MANAGEDIFACE_ID)
2382 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [5 ms]
spent
2382 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 13136901 CREATE INDEX I_MNGDTTY_ELEMENT ON
ManagedInterfaceSup_SIMPLE_ENTITY (SETPC_ID)
2386 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [4 ms]
spent
2386 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476>
executing stmnt 2861568 CREATE INDEX I_MNGDTTY_MANAGEDIFACE_ID ON
ManagedInterfaceSup_SIMPLE_ENTITY (MANAGEDIFACE_ID)
2391 test TRACE [main] openjpa.jdbc.SQL - <t 1266662, conn 15283476> [5 ms]
spent
Versus the same with Java 6 -
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.apache.openjpa.persistence.managedinterface.TestManagedInterfaces
3365 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 1288809736 CREATE TABLE ManagedInterfaceOwner (id INTEGER NOT
NULL, intField INTEGER, embedIntField INTEGER, IFACE_ID INTEGER, PRIMARY KEY
(id))
3426 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [61
ms] spent
3427 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 1717313198 CREATE TABLE ManagedInterfaceSup (id INTEGER NOT
NULL, intFieldSup INTEGER, intField INTEGER, embedIntField INTEGER, SELF_ID
INTEGER, PRIMARY KEY (id))
3437 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [10
ms] spent
3438 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 208688853 CREATE TABLE ManagedInterfaceSup_ManagedInterfaceSup
(MANAGEDIFACE_ID INTEGER, SETI_ID INTEGER)
3442 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [4
ms] spent
3443 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 963409389 CREATE TABLE ManagedInterfaceSup_setInteger
(MANAGEDIFACE_ID INTEGER, element INTEGER)
3451 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [8
ms] spent
3452 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 1397120162 CREATE TABLE ManagedInterfaceSup_setPC
(MANAGEDIFACE_ID INTEGER)
3457 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [5
ms] spent
3457 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 444851035 CREATE TABLE MixedInterface (id INTEGER NOT NULL,
intField INTEGER, PRIMARY KEY (id))
3473 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [16
ms] spent
3474 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 206188888 CREATE TABLE MixedInterfaceImpl (id INTEGER NOT NULL,
intField INTEGER, PRIMARY KEY (id))
3490 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [16
ms] spent
3491 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 1713303340 CREATE TABLE NonMappedInterfaceImpl (id BIGINT NOT
NULL, -- datastore id
mismatch INTEGER, PRIMARY KEY (id))
3515 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [23
ms] spent
3515 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 2082765220 CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID SMALLINT NOT
NULL, SEQUENCE_VALUE BIGINT, PRIMARY KEY (ID))
3531 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [16
ms] spent
3532 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 948576262 CREATE TABLE SIMPLE_ENTITY -- simple
(ID BIGINT NOT NULL, NAME VARCHAR(255), VALUE VARCHAR(255), PRIMARY KEY
(ID))
3547 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [15
ms] spent
3548 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 288976631 CREATE INDEX I_MNGDWNR_IFACE ON ManagedInterfaceOwner
(IFACE_ID)
3576 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [19
ms] spent
3577 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 1686581432 CREATE INDEX I_MNGDCSP_SELF ON ManagedInterfaceSup
(SELF_ID)
3585 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [8
ms] spent
3586 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 392814336 CREATE INDEX I_MNGDCSP_ELEMENT ON
ManagedInterfaceSup_ManagedInterfaceSup (SETI_ID)
3626 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [40
ms] spent
3629 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 1301150326 CREATE INDEX I_MNGDCSP_MANAGEDIFACE_ID ON
ManagedInterfaceSup_ManagedInterfaceSup (MANAGEDIFACE_ID)
3639 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [10
ms] spent
3639 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 1943335765 CREATE INDEX I_MNGDTGR_MANAGEDIFACE_ID ON
ManagedInterfaceSup_setInteger (MANAGEDIFACE_ID)
3647 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [8
ms] spent
3648 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510>
executing stmnt 1645408661 CREATE INDEX I_MNGDTPC_MANAGEDIFACE_ID ON
ManagedInterfaceSup_setPC (MANAGEDIFACE_ID)
3674 test TRACE [main] openjpa.jdbc.SQL - <t 1505169310, conn 23231510> [26
ms] spent
> Test failures in TestManagedInterface with @ManagedInterface annotation when
> using JDK6
> ---------------------------------------------------------------------------------------
>
> Key: OPENJPA-1012
> URL: https://issues.apache.org/jira/browse/OPENJPA-1012
> Project: OpenJPA
> Issue Type: Bug
> Components: query
> Affects Versions: 2.0.0-M2
> Reporter: Donald Woods
> Priority: Critical
> Fix For: 2.0.0
>
>
> We have a problem with the OpenJPA @ManagedInterface annotation due to the
> OPENJPA-5 update for JDK 6.
> Currently, the junit class in
> openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/managedinterface/TestManagedInterfaces.java
> failures on JDK6 are ignored because -
> @AllowFailure(message="On JDK6 Upgrade these tests are failing with wrong
> mapping. " +
> "Column PC_ID in ManagedInterfaceSup Table is not created. getPC() is " +
> "defined as property in ManageIFace sub-interface")
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
