db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Georgi Naplatanov <go...@oles.biz>
Subject too many waiting objects
Date Fri, 13 Jan 2006 14:15:14 GMT
Hello, ddlutils is a great tool,
i try to migrate hsqldb database to apache derby and i have  
synchronization problem with autogenerated keys from the old (source) db 
and new values from the new db (target db - derby).

Lets say we hawe one row from the parent table

parent table - old db
pk autoincrement - id = 35


parent table- new db
pk autoincrement - id = 2

In this case ddlutils can't insert rows to the tables wich has fk from 
parent tables because id value was changed from 35 to 2.

For apache derby i use attached pach for lastInsertedId implementation

Regards

Mime
View raw message