Hi all,

I have some records in a table, added by Hibernate, using native generator. The last aloocated id is, say, 100.

If I go and insert by hand a new record with id 101, when Hibernate tries to insert a new record it gives

SQL Error: -803, SQLState: 23505
12:44:23,135 ERROR JDBCExceptionReporter:46 - [IBM][CLI Driver][DB2/SUN] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "DB2INST1.USERLOGININFO" from having duplicate rows for those columns. SQLSTATE=23505

It seems like Hibernate could not see the externally added record and it tries to overwrite the 101 id ??

I am using DB2 7

Please help.

TIA,
--steve p.

Did you specify the 101 like: insert into myfile (id, desc,...) values(101, 'x',...)? DB2 stores the next value with the table and it won't be incremented unless you use insert into myfile (id, desc,...) values(default, 'x',...)

thx for the answer.

I am actually using DB2 Control Center to manually input data. It autogenerates the SQL stuff.

the sql generated from Command Center:

INSERT INTO
DB2INST1.USERLOGININFO
(
ID,
USER_NAME,
LOGIN_DATE,
LOGIN_TIME,
WORKSTATION,
LOGOFF_DATE,
LOGOFF_TIME,
CURR_LOGGED
)
VALUES
(
86,
'aaa',
'2003-12-16',
'14:19:56',
'2323',
'2003-12-16',
'14:20:00',
2
)

Try running something like:



If this works and you have support, I would report it to IBM. I think this is common with database tools. I ran into the same problem earlier this year with an integration broker inserting records into SQL Server tables.[/code]

thx! it works!