Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <44B890F2.2030905@bigpond.net.au>
Date: Sat, 15 Jul 2006 16:53:38 +1000
From: Steve Vanspall <svanspal@bigpond.net.au>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: torque-user@db.apache.org
Subject: IdBroker with sequences in DB2, or perhaps native. How does it work
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi there,

I am going mad here.

I have tried a few options for geting torque to use an already existing 
sequence , in db2, to generate the id's for certain tables.

One article suggested setting the defaultIdMethod to native and having a 
parameter "id-method-parameter" whose vlaue is the name of the sequence 
to be used.

This doesnt work, all I get is.

this warning

IDBroker - IDBroker is being used with db '@DB_NAME@', which does not 
support transactions. IDBroker attempts to use transactions to limit the 
possibility of duplicate key generation.  Without transactions, 
duplicate key generation is possible if multiple JVMs are used or other 
means are used to write to the database.

follow by the following exception

There was no DataSourceFactory configured for the connection @DB_NAME@

So I tried setting the dafultIdMEthod to idbroker.

the same thing happened.

Do I have to define a class that get the sequence data for me. This is 
no problem, but I cannot find any decent documentation stating how to do 
this.

What do I implement and how do I tell torque what class isthe id broker??

Any help would be appreciated

Steve

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