[rules-users] MySQL and Derby issues with Guvnor

[Sumant Kumar]

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



________________________________
From: "Bhamidi, Krishna" <Krishna.Bhamidi at qwest.com>
To: Rules Users List <rules-users at 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 at lists.jboss.org 
[mailto:rules-users-bounces at 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.



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20090731/4d75ff50/attachment.html