[rules-users] Drools DB configuration mysql

[Tihomir Surdilovic]

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"?>
>
> &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.
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>