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