Delete the repository directory on the server domainroot. Delete all tables in the database created by guvnor , and try to bring up guvnor again, it shouls come up.

From: [] On Behalf Of Sumant Kumar
Sent: Thursday, July 30, 2009 5:12 PM
To: Rules Users List
Subject: [rules-users] MySQL and Derby issues with Guvnor

Hi ,

I have changed the defualt Derby DB to MySQL  DB for the JacRabbit in Guvnor. I see this below exception when I try to bring up the JBOSS AS and Guvnor.

Any idea what is the issue

2009-07-30 16:58:09,499 INFO  [STDOUT] (main) ERROR 30-07 16:58:09,499 ( failed to write bundle: cafebabe-cafe-babe-cafe-babecafebabe
ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090729054055150' defined on 'DEFAULT_BUNDLE'.

Is there a way to get rid of JacRabbit and use more robust Implemenentation of JCR.