db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Courcoux <pe...@courcoux.biz>
Subject Re: problem with Postgresql and sequences for autoincrement
Date Thu, 17 Apr 2003 13:21:53 GMT
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>

Mime
View raw message