Hi Mike,

Could you also contribute/share this information into drools wiki?
http://wiki.jboss.org/wiki/Wiki.jsp?page=Deploying_JBoss_Drools_BRMS_on_Weblogic

Regards

On 10/8/07, Mike McMahon < michael.mcmahon@activewire.net> wrote:

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@lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-dev
>

_______________________________________________
rules-dev mailing list
rules-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-dev

--
Fernando Meyer http://fmeyer.org
JBoss Rules Core Developer
fmcamargo@gmail.com