Return-Path: 
 <dev-return-5345-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-dev-archive@www.apache.org
Received: (qmail 82733 invoked from network); 7 Aug 2007 18:42:42 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 7 Aug 2007 18:42:42 -0000
Received: (qmail 12179 invoked by uid 500); 7 Aug 2007 18:42:40 -0000
Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org
Received: (qmail 12008 invoked by uid 500); 7 Aug 2007 18:42:40 -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 11990 invoked by uid 99); 7 Aug 2007 18:42:40 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Aug 2007 11:42:39 -0700
X-ASF-Spam-Status: No, hits=-100.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Aug 2007 18:42:40 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id EB846714208
	for <dev@openjpa.apache.org>; Tue,  7 Aug 2007 11:41:59 -0700 (PDT)
Message-ID: <7002302.1186512119962.JavaMail.jira@brutus>
Date: Tue, 7 Aug 2007 11:41:59 -0700 (PDT)
From: "Patrick Linskey (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Updated: (OPENJPA-113) when you specify columm
 table="empbean"  in the xml file entity id or basic type when empbean is
 the default table name, the mapping tool generates extra foreign key field
 (eg.EmpBean_empid) in the table produced.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/OPENJPA-113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Patrick Linskey updated OPENJPA-113:
------------------------------------

    Fix Version/s:     (was: 0.9.8)

> when you specify columm table="empbean"  in the xml file entity id or basic type when empbean is the default table name, the mapping tool generates extra foreign key field (eg.EmpBean_empid) in the table produced.
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-113
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-113
>             Project: OpenJPA
>          Issue Type: Bug
>         Environment: windows xp, openjpa_097_incubating
>            Reporter: George Hongell
>            Assignee: Michael Dick
>            Priority: Minor
>
> when you specify columm table="empbean"  in the xml file entity id or basic type when empbean is the default table name, the mapping tool generates extra foreign key field (eg.EmpBean_empid) in the table produced. This causes a SQL0203 (A reference to column name is ambiguous) on empid when you try to persist this entity.
>     <entity name="EmpBean" class="EmpBean" access="FIELD">
>         <attributes>
>             <id name="empid">
>                <column name="empid" nullable="false" column-definition="integer" />
>             </id>
>             <basic name="name" fetch="EAGER">
>                 <column length="40"/>
>             </basic>
>             <basic name="salary" fetch="EAGER" >
>                 <column name="salary" table="empbean"/>
>             </basic>
>             <basic name="bonus" fetch="EAGER">
>             </basic>
>              <basic name="isManager" fetch="EAGER">
>              </basic>
>              <basic name="execLevel" fetch="EAGER">
>              </basic>
>             <basic name="hireDate" fetch="EAGER">
>              </basic>
>             <basic name="hireTime" fetch="EAGER">
>              </basic>
>             <basic name="hireTimestamp" fetch="EAGER">
>              </basic>
>            <many-to-one name="dept" target-entity="com.ibm.ws.query.entities.xml.DeptBean" fetch="EAGER">
>            </many-to-one>
>            <one-to-many name="manages" target-entity="DeptBean" fetch="LAZY" mapped-by="mgr">
>                 <cascade><cascade-remove/></cascade>
>             </one-to-many>
>  
>            <one-to-one name="home" target-entity="AddressBean" fetch="EAGER">
>            </one-to-one>
>  
>             <one-to-one name="work" target-entity="AddressBean" fetch="EAGER">
>            </one-to-one>
>             
>             <many-to-many name="tasks" target-entity="TaskBean" fetch="LAZY" mapped-by="emps">
>             </many-to-many>
>         </attributes>        
>     </entity>
> 4787  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 1274432502> executing stmnt 1129857880 CREATE TABLE EmpBean (empid INTEGER NOT NULL, bonus DOUBLE, execLevel INTEGER, hireDate DATE, hireTime TIME, hireTimestamp TIMESTAMP, isManager SMALLINT, name VARCHAR(40), EmpBean_empid INTEGER, salary DOUBLE, dept_deptno INTEGER, home_street VARCHAR(40), work_street VARCHAR(40), PRIMARY KEY (empid))

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.