Figured out what was going wrong. The answer is in OJB.properties file. The OJB by default uses SequenceManagerHiLoImpl class to generate the auto increment ids and the SequenceManagerGrabSize is set to 10 in property file. Either we can set the latter property to 1 or use the class SequenceManagerHiLoContinuousImpl
Jay -----Original Message----- From: Duraisamy, Jayakumar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:16 AM To: '[EMAIL PROTECTED]' Subject: Auto Increment feature default value and increment questions Hello, I have the following issues with the auto increment features of OJB 0.9.8.. I have created a table in MS SQL and a test application to store a new object. It works fine but each record's primary key is incremented by 10 due to the OJB's auto increment feature. 1. Where to find the default value for the auto increment and the increment value in OJB. 2. Alternatively how to make use of the auto increment features of the underlying database in OJB Your help is appreciated Jay _____ Jayakumar Duraisamy, SCJP, SCJD, SCEA CDC Information Systems Support Services (CISSS) Contractor Support to Secure Data Network [OPS/IRMO] Voice: 404-639-7371 Fax: 404-639-7721 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
