Re: [rules-users] Drools DB configuration mysql
Hi Michael, looks like you are using supported BRMS bits. Did you also
have support from Red Hat? If so, please use the Customer Support Portal
and raise your questions via support cases.
Thanks.
Tihomir
On 4/18/11 7:54 AM, MichaelBini wrote:
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.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users