Postgres sequences in version 3.0.2

[Rob Broadhead]

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.
[EMAIL PROTECTED]
//--------------------------------------------------------------------  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]