Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with OJB

 
JORGE IVAN MARMOLEJO
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
andrew you helped me out, thanks!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic