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

Hi Mike, Could you also can contribute/share this information into drools wiki? http://wiki.jboss.org/wiki/Wiki.jsp?page=Deploying_JBoss_Drools_BRMS_on_W... Regards On 10/8/07, Mike McMahon <michael.mcmahon(a)activewire.net&gt; 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_... > > <http://www.firstpartners.net/kb/index.php/Deploying_JBoss_Drools_BRMS_on_... > >. > > > > 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(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/rules-dev > > > > _______________________________________________ > rules-dev mailing list > rules-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-dev > -- Fernando Meyer http://fmeyer.org JBoss Rules Core Developer fmcamargo(a)gmail.com