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??



************************************************

Jorge ivan  Marmolejo
Java Engineer
Universidad de San Buenaventura


[EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]

_________________________________________________________________
Charla con tus amigos en l�nea mediante MSN Messenger: http://messenger.yupimsn.com/



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



Reply via email to