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

[mmquelo massi]

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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20080222/bdab6f41/attachment.html