Hi guys!
I have got JBoss 4.2.2, DROOLS BRMS 4.0.4 and Oracle 10g XE as RDBMS.
I defined an Oracle XA Datasource as follows:
<xa-datasource>
<jndi-name>jdbc_XA/Drools_Rep</jndi-name>
<track-connection-by-tx/>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property
name="URL">jdbc:oracle:thin:@//localhost:1521/xe</xa-datasource-property>
<xa-datasource-property name="User">...</xa-datasource-property>
<xa-datasource-property name="Password">...</xa-datasource-property>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- <prepared-statement-cache-size>0</prepared-statement-cache-size> -->
<!-- <blocking-timeout-millis>100</blocking-timeout-millis> -->
<!-- <min-pool-size>2</min-pool-size> -->
<!-- <max-pool-size>30</max-pool-size> -->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
<no-tx-separate-pools/>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
<use-java-context>false</use-java-context>
</xa-datasource>
This repository is managed with JackRabbit.
So i defined the "repository.xml" telling jackrabbit that I want
to persist the rules into the Oracle XA Datasource I previously defined:
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager">
<pparam name="dataSourceLocation" value="jdbc_XA/Drools_Rep"/>
<pparam name="schema" value="oracle"/>
<pparam name="schemaObjectPrefix" value="${wsp.name}_"/>
<pparam name="externalBLOBs" value="false" />
</PersistenceManager>
Each time I re-access the oracle datasource
the following exception is thrown and the execution stops for 4-5 seconds:
12:29:36,170 INFO [CachedConnectionManager] Closing a connection for you.
Please close them yourself:
[EMAIL PROTECTED]
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)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(
SeamInvocationContext.java:56)
at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(
RollbackInterceptor.java:31)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(
SeamInvocationContext.java:68)
at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(
BijectionInterceptor.java:46)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(
SeamInvocationContext.java:68)
at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(
MethodContextInterceptor.java:42)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(
SeamInvocationContext.java:68)
at org.jboss.seam.security.SecurityInterceptor.aroundInvoke(
SecurityInterceptor.java:40)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(
SeamInvocationContext.java:68)
at org.jboss.seam.intercept.RootInterceptor.invoke(
RootInterceptor.java:106)
at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(
JavaBeanInterceptor.java:155)
at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(
JavaBeanInterceptor.java:91)
at
org.drools.brms.server.files.FileManagerUtils_$$_javassist_1.loadBinaryPackage(FileManagerUtils_$$_javassist_1.java)
at org.drools.brms.server.files.PackageDeploymentServlet.doGet(
PackageDeploymentServlet.java:99)
at javax.servlet.http.HttpServlet.service(
HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(
HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:206)
at org.jboss.seam.web.ContextFilter$1.process(
ContextFilter.java:42)
at org.jboss.seam.servlet.ContextualHttpServletRequest.run(
ContextualHttpServletRequest.java:46)
at org.jboss.seam.web.ContextFilter.doFilter(
ContextFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(
JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(
CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(
Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(
JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
As u can see, each time jboss tries to access the DS, it finds
a previous connection opened, so Jboss HAS TO close it by itself!
As far as U know, Is there any way to tell JackRabbit that he has to close
connections ?
Hibernate has something like that so I expect that JackRabbit does the
same...
I already tried to redefine the XA datasource setting some tags related to
the
"connection\connection pools" but it did not work...that's why I am quite
sure
the problem has to be focused on jackrabbit!
Hopefully You can help me.
Thank you anyway.
If u want you can answer me to [EMAIL PROTECTED] as well.
Bye.
Massi
--
View this message in context:
http://www.nabble.com/%28SORRY-GUYS%2C-BUT-seems-that-this-FORUM-HAS-SOME-HTML-PARSING-ISSUES%2C-I-HAVE-GOT-TO-REPOSTT-for-the-3rd-time%29-Does-JackRabbit-Close-Connections--how-to-tell-him-to-close-them...-tp15632874p15632874.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
