Return-Path: 
 <dev-return-16024-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-dev-archive@www.apache.org
Received: (qmail 89056 invoked from network); 5 Apr 2010 19:56:52 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 5 Apr 2010 19:56:52 -0000
Received: (qmail 58409 invoked by uid 500); 5 Apr 2010 19:56:52 -0000
Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org
Received: (qmail 58377 invoked by uid 500); 5 Apr 2010 19:56:52 -0000
Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@openjpa.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@openjpa.apache.org>
List-Post: <mailto:dev@openjpa.apache.org>
List-Id: <dev.openjpa.apache.org>
Reply-To: dev@openjpa.apache.org
Delivered-To: mailing list dev@openjpa.apache.org
Received: (qmail 58369 invoked by uid 99); 5 Apr 2010 19:56:52 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Apr 2010 19:56:52 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Apr 2010 19:56:48 +0000
Received: from brutus.apache.org (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 4D67E234C4AC
	for <dev@openjpa.apache.org>; Mon,  5 Apr 2010 19:56:27 +0000 (UTC)
Message-ID: <1978192226.695821270497387316.JavaMail.jira@brutus.apache.org>
Date: Mon, 5 Apr 2010 19:56:27 +0000 (UTC)
From: "Donald Woods (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Updated: (OPENJPA-1012) Test failures in
 TestManagedInterface with @ManagedInterface annotation when using JDK6
In-Reply-To: <1954732828.1238517290437.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


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