Thanks. This worked. I deleted the records in the tables and repository folder.

From: "Bhamidi, Krishna" <Krishna.Bhamidi@qwest.com>
To: Rules Users List <rules-users@lists.jboss.org>
Sent: Thursday, July 30, 2009 5:36:53 PM
Subject: Re: [rules-users] MySQL and Derby issues with Guvnor

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: rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] 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 (BundleDbPersistenceManager.java:storeBundle:1270) 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.