JORGE IVAN MARMOLEJO wrote:
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??
you can set access="readonly" in the fielddescriptor. cheers,
how can I solve this problem?
thanks....
***************************************** Jorge Ivan Marmolejo H. Ingeniero Java Universidad de San Buenaventura
[EMAIL PROTECTED] [EMAIL PROTECTED]
------------------------------------------------------------------------
Do you Yahoo!?
Free online calendar <http://us.rd.yahoo.com/mail_us/tag/*http://calendar.yahoo.com> with sync to Outlook(TM).
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
