Return-Path: 
 <torque-user-return-3896-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 2576 invoked from network); 6 Jan 2004 12:02:14 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 6 Jan 2004 12:02:14 -0000
Received: (qmail 27783 invoked by uid 500); 6 Jan 2004 12:02:10 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 27770 invoked by uid 500); 6 Jan 2004 12:02:10 -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 27756 invoked from network); 6 Jan 2004 12:02:09 -0000
Received: from unknown (HELO mail.iinet.net.au) (203.59.3.38)
  by daedalus.apache.org with SMTP; 6 Jan 2004 12:02:09 -0000
Received: (qmail 14405 invoked from network); 6 Jan 2004 12:02:07 -0000
Received: from unknown (HELO backstagetech.com.au) (203.217.17.173)
  by mail.iinet.net.au with SMTP; 6 Jan 2004 12:02:07 -0000
Message-ID: <3FFAA3BB.7000908@backstagetech.com.au>
Date: Tue, 06 Jan 2004 23:02:03 +1100
From: Scott Eade <seade@backstagetech.com.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.5) Gecko/20031007
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Re: Problem with postgresql
References: <opr1cf9yyggzom00@smtprelay.t-online.de>
 <20040106204542.28B8.HASSAN.ABOLHASSANI@razorfish.co.jp>
 <20040106205048.28BA.HASSAN.ABOLHASSANI@razorfish.co.jp>
In-Reply-To: <20040106205048.28BA.HASSAN.ABOLHASSANI@razorfish.co.jp>
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit
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

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