[rules-users] Drools DB configuration mysql
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"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD
Jackrabbit 1.4//EN"
"http://jackrabbit.apache.org/dtd/repository-1.4.dtd">
<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-tp2834080...
Sent from the Drools: User forum mailing list archive at Nabble.com.