Re: deleting openjpa_sequence_table

2019-01-06 Thread Matthew Broadhead
hi Mark, there are no tables conflicting between the databases.  i want to simplify by moving tables from 3 databases into 1.  so merging the data is not a problem. that is a good hint about openjpa.Sequence.  at the moment it seems to just use one sequence for all the tables.  can i add tha

Re: deleting openjpa_sequence_table

2019-01-05 Thread Mark Struberg
Hi Matthew! As Craig already explained they contain the hightest value for a specified index. Of course only if no Database Sequence got used! The reason to use this over a Sequence is to have a database independent counter which is fully portable. There are also multiple 'modes' for the sequen

Re: deleting openjpa_sequence_table

2019-01-04 Thread Craig Russell
It might be best to inspect the tables and merge them when you merge the databases. IIRC they hold the highest keys that have been used and simply dropping them might introduce errors. Craig > On Jan 4, 2019, at 5:40 AM, Matthew Broadhead > wrote: > > i am about to merge a few databases. ea

deleting openjpa_sequence_table

2019-01-04 Thread Matthew Broadhead
i am about to merge a few databases.  each database has an openjpa_sequence_table.  do i just drop these tables?