db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Eade <se...@backstagetech.com.au>
Subject Re: Problem with postgresql
Date Tue, 06 Jan 2004 12:02:03 GMT
Hassan Abolhassani wrote:

>In the previous mail subject was not appropriate, I resend with more
>appropriate subject. Sorry for any inconvenience.
>
>Hi,
>
>When I try to insert a row in a table with autoincrement id I get the
>following exception:
>
>org.apache.torque.TorqueException: IdGenerator for table 'HOSPITAL' is null
>
>It was working before in mysql but when I moved to postgresql it is not
>working anymore.
>
>I have following definition in schema for table hospital:
><column name="ID" required="true" autoIncrement="true" primaryKey="true" type="INTEGER"
/>
>
>and in postgresql there are two sequences cretared by ant task:
>
>hospital_id_seq, and hospital_seq
>  
>
The following is cut directly from a message I sent to this very list
only yesterday:

> For PostgreSQL I recommend that you specify include:
>
> <id-method-parameter name="seqName"
> value="addr_groups_addr_group_id_seq"/>

In your case this would be: hospital_hospital_id_seq

>
> within your table element.
>
> You should also be sure to check out:
>
> http://nagoya.apache.org/wiki/apachewiki.cgi?TorqueProjectPages/PostgreSQLFAQ
>


Scott
-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au





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


Mime
View raw message