Thank You Jeffrey, but I did as u told me but anything changed....
 
 
Here is the DS definition:
 
<local-tx-datasource>
  <jndi-name>jdbc_XA/Drools_Rep</jndi-name>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url>
    <user-name>...</user-name>
    <password>...</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
   
      <metadata>
         <type-mapping>Oracle9i</type-mapping>
      </metadata>
 <use-java-context>false</use-java-context>  
</local-tx-datasource>
 
 
... I got back the same exception even with the local-tx Datasource!!
 

17:35:33,430 INFO [STDOUT] PackageName: com.spyd.rules.Scoring

17:35:33,430 INFO [STDOUT] PackageVersion: Scoring

17:35:33,430 INFO [STDOUT] PackageIsLatest: false

----

(I THINK THIS ONE DOES NOT REALLY MATTER)

17:35:43,559 INFO [STDOUT] ERROR 22-02 17:35:43,558 (

Contexts.java:flushAndDestroyContexts:335) could not discover transaction status

----

17:35:43,560 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@ccc4e9

java.lang.Throwable: STACKTRACE

at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)

at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417)

at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)

at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)

at org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager.getConnection(JNDIDatabasePersistenceManager.java:77)

at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.initConnection(DatabasePersistenceManager.java:730)

at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.reestablishConnection(DatabasePersistenceManager.java:806)

at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.executeStmt(DatabasePersistenceManager.java:852)

at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.exists(DatabasePersistenceManager.java:673)

at org.apache.jackrabbit.core.state.SharedItemStateManager.hasNonVirtualItemState(SharedItemStateManager.java:1104)

at org.apache.jackrabbit.core.state.SharedItemStateManager.hasItemState(SharedItemStateManager.java:289)

at org.apache.jackrabbit.core.state.LocalItemStateManager.hasItemState(LocalItemStateManager.java:180)

at org.apache.jackrabbit.core.state.XAItemStateManager.hasItemState(XAItemStateManager.java:252)

at org.apache.jackrabbit.core.state.SessionItemStateManager.hasItemState(SessionItemStateManager.java:199)

at org.apache.jackrabbit.core.ItemManager.itemExists(ItemManager.java:258)

at org.apache.jackrabbit.core.NodeImpl.hasProperty(NodeImpl.java:2708)

at org.drools.repository.PackageItem.getCompiledPackageBytes(PackageItem.java:666)

at org.drools.brms.server.files.FileManagerUtils.loadBinaryPackage(FileManagerUtils.java:146)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)

at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)

 
 
I am quite annoyed with this, cause when I define a direct
JDBC connection to the Oracle Drools Repository everything
works as expected and it is really Fast as well!
 
So... Why do I get this kind of issues once I use the Datasource????
 
Can You advise me any way to (at least) reduce the exception
waiting time?
 
Let me know.
 
Thank again
 
Massi