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

[Adrian Brock (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBAS-7002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adrian Brock closed JBAS-7002.
------------------------------

    Resolution: Rejected


Use the forums to ask to help.


> 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