Return-Path: <minfrin@sharp.fm>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 15971 invoked from network); 25 Apr 2003 14:45:19 -0000
Received: from gatekeeper.fma.co.za (HELO localhost.localdomain)
 (196.22.96.162)
  by daedalus.apache.org with SMTP; 25 Apr 2003 14:45:19 -0000
Received: from sharp.fm (localhost.localdomain [127.0.0.1])
	by localhost.localdomain (8.11.6/8.11.6) with ESMTP id h3PEj8x11278
	for <torque-user@db.apache.org>; Fri, 25 Apr 2003 16:45:11 +0200
Message-ID: <3EA949F4.4070908@sharp.fm>
Date: Fri, 25 Apr 2003 16:45:08 +0200
From: Graham Leggett <minfrin@sharp.fm>
User-Agent: Mozilla/5.0 (X11; U; Linux ppc; en-US; rv:1.3) Gecko/20030318
X-Accept-Language: en-gb, en-za, en
MIME-Version: 1.0
To: Turbine Torque Users List <torque-user@db.apache.org>
Subject: OM compile failure: TABLE_NAME defined twice
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi all,

Torque generates my OM classes, but they fail to compile like so:

java:compile:
     [javac] Since fork is true, ignoring compiler setting.
     [javac] Compiling 169 source files to 
/home/sam/minfrin/src/fma/patricia-db/target/classes
     [javac] Since fork is true, ignoring compiler setting.
     [javac] 
/home/sam/minfrin/src/fma/patricia-db/src/java/za/co/fma/patricia/database/om/BaseIdTablePeer.java:64: 
TABLE_NAME is already defined in 
za.co.fma.patricia.database.om.BaseIdTablePeer
     [javac]     public static final String TABLE_NAME;
     [javac]                                ^
     [javac] 
/home/sam/minfrin/src/fma/patricia-db/src/java/za/co/fma/patricia/database/om/BaseIdTablePeer.java:73: 
cannot assign a value to final variable TABLE_NAME
     [javac]     TABLE_NAME = "ID_TABLE.TABLE_NAME";
     [javac]     ^
     [javac] 2 errors

I suspect the problem is related to the following bit of my database 
schema definition:

   <table name="ID_TABLE">
     <column name="ID_TABLE_ID" required="true" primaryKey="true" 
type="INTEGER"/>
     <column name="TABLE_NAME" required="true" size="255" type="VARCHAR"/>
     <column name="NEXT_ID" type="INTEGER"/>
     <column name="QUANTITY" type="INTEGER"/>

     <unique>
       <unique-column name="TABLE_NAME"/>
     </unique>

   </table>

The above table is defined inside my database-schema.xml file - is this 
the correct thing to do? The docs are a little vague on how the whole 
auto sequence generation works, and exactly how you set it up.

Regards,
Graham
-- 
-----------------------------------------
minfrin@sharp.fm		"There's a moon
					over Bourbon Street
						tonight..."