Mantis - Resin
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
5890 minor always 04-30-15 11:53 06-03-15 08:59
Reporter: alex Platform:  
Assigned To: ferg OS:  
Priority: normal OS Version:  
Status: closed Product Version: 4.0.43  
Product Build: Resolution: unable to reproduce  
Projection: none      
ETA: none Fixed in Version:  
Summary: 0005890: jdbc connection leak with the following configuration
Description: rep. by Sujit Bhattacharyya
<database jndi-name='jdbc/xxxx'>
         <driver>
           <type>oracle.jdbc.OracleDriver</type>
           <url>jdbc:oracle:thin:@10.0.0.xx:1521:orcl</url>
           <user>xxxx</user>
           <password>xxxx</password>
         </driver>
<close-dangling-connections>true</close-dangling-connections>
         <max-pool-time>20s</max-pool-time>
         <max-connections>5000</max-connections>
        <max-idle-time>5s</max-idle-time>
         <max-active-time>20s</max-active-time>
         <connection-wait-time>10s</connection-wait-time>
         <max-create-connections>500</max-create-connections>
       </database>
Steps To Reproduce:
Additional Information: Smaller JVM Heap make finalize call occur (on UserConnection) which closes the connection and frees oracle process.
Relationships
Attached Files:

Notes
(0006637)
ferg   
06-03-15 08:59   
Applications are responsible for closing their UserConnection.

The close-danging-connection only protects connections opened in a servlet request. If an application opens a connection in a different thread, it must close the connection itself.