[jboss-jira] [JBoss JIRA] Created: (JBAS-7002) Cannot release inactive sessions in oracle

[sarfaraz khan (JIRA)]

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