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

[Jervisliu]

A quick Google search indicated that this is probably a JackRabbit 
issue, see [1]. Did not dig deeper to see if this issue has been fixed 
in JackRabbit. You may want to find it out by yourself. One workaround 
is to replace ${wsp.name <http://wsp.name>} with "default".

[1]. 
http://mail-archives.apache.org/mod_mbox/jackrabbit-dev/200601.mbox/%3C004701c61db2$244cb970$b6fdfe0a@gkaradimitr%3E

Cheers,
Jervis Liu

Sinboy Zhang wrote:
> 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 
> <http://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 
> <http://wsp.name>}.: Replacement not found for ${wsp.name 
> <http://wsp.name>}.
>  
>   Why?Please help me,thanks!
> ------------------------------------------------------------------------
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>