db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject Re: Identity column and 40XL1 error
Date Thu, 18 May 2017 07:33:02 GMT
On 18/05/2017 08:29, Abhirama wrote:
> Hello,
> I am facing 40XL1 error when I try to insert rows into a table with an
> identity column. Identity column has been created using "id integer
> generated by default as identity (START WITH 100, INCREMENT BY 1)". This
> is also the primary key for the table. Start with 100 is used because I
> use 1 to 99 range to insert deterministic values for test cases.

Usual reason is some other query has a lock on the table -- maybe you 
did a SELECT involving that table and forgot to close the ResultSet?
John English

View raw message