<div> </div>
<div>First of All.......<strong><font size="4">Environment: Drools BRMS 4.0.3, JBossAS 4.2.2, MySql 5</font></strong></div>
<div> </div>
<div>Hi Guys,</div>
<div> </div>
<div>It's making me waste all the day trying to set "JNDIDatabasePersistenceManager" as mysql-repository persistence manager.</div>
<div> </div>
<div>I show u the issue...</div>
<div> </div>
<div><u><strong>In MySql I've got an empty "brms-db" schema.</strong></u></div>
<div> </div>
<div><u><strong>In JBoss default workspace I've got the following datasource definition in mysql-ds.xml:</strong></u></div>
<div> </div>
<div><em><datasources><br> <local-tx-datasource><br><br> <jndi-name>jdbc/MySQLDB</jndi-name><br> <connection-url>jdbc:mysql:///brms-db</connection-url><br> <driver-class>com.mysql.jdbc.Driver
</driver-class><br> <user-name>drools</user-name><br> <password>drools</password><br> <min-pool-size>5</min-pool-size><br> <br> <max-pool-size>20</max-pool-size><br>
<br> <idle-timeout-minutes>5</idle-timeout-minutes><br><br> <exception-sorter-class-name><br> com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter<br> </exception-sorter-class-name><br>
<br> <valid-connection-checker-class-name><br> com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker<br> </valid-connection-checker-class-name><br> <br> </local-tx-datasource><br></datasources>
</em></div>
<div> </div>
<div><u><strong>I've got the following persistence manager set-up in <jboss_home>\bin\repository.xml:</strong></u></div>
<div> </div>
<div><em> <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager"><br> <param name="dataSourceLocation" value="java:jdbc/MySQLDB"/><br>
<param name="schema" value="mysql"/><br> <param name="schemaObjectPrefix" value="${<a href="http://wsp.name">wsp.name</a>}_"/><br> <param name="externalBLOBs" value="false" />
<br> </PersistenceManager> </em></div>
<div> </div>
<div> </div>
<div><u><strong>Once I start JBoss I get back the following exception:</strong></u></div>
<div> </div>
<div><em>2007-11-28 16:48:36,766 INFO [STDOUT] ERROR 28-11 16:48:36,743 (RepositoryImpl.java:initStartupWorkspaces:389) Failed to initialize workspace 'default'<br>javax.jcr.RepositoryException: Cannot instantiate persistence manager
org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager: null: null<br> at org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1184)<br> at org.apache.jackrabbit.core.RepositoryImpl.access$600
(RepositoryImpl.java:103)<br> at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1758)<br> at org.apache.jackrabbit.core.RepositoryImpl.initWorkspace(RepositoryImpl.java:603)<br> at
org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:386)<br> at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:293)<br> at org.apache.jackrabbit.core.RepositoryImpl.create
(RepositoryImpl.java:584)<br> at org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:245)</em></div>
<div><em>...</em></div>
<div> </div>
<div>I tried to replace "<em>org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager</em>" with "<em>org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager</em>"</div>
<div>and It <strong>DOES</strong> Work ....so I think we can exclude it's something related to "JackRabbit API" null references...</div>
<div> </div>
<div>Have U got any idea? </div>
<div>What is the reason?</div>
<div>Did I miss any binding concernig the DataSource definition?????</div>
<div>Is it just impossible to bind JackRabbit to any datasources although JNDI APIs do exist?????</div>
<div>Is it a matter related to the "weird JackRabbit JNDI client"??</div>
<div> </div>
<div>Let me know.</div>
<div> </div>
<div>Thank You again.</div>
<div> </div>
<div>Massi</div>
<div> </div>