db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tak Fujimoto <t-fujim...@beingcorp.co.jp>
Subject problem with Postgresql and sequences for autoincrement
Date Thu, 17 Apr 2003 10:55:39 GMT
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
*--------------------------------*

Mime
View raw message