<div> </div>
<div>Thank You Jeffrey, but I did as u told me but anything changed....</div>
<div> </div>
<div> </div>
<div>Here is the DS definition:</div>
<div> </div>
<div><em><local-tx-datasource><br> <jndi-name>jdbc_XA/Drools_Rep</jndi-name><br> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class><br> <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url><br>
<user-name>...</user-name><br> <password>...</password><br> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name><br>
<br> <metadata><br> <type-mapping>Oracle9i</type-mapping><br> </metadata><br> <use-java-context>false</use-java-context> <br></local-tx-datasource></em></div>
<div> </div>
<div> </div>
<div>... I got back the same exception even with the local-tx Datasource!!</div>
<div> </div>
<div><font size="2">
<p align="left"><em>17:35:33,430 INFO [STDOUT] PackageName: com.spyd.rules.Scoring</em></p>
<p align="left"><em>17:35:33,430 INFO [STDOUT] PackageVersion: Scoring</em></p>
<p align="left"><em>17:35:33,430 INFO [STDOUT] PackageIsLatest: false</em></p>
<p align="left"><em><strong><font color="#ff0000">----</font></strong></em></p>
<p align="left"><em><strong><font color="#ff0000">(I THINK THIS ONE DOES NOT REALLY MATTER)</font></strong></em></p>
<p align="left"><em><font color="#ff0000"><strong>17:35:43,559 INFO [STDOUT] ERROR 22-02 17:35:43,558 (</strong></font></em></p></font><u><font size="2"><em><font color="#ff0000"><strong>Contexts.java:flushAndDestroyContexts:335</strong></font></em></font></u><font size="2"><em><font color="#ff0000"><strong>) could not discover transaction status</strong></font></em></font>
<p align="left"><font size="2"><strong><em><font color="#ff0000">----</font></em></strong></font></p>
<p align="left"><em>17:35:43,560 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@ccc4e9</em></p>
<p align="left"><em>java.lang.Throwable: STACKTRACE</em></p>
<p align="left"><em>at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(</em><u><font color="#000080" size="2"><em>CachedConnectionManager.java:290</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(</em><u><font color="#000080" size="2"><em>BaseConnectionManager2.java:417</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(</em><u><font color="#000080" size="2"><em>BaseConnectionManager2.java:842</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(</em><u><font color="#000080" size="2"><em>WrapperDataSource.java:88</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager.getConnection(</em><u><font color="#000080" size="2"><em>JNDIDatabasePersistenceManager.java:77</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.initConnection(</em><u><font color="#000080" size="2"><em>DatabasePersistenceManager.java:730</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.reestablishConnection(</em><u><font color="#000080" size="2"><em>DatabasePersistenceManager.java:806</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.executeStmt(</em><u><font color="#000080" size="2"><em>DatabasePersistenceManager.java:852</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.exists(</em><u><font color="#000080" size="2"><em>DatabasePersistenceManager.java:673</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.state.SharedItemStateManager.hasNonVirtualItemState(</em><u><font color="#000080" size="2"><em>SharedItemStateManager.java:1104</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.state.SharedItemStateManager.hasItemState(</em><u><font color="#000080" size="2"><em>SharedItemStateManager.java:289</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.state.LocalItemStateManager.hasItemState(</em><u><font color="#000080" size="2"><em>LocalItemStateManager.java:180</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.state.XAItemStateManager.hasItemState(</em><u><font color="#000080" size="2"><em>XAItemStateManager.java:252</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.state.SessionItemStateManager.hasItemState(</em><u><font color="#000080" size="2"><em>SessionItemStateManager.java:199</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.ItemManager.itemExists(</em><u><font color="#000080" size="2"><em>ItemManager.java:258</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.apache.jackrabbit.core.NodeImpl.hasProperty(</em><u><font color="#000080" size="2"><em>NodeImpl.java:2708</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.drools.repository.PackageItem.getCompiledPackageBytes(</em><u><font color="#000080" size="2"><em>PackageItem.java:666</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at org.drools.brms.server.files.FileManagerUtils.loadBinaryPackage(</em><u><font color="#000080" size="2"><em>FileManagerUtils.java:146</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at sun.reflect.NativeMethodAccessorImpl.invoke0(</em><u><font color="#000080" size="2"><em>Native Method</em></font></u><font size="2"><em>)</em></font></p>
<p align="left"><em>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)</em></p>
<p align="left"><em>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</em></p>
<p align="left"><em>at java.lang.reflect.Method.invoke(Unknown Source)</em></p>
<p align="left"><em>at org.jboss.seam.util.Reflections.invoke(</em><u><font color="#000080" size="2"><em>Reflections.java:21</em></font></u><font size="2"><em>)</em></font></p>
<p><em>at org.jboss.seam.intercept.RootInvocationContext.proceed(</em><u><font color="#000080" size="2"><em>RootInvocationContext.java:31</em></font></u><font size="2"><em>)</em></font></p></div>
<div> </div>
<div> </div>
<div>I am quite annoyed with this, cause when I define a direct</div>
<div>JDBC connection to the Oracle Drools Repository everything</div>
<div>works as expected and it is really Fast as well!</div>
<div> </div>
<div>So... Why do I get this kind of issues once I use the Datasource????</div>
<div> </div>
<div>Can You advise me any way to (at least) reduce the exception</div>
<div>waiting time?</div>
<div> </div>
<div>Let me know.</div>
<div> </div>
<div>Thank again</div>
<div> </div>
<div>Massi</div>