<div>&nbsp;</div>
<div>I think I worked it out.</div>
<div>&nbsp;</div>
<div>It&#39;s just a matter of making the jndi name global.</div>
<div>&nbsp;</div>
<div>It seems that JBoss does not allow me to use the mysql</div>
<div>repository name as a local &quot;java:&quot; name.</div>
<div>&nbsp;</div>
<div>I made it global and everything went smoothly!</div>
<div>&nbsp;</div>
<div>Now I am just wondering whether there is a chance</div>
<div>to make it local in someway....</div>
<div>&nbsp;</div>
<div>Is it possible? Is it a JBoss 4.2.2 BUG?</div>
<div>&nbsp;</div>
<div>I post the old .xml files again:</div>
<div>&nbsp;</div>
<div>(In the current version I just disabled the local namespace setting: &lt;use-java-context&gt;false&lt;/use-java-context&gt;)</div>
<div>&nbsp;</div>
<div>
<div>&lt;datasources&gt;<br>&nbsp;&lt;local-tx-datasource&gt;<br><br>&nbsp;&nbsp;&lt;jndi-name&gt;jdbc/MySQLDB&lt;/jndi-name&gt;<br>&nbsp;&nbsp;&lt;connection-url&gt;jdbc:mysql:///brms-db&lt;/connection-url&gt;<br>&nbsp;&nbsp;&lt;driver-class&gt;com.mysql.jdbc.Driver
 &lt;/driver-class&gt;<br>&nbsp;&nbsp;&lt;user-name&gt;drools&lt;/user-name&gt;<br>&nbsp;&nbsp;&lt;password&gt;drools&lt;/password&gt;<br>&nbsp;&nbsp;&lt;min-pool-size&gt;5&lt;/min-pool-size&gt;<br>&nbsp;&nbsp;<br>&nbsp;&nbsp;&lt;max-pool-size&gt;20&lt;/max-pool-size&gt;
<br>&nbsp;&nbsp;<br>&nbsp;&nbsp;&lt;idle-timeout-minutes&gt;5&lt;/idle-timeout-minutes&gt;<br><br>&nbsp;&nbsp;&lt;exception-sorter-class-name&gt;<br>&nbsp;&nbsp;com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter<br>&nbsp;&nbsp;&lt;/exception-sorter-class-name&gt;
<br>&nbsp;&nbsp;<br>&nbsp;&nbsp;&lt;valid-connection-checker-class-name&gt;<br>&nbsp;&nbsp;com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker<br>&nbsp;&nbsp;&lt;/valid-connection-checker-class-name&gt;<br>&nbsp;&nbsp;<br>&nbsp;&lt;/local-tx-datasource&gt;<br>&lt;/datasources&gt; 
</div>
<div>&nbsp;</div>
<div>I&#39;ve got the following persistence manager set-up in &lt;jboss_home&gt;\bin\repository.xml:</div>
<div>&nbsp;</div>
<div>&nbsp;&lt;PersistenceManager class=&quot;org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager&quot;&gt;<br>&nbsp;&nbsp;&lt;param name=&quot;dataSourceLocation&quot; value=&quot;java:jdbc/MySQLDB&quot;/&gt;<br>&nbsp;&nbsp;&lt;param name=&quot;schema&quot; value=&quot;mysql&quot;/&gt;
<br>&nbsp;&nbsp;&lt;param name=&quot;schemaObjectPrefix&quot; value=&quot;${<a href="http://wsp.name/"><strong><font color="#002390">wsp.name</font></strong></a>}_&quot;/&gt;<br>&nbsp;&nbsp;&lt;param name=&quot;externalBLOBs&quot; value=&quot;false&quot; /&gt;&nbsp;&nbsp; 
<br>&nbsp;&lt;/PersistenceManager&gt;</div>
<div>&nbsp;</div>
<div>Hope u can help with this.....</div>
<div>&nbsp;</div>
<div>Massi</div></div>