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

[Fernando Meyer]

On 10/8/07, Fernando Meyer <fernando at fmeyer.org> wrote:
>
> 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 at 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 at lists.jboss.org
> > > https://lists.jboss.org/mailman/listinfo/rules-dev
> > >
> >
> > _______________________________________________
> > rules-dev mailing list
> > rules-dev at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/rules-dev
> >
>
>
>
> --
> Fernando Meyer http://fmeyer.org
> JBoss Rules Core Developer
> fmcamargo at gmail.com
>



-- 
Fernando Meyer http://fmeyer.org
JBoss Rules Core Developer
fmcamargo at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-dev/attachments/20071008/6dfd1b19/attachment.html