[rules-users] Re: Re: Closing connections with BRMS\JackRabbit Repository

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