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
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-dev

_______________________________________________
rules-dev mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-dev

Reply via email to