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(a)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.

Thanks. This worked. I deleted the records in the tables and repository folder. ________________________________ From: "Bhamidi, Krishna" <Krishna.Bhamidi(a)qwest.com&gt; To: Rules Users List <rules-users(a)lists.jboss.org&gt; 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(a)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.