Mr. Ram
03-06-2006, 01:55 AM
let me know the tag to remove Abandoned connections in JBOSS :
<local-tx-datasource>
<jndi-name>App</jndi-name>
<connection-url>jdbc:mysql://112.03.15.63:3306/AppBase</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>Base</user-name>
<password>tal</password>
<!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
<blocking-timeout-millis>50000</blocking-timeout-millis>
<min-pool-size>10</min-pool-size>
<!-- The maximum connections in a pool/sub-pool -->
<max-pool-size>150</max-pool-size>
<!-- The time before an unused connection is destroyed -->
<!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use -->
<idle-timeout-minutes>10</idle-timeout-minutes>
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>App</jndi-name>
<connection-url>jdbc:mysql://112.03.15.63:3306/AppBase</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>Base</user-name>
<password>tal</password>
<!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
<blocking-timeout-millis>50000</blocking-timeout-millis>
<min-pool-size>10</min-pool-size>
<!-- The maximum connections in a pool/sub-pool -->
<max-pool-size>150</max-pool-size>
<!-- The time before an unused connection is destroyed -->
<!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use -->
<idle-timeout-minutes>10</idle-timeout-minutes>
</local-tx-datasource>