10 Replies Latest reply on May 31, 2012 2:12 PM by Balaji Ramanathan

    JBoss 5.1 JDBC Connection Pool in Linux

    NIranjan Nanda Apprentice

      Hi All,

       

      We are using Linux for our testing environment and JBoss 5.1 GA as our app server and Oracle 10g as our DB. We are noticing one peculiar behavior. If the application deployed within JBoss is not in use for say 3-4 hours, all the JDBC connections become unusable and further request result in "Connection Closed" exception. Restarting of the JBoss fixes this issue. But its weird. Our oracle-ds.xml looks like below:

       

      <?xml version="1.0" encoding="UTF-8"?>
      
      <datasources>
        <local-tx-datasource>
          <jndi-name>AppDS</jndi-name>
          <use-java-context>false</use-java-context>     
          <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>   
          <connection-url>jdbc:oracle:thin:@xyz.corp:1528:sid</connection-url>
          <user-name>user</user-name>
          <password>password</password>
          <min-pool-size>15</min-pool-size>
          <max-pool-size>20</max-pool-size>
          <idle-timeout-minutes>0</idle-timeout-minutes>
        </local-tx-datasource>
      </datasources>
      

       

      Please help me to understand if we are missing any configuration to handle this issue or some configuration is needed at OS level.

       

      Thanks,

      Niranjan