<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE type=text/css>DIV {
MARGIN: 0px
}
</STYLE>
<META content="MSHTML 6.00.6000.16850" name=GENERATOR></HEAD>
<BODY>
<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; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px">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; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px"><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; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px">
<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="POSITION: fixed"></DIV></DIV><BR></BODY></HTML>