<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div>Thanks. This worked. I deleted the records in the tables and repository folder.</div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><br><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> "Bhamidi, Krishna" <Krishna.Bhamidi@qwest.com><br><b><span style="font-weight: bold;">To:</span></b> Rules Users List <rules-users@lists.jboss.org><br><b><span style="font-weight: bold;">Sent:</span></b> Thursday, July 30, 2009 5:36:53 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [rules-users] MySQL and Derby issues with Guvnor<br></font><br>
<style type="text/css">DIV {
MARGIN:0px;}
</style>
<div dir="ltr" align="left"><span class="042503421-30072009"><font face="Arial" color="#0000ff" size="2">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.</font></span></div><br>
<div class="OutlookMessageHeader" lang="en-us" dir="ltr" align="left">
<hr tabindex="-1">
<font face="Tahoma" size="2"><b>From:</b> rules-users-bounces@lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] <b>On Behalf Of </b>Sumant
Kumar<br><b>Sent:</b> Thursday, July 30, 2009 5:12 PM<br><b>To:</b> Rules Users
List<br><b>Subject:</b> [rules-users] MySQL and Derby issues with
Guvnor<br></font><br></div>
<div></div>
<div style="FONT-SIZE:10pt;FONT-FAMILY:arial, helvetica, sans-serif;">
<div>Hi ,</div>
<div><br></div>
<div>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.</div>
<div><br></div>
<div><font class="Apple-style-span" face="tahoma" size="3"><span class="Apple-style-span" style="FONT-SIZE:11px;BORDER-COLLAPSE:collapse;">Any
idea what is the issue</span></font></div>
<div><font class="Apple-style-span" face="tahoma" size="3"><span class="Apple-style-span" style="FONT-SIZE:11px;BORDER-COLLAPSE:collapse;"><br></span></font></div>
<div><font class="Apple-style-span" face="tahoma" size="3"><span class="Apple-style-span" style="FONT-SIZE:11px;BORDER-COLLAPSE:collapse;">
<div>2009-07-30 16:58:09,499 INFO [STDOUT] (main) ERROR 30-07 16:58:09,499
(BundleDbPersistenceManager.java:storeBundle:1270) <span class="Apple-tab-span" style="WHITE-SPACE:pre;"></span>failed to write bundle:
cafebabe-cafe-babe-cafe-babecafebabe</div>
<div>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'.</div>
<div><br></div>
<div>Is there a way to get rid of JacRabbit and use more robust Implemenentation
of JCR.</div></span></font></div>
<div style=""></div></div><br>
</div></div><div style="position:fixed"></div></div><br>
</body></html>