[rules-users] How to store the rules data into RDBMS, like mysql, oracle

Sinboy Zhang iamsinboy at gmail.com
Sun Nov 29 01:02:01 EST 2009


Hi,all:
   Guvnor is a BRMS,it can manage the rules through Jackrabbit
Repository.The default,Guvnor work well with derby database.But i want it
work with my database,just like MySQL.
My step is :
  1.Run Guvnor with default,and generate the repository.xml and repository
dictionary at JBOSS_HOME\bin dictionary
  2.delete repository dictionary and edit repository.xml,only replace the
content in <PersistenceManage> label ,just like this:
    <PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
       <param name="driver" value="com.mysql.jdbc.Driver"/>
       <param name="url" value="jdbc:mysql://localhost:3306/guvnor_db"/>
       <param name="user" value="root" />
       <param name="password" value="a123456" />
       <param name="schema" value="mysql"/>
       <param name="schemaObjectPrefix" value="${wsp.name}_"/>
       <param name="externalBLOBs" value="false"/>
   </PersistenceManager>
  3.install Mysql database,and create the guvnor_db database instance,and
copy mysql driver to JBOSS_HOME\server\deploy\lib
  4.Restart the JBoss ,i get the exception:
     org.drools.repository.RulesRepositoryException:
javax.jcr.RepositoryException: Invalid repository configuration:
repository.xml: Replacement not found for ${wsp.name}.: Replacement not
found for ${wsp.name}.

  Why?Please help me,thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20091129/1232d0da/attachment.html 


More information about the rules-users mailing list