Return-Path: 
 <torque-user-return-3167-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 98654 invoked from network); 2 Oct 2003 07:36:55 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 2 Oct 2003 07:36:55 -0000
Received: (qmail 17104 invoked by uid 500); 2 Oct 2003 07:36:28 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 17092 invoked by uid 500); 2 Oct 2003 07:36:28 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 17079 invoked from network); 2 Oct 2003 07:36:27 -0000
Received: from unknown (HELO smtp09.wxs.nl) (195.121.6.38)
  by daedalus.apache.org with SMTP; 2 Oct 2003 07:36:27 -0000
Received: from 192.168.1.253 (ipd50aec15.speed.planet.nl [213.10.236.21])
 by smtp09.wxs.nl
 (iPlanet Messaging Server 5.2 HotFix 1.14 (built Mar 18 2003)) with ESMTP id
 <0HM400IYLD1WDZ@smtp09.wxs.nl> for torque-user@db.apache.org; Thu,
 02 Oct 2003 09:34:47 +0200 (MEST)
Date: Thu, 02 Oct 2003 09:36:36 +0200
From: Jan Krabbenbos <jan.krabbenbos@planet.nl>
Subject: OM generation problem
To: Apache Torque Users List <torque-user@db.apache.org>
Reply-to: jan.krabbenbos@planet.nl
Message-id: <200310020936.36670.jan.krabbenbos@planet.nl>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline
User-Agent: KMail/1.5
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi,

I new to torque and torque-gen, so I now am trying to find out how I can use 
and implement it (I'm using 3.1). I have an existing MySQL database, which I 
want use. With torque-gen and the jdbc action I generated the schema and the 
object model. When I now compile the generated java sources, it returns with 
the error:

club.java:41: illegal start of expression
    [javac]     private long club_id = ;

There is no value inserted between '=' and ';' so therefor it can not be 
compiled. I checked what could be the problem, and it seems to be the auto 
increment in the table for club_id. With the autoincrement it generates the 
following schema for the table 'club':

<table javaName="club" name="club">
	<column default="" javaName="club_id" name="club_id"
		primaryKey="true" required="true" type="BIGINT"/>
	<column default="" javaName="name" name="name" size="100" type="VARCHAR"/>
	<column default="" javaName="location" name="location"
		size="100" type="VARCHAR"/>
	<column default="" javaName="description" name="description"
		size="255" type="VARCHAR"/>
	<column default="" javaName="changed" name="changed" type="TIMESTAMP"/>
</table>

After changing the autoincrement in the MySQL to no for 'club_id' it generates 
the following schema and the object model generated compiles!?!

<table javaName="club" name="club">
	<column default="0" javaName="club_id" name="club_id"
		primaryKey="true" required="true" type="BIGINT"/>
	<column default="" javaName="name" name="name" size="100" type="VARCHAR"/>
	<column default="" javaName="location" name="location"
		size="100" type="VARCHAR"/>
	<column default="" javaName="description" name="description"
		size="255" type="VARCHAR"/>
	<column default="" javaName="changed" name="changed" type="TIMESTAMP"/>
</table>

The difference is in the default-tag of the column 'club_id'. With the 
autoincrement it is  empty and without the autoincrement it is 0. Can anybody 
tell me if this is a configuration problem or a bug?
-- 
Met vriendelijke groet,

Jan Krabbenbos

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org