[rules-users] Drools DB configuration mysql

[MichaelBini]

Hi ,
I am using brms-standalone-5.1.0
I try to connect it into MySql DB.
My step are :
  1.Run Guvnor with default,and generate the repository.xml and folder at
JBOSS_HOME\bin dictionary
  2.I edit repository.xml and delete the folder.
  3.install Mysql database,and create the drools database instance,and copy
mysql driver to JBOSS_HOME\server\deploy\lib
  4.Restart the JBoss ,i get the exception:

ERROR 18-04 14:46:24,922 (DatabasePersistenceManager.java:store:476) 	
failed to write node state: deadbeef-cafe-babe-cafe-babecafebabe
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry 'deadbeef-cafe-babe-cafe-babecafebabe' for key
'DEFAULT_NODE_IDX'


repository.xml - 


<?xml version="1.0"?>

&lt;!DOCTYPE Repository PUBLIC &quot;-//The Apache Software Foundation//DTD
Jackrabbit 1.4//EN&quot;
                           
&quot;http://jackrabbit.apache.org/dtd/repository-1.4.dtd&quot;&gt;
<Repository>
    <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
        
    </FileSystem>
    <Security appName="Jackrabbit">
        <AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
        </AccessManager>
        <LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
        </LoginModule>
    </Security>
    <Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
    <Workspace name="default">
        <FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            
        </FileSystem>
        <SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            
            
            
            
        </SearchIndex>
    </Workspace>
    <Versioning rootPath="${rep.home}/version">
        <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
            
                        
            
            
            
            
        </FileSystem>
        <PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
            
             
            
            
            
            
            
        </PersistenceManager>
    </Versioning>
    <SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
        
        
        
        
    </SearchIndex>
</Repository>

--
View this message in context: http://drools.46999.n3.nabble.com/Drools-DB-configuration-mysql-tp2834080p2834080.html
Sent from the Drools: User forum mailing list archive at Nabble.com.