You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Donald Woods (JIRA)" <ji...@apache.org> on 2010/04/05 21:56:27 UTC
[jira] Updated: (OPENJPA-1012) Test failures in
TestManagedInterface with @ManagedInterface annotation when using JDK6
[ 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.