Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 81535 invoked from network); 10 Feb 2004 02:03:12 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 10 Feb 2004 02:03:12 -0000 Received: (qmail 10397 invoked by uid 500); 10 Feb 2004 02:02:49 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 10375 invoked by uid 500); 10 Feb 2004 02:02:49 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 10350 invoked from network); 10 Feb 2004 02:02:49 -0000 Received: from unknown (HELO sccrmhc12.comcast.net) (204.127.202.56) by daedalus.apache.org with SMTP; 10 Feb 2004 02:02:49 -0000 Received: from shark.mindspring.com (pcp573635pcs.wilmsc01.tn.comcast.net[68.52.66.241]) by comcast.net (sccrmhc12) with SMTP id <200402100202570120081kede>; Tue, 10 Feb 2004 02:02:57 +0000 Message-Id: <6.0.0.22.2.20040209200235.01c65db0@pop.mindspring.com> X-Sender: robbroadhead@pop.mindspring.com X-Mailer: QUALCOMM Windows Eudora Version 6.0.0.22 Date: Mon, 09 Feb 2004 20:02:54 -0600 To: torque-user@db.apache.org From: Rob Broadhead Subject: Postgres sequences in version 3.0.2 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed 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 I have seen several posts about problems with Postgres sequences returning this kind of error: org.apache.torque.TorqueException: IdGenerator for table 'Clients' is null at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:690) at com.athlon.managers.BaseClientsPeer.doInsert(BaseClientsPeer.java:236) at com.athlon.managers.BaseClientsPeer.doInsert(BaseClientsPeer.java:602) at com.athlon.managers.BaseClients.save(BaseClients.java:1825) at com.athlon.action.ClientAction.execute(ClientAction.java:77) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) I have sequences setup and have even tried to force adding an idgenerator via this code: dbMap.addIdGenerator("myDB",new SequenceIdGenerator(Torque.getDB("myDB"))); (BTW what is the string parameter supposed to be for this method? I'm not sure I have that parm correct) all to no avail. I assume someone is using Postgres with torque so do I need to simply convert to the id broker or is there a way to get the sequences to work. Any help or places to look or an example of adding an IDGenerator would be appreciated. Thanks, Rob //-------------------------------------------------------------------- Rob Broadhead - Consultant RB Consulting Inc. Rob@RB-SNS.com //-------------------------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org