Hi.

I am looking at using JBoss for a website redisign. 

When I tried to create some simple beans in JBuilder X for use with JBoss I found that 
I could retrieve data ok but when I tried to insert into a table I got the following 
error:

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for 
identity column in table
  |  'T_AppraisalForms' when IDENTITY_INSERT is set to OFF.

The problem is that we have an existing database design with lots of identity type 
columns. We also have code that can update the database from external sources so we do 
not have the option to manually increment the keys and use the IDENTITY_INSERT option 
within the query. 


Is there a way in which we can instruct JBoss to not insert values into the identity 
columns of the database?

Regards,
Dan

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839282#3839282

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839282


-------------------------------------------------------
This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to