Return-Path: <peter@courcoux.biz>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 15103 invoked from network); 17 Apr 2003 13:21:53 -0000
Received: from pjcourcouxdsl.claranet.co.uk (HELO pjc.courcoux.biz)
 (217.158.80.250)
  by daedalus.apache.org with SMTP; 17 Apr 2003 13:21:53 -0000
Received: (from peter@localhost)
	by pjc.courcoux.biz (8.11.6/linuxconf) id h3HDLrE03450
	for torque-user@db.apache.org; Thu, 17 Apr 2003 14:21:53 +0100
Subject: Re: problem with Postgresql and sequences for autoincrement
From: Peter Courcoux <peter@courcoux.biz>
To: Turbine Torque Users List <torque-user@db.apache.org>
In-Reply-To: <20030417195521.18A1.T-FUJIMOTO@beingcorp.co.jp>
References: <20030417195521.18A1.T-FUJIMOTO@beingcorp.co.jp>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Organization: 
Message-Id: <1050585713.1937.10.camel@pjc.courcoux.biz>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.1 
Date: 17 Apr 2003 14:21:53 +0100
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Try this. Note no autoincrement attribute or id-method-parameter tag. I
also use bigint columns for pk's as I believe that the sequences in pg
cope with bigints ok. 

  <table idMethod="native" name="myname">
   <column name="myid" primaryKey="true" required="true" type="BIGINT"/>
  </table>

Regards,

Peter


On Thu, 2003-04-17 at 11:55, Tak Fujimoto wrote:
> I sure did a heavy research on this subject 
> throughout turbine-torque mail archive and all
> but I still can not make it work!
> 
> I am starting to wonder if there is any bug on JDBC or Postgresql of this particular version.
> 
> Please give me any advice, suggestion on what I should do if you have time.
> 
> 
> [setup]
> jakarta-struts-1.1-b3
> jakarta-tomcat-4.0.6
> torque-3.0
> Red Hat Linux release 7.1 (Seawolf)
> apache_1.3.26
> postgresql-7.2.1
> pg73jdbc3.jar
> mod_jk-1.3-noeapi.so
> 
> [Refered URL]
> http://www.mail-archive.com/turbine-torque-user@jakarta.apache.org/msg00691.html
> http://archives.apache.org/eyebrowse/ReadMsg?listName=turbine-torque-user@jakarta.apache.org&msgNo=198
> 
> 
> 
> This is the part of project-schema.xml which describes the table I am having a trouble with.
> *****************************************************************************************
> <table name="TELSUPPORT" idMethod="native">
>   <column name="TELSUPPORT_ID"      type="INTEGER"  required="true"  autoIncrement="true"
> primaryKey="true" />
>   <column name="MEMBER_ID"      type="INTEGER"  required="true"  />
>   <column name="DATE"    type="DATE"  default="now" required="true"  />
>   <column name="TIME"    type="TIME" default="now" required="true"  />
>   <column name="CUSTOMER_NUM"      type="INTEGER"  default="0" />
>   <column name="INQUIRY_ID"      type="INTEGER"  required="true" />
>   <column name="SUPPORTRESULT_ID"     type="CHAR" size="1"  required="true" />
>   <column name="TELSUPPORT"      type="VARCHAR" size="10000" default="" />
>   <id-method-parameter value="telsupport_telsupport_id_seq"/>
>     <foreign-key foreignTable="MEMBER"><reference local="MEMBER_ID" foreign="MEMBER_ID"
> /></foreign-key>
>     <foreign-key foreignTable="INQUIRY"><reference local="INQUIRY_ID" foreign="INQUIRY_ID"
> /></foreign-key>
>     <foreign-key foreignTable="SUPPORTRESULT"><reference local="SUPPORTRESULT_ID"
> foreign="SUPPORTRESULT_ID" /></foreign-key>
>   </table>
> *****************************************************************************************
> 
> 
> 
> 
> *--------------------------------*
> Tak Fujimoto
> Being Co, Ltd.  
> [ALLESNET]  Network Division
> web   : http://www.alles.or.jp/
> email : fujimoto@alles.ad.jp
> tel : 03-3226-8421
> fax : 03-3226-8425
> *--------------------------------*
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
-- 
Peter Courcoux <peter@courcoux.biz>