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

[Paul Browne]

Fernando,

I was just about to copy and paste the entire article, when I realised 
that the wiki syntax is subtly different from the MediaWiki/ Wikipedia 
one that I use :-(

I've nothing against somebody using it (it's creative commons after all) 
as a basis for a more comprehensive page on JBoss. For the moment I've 
just put a link so at least people can find the info.

Paul



Fernando Meyer wrote:
> Hi Mike,
>
> Could you also contribute/share this information into drools wiki?
>
> On 10/8/07, *Fernando Meyer* < fernando at fmeyer.org 
> <mailto:fernando at fmeyer.org>> wrote:
>
>     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_Weblogic
>     <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
>     <mailto: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
>         <http://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
>         <http://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>
>         > <
>         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> <
>         http://www.firstpartners.net/blog>
>         >
>         >
>         > ------------------------------------------------------------------------
>         >
>         > _______________________________________________
>         > rules-dev mailing list
>         > rules-dev at lists.jboss.org <mailto:rules-dev at lists.jboss.org>
>         > https://lists.jboss.org/mailman/listinfo/rules-dev
>         >
>
>         _______________________________________________
>         rules-dev mailing list
>         rules-dev at lists.jboss.org <mailto:rules-dev at lists.jboss.org>
>         https://lists.jboss.org/mailman/listinfo/rules-dev
>         <https://lists.jboss.org/mailman/listinfo/rules-dev>
>
>
>
>
>     -- 
>     Fernando Meyer http://fmeyer.org
>     JBoss Rules Core Developer
>     fmcamargo at gmail.com <mailto:fmcamargo at gmail.com>
>
>
>
>
> -- 
> Fernando Meyer http://fmeyer.org
> JBoss Rules Core Developer
> fmcamargo at gmail.com <mailto:fmcamargo at gmail.com>
> ------------------------------------------------------------------------
>
> _______________________________________________
> rules-dev mailing list
> rules-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-dev
>