openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald Woods (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-1012) Test failures in TestManagedInterface with @ManagedInterface annotation when using JDK6
Date Mon, 05 Apr 2010 19:56:27 GMT

     [ 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.


Mime
View raw message