i have used Talend to migrate database from AS400 to Apache Derby. Everything is ok up to that point. The problem is that: since i have inserted data THROUGH Talend, Apache derby does not update its system tables. For example, since i had 5 rows in table A, the old MAX primary key value of table A was 5. When i inserted 1000 data THROUGH Talend, the new MAX primary key value should be 1005. However, IT IS AGAIN 5! This is DUE TO I HAVE NOT USED DERBY TO INSERT DATA!
i have to find some way to update the system tables of my Apache Derby database, which i believe is SYS.SYSCOLUMNS.AUTOINCREMENTVALUE especially. As SYS.SYSCOLUMNS.AUTOINCREMENTVALUE of table A is still 5, as far as i have discovered. However it should be 1005. in other words I have used Talend to migrate the database from AS400 to Apache Derby database. Everything worked good at that point. Now, i have the correct data values in my Apache Derby database. But the problem is that, since i inserted the data into Apache Derby database through Talend, Apache Derby does not know that the primary key values are now different and higher. SYS.SYSCOLUMNS.AUTOINCREMENTVALUE, which Apache Derby uses to keep track of the highest primary key values in the tables, is not updated accordingly. As a result, when i want to insert new data values collisions occur and i get primary key violation errors. What i should do Derby to update system table values also, especially the SYS.SYSCOLUMNS.AUTOINCREMENTVALUE column? Please hep me -- View this message in context: http://www.nabble.com/Need-HELP-GUYS-%3A%28%28-tp19317524p19317524.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.
