I think the issue might be that there is no identity being generated because you are supplying a value (DEFAULT) for the id field. You don't need to reference identity columns at all on inserts. Rewrite your insert like this and give it a try:
insert into Dictionary (word, value, description, idLesson) values (#key#, #translation#, #description# ,#idLesson# ) Jeff Butler On Sat, Jan 10, 2009 at 3:03 AM, LiborP <[email protected]> wrote: > > > > Mario Ds Briggs wrote: >> >> Is it possible that in your ibatis application, the insert statement and >> the 'values IDENTITY....' statement are executed on different connections. >> > > Hi Mario, thanks for the reply. I'm using embedded Derby instance, it means > that only one connection per database is allowed. > Any another idea? Thanks... > > -- > View this message in context: > http://www.nabble.com/Obtain-generated-ID-tp21372327p21386184.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >
