[rules-dev] Documentation: BRMS on Weblogic using MySQL instead of Derby Database

[Mike McMahon]

Paul,
thanks for the great info. Like you I have reconfigured jackrabbit to 
use a (non-derby) database and here are some comments:

1) I find the speed is about 20X slower this way versus using derby 
(almost unacceptably slow.. maybe because I use JNDIDatabaseFileSystem?)

2) if you prefer to use a WebLogic connection pooled connection it goes 
like this:

    <PersistenceManager 
class="org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager">
        <param name="dataSourceLocation" 
value="java:comp/env/jdbc/MyJndiPoolName"/>
        <param name="schema" value="mysql"/>
        <param name="schemaObjectPrefix" value="${wsp.name}_"/>       
          <param name="externalBLOBs" value="false" />
    </PersistenceManager>

3) you can also use the database instead of local filesystem storage:

<FileSystem class="org.apache.jackrabbit.core.fs.db.JNDIDatabaseFileSystem">
        <param name="dataSourceLocation" 
value="java:comp/env/jdbc/MyJndiPoolName"/>
        <param name="schema" value="mssql"/>
        <param name="schemaObjectPrefix" value="${wsp.name}"/>       
</FileSystem>


Paul Browne wrote:
> Michael,
>
> I've documented the process of getting Drools BRMS running on Weblogic 
> (i.e. non JBoss App Server) at 
> http://www.firstpartners.net/kb/index.php/Deploying_JBoss_Drools_BRMS_on_Weblogic 
> <http://www.firstpartners.net/kb/index.php/Deploying_JBoss_Drools_BRMS_on_Weblogic>.
>
> It also covers using a non-Derby DB - the sample used is MySQL , but 
> just as easy for Sql-Server or Oracle.
>
> Two Questions:
>
> a) Is there anything that you think I've missed?
> b) I'm happy for this doc to live on my Wiki (and link to it), or 
> would you prefer to add this to the JBoss Drools Wiki?
>
> I'm still trying to 'break' this, but let me know what you think.
>
> Paul
>
> www.firstpartners.net/blog <http://www.firstpartners.net/blog>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> rules-dev mailing list
> rules-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-dev
>