Problem with OJB

[JORGE IVAN MARMOLEJO]

Hi
I have a problem with an autoincrement field with SQL server database, table is the follow:
create table Person(
id int primary key IDENTITY (1, 1) NOT NULL ,
nombre varchar(30));
in this case OJB intents to insert the id, which generates an error :
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identity column in table 'test' when IDENTITY_INSERT is set to OFF

the same problem occurs with autoincrement fields of Mysql
is there away to tell OJB, not to insert id in the test table, because it's an autoincrement??

[Andrew Edwards]

Old thread but... has anyone come across an answer to this? I am about to come up to a similar problem where it is easier to use mysql autoincrement for key generation.

[Andrew Edwards]

To answer my own question, just in case anyone searching finds this post,

http://db.apache.org/ojb/docu/guides/sequencemanager.html#native

[adam eason]

andrew you helped me out, thanks!