Cannot release inactive sessions in oracle
-------------------------------------------
Key: JBAS-7002
URL:
https://jira.jboss.org/jira/browse/JBAS-7002
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public (Everyone can see)
Affects Versions: JBossAS-4.2.0.GA
Environment: RedHat Enterprise Linux AS
Reporter: sarfaraz khan
Priority: Critical
My application is running in jboss .
when ever i execute a query from my application to database a session is created in oracle
in ACTIVE mode.
Then after some time is it converted to INACTIVE mode
if my application runs more than 3 hours then more than 130 INACTIVE session created in
oracle.
if i close the jboss then there is no INACTIVE session available.
so it is clear that JBOSS is not releasing connections.
my orcle-ds.xml is like this
<datasources>
<local-tx-datasource>
<jndi-name>cseDS</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:oracle:thin:@172.20.6.184:1531:csesrvcm</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>auditdba</user-name>
<password>abcd1234</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<idle-timeout-minutes>3</idle-timeout-minutes>
</local-tx-datasource>
</datasources>
Please suggest me how to realease all inactive sessions in database.
it is an critical issue.my application is in production server .. please help me ???
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira