Hello again Apache Derby !
Lately i've met some errors that outputs like this :
java.sql.SQLException: The statement was aborted because it would have
caused a duplica
te key value in a unique or primary key constraint or unique index
identified by 'SQL080706164629120' defined
on 'MST_GROUP'
This
Hi
My user is on windows xp. Apache Derby - 10.2.2.0
Any help on fixing this database would be appreciated.
When we apply data updates, we basically wipe out the data from a subset of
tables and re-insert new data e.g. with product prices etc. We are getting
this exception with this one user,
Why not using SYSCS_UTIL.SYSCS_BACKUP_DATABASE? I have been using similar
procedure in Cloudscape (derby's predecessor) for years and it creates
consistent copy of the database.
On Tue, Jul 8, 2008 at 10:28 AM, Andrew Lawrenson <
[EMAIL PROTECTED]> wrote:
> What's worked for me (although anyone e
What's worked for me (although anyone else feel free to correct me) is:
1) checkpoint the database by running SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()
2) freeze the database by running SYSCS_UTIL.SYSCS_FREEZE_DATABASE()
3) copy your log files (_all_ files in log dir)
4) unfreeze the database by runn