Hi all,
I am using JBoss-4.2.2.GA server on a HP-UX machine. My application uses JAX-WS type
webservices. I am using connection pooling and the connection pool parameters are :
anonymous wrote : BlockingTimeoutMillis = 30000
| BackGroundValidationMinutes = 10
| PreFill = False
| BackGroundValidation = False
| ManagedConnectionFactoryName =
jboss.jca:service=ManagedConnectionFactory,name=testapi
| UseFastFail = False
| Criteria = ByNothing
| ManagedConnectionPool =
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1e44d32
| PoolJndiName = testapi
| NoTxSeparatePools = False
| MinSize = 5
| MaxSize = 50
| Name = JBossManagedConnectionPool
| IdleTimeoutMinutes = 15
|
After load testing my application, I found that :
anonymous wrote : MaxConnectionsInUseCount = 9
| ConnectionCreatedCount = 6590
| ConnectionDestroyedCount = 6585
|
I am eager to know why so many connections were created and destroyed even though my
application uses Connection Pooling. Since connection creation takes time, I would like to
know if there's a better way to handle connections.
The jboss-ds.xml file for the connection pooling is :
anonymous wrote :
|
| <local-tx-datasource>
| <jndi-name>testapi</jndi-name>
|
<connection-url>jdbc:oracle:thin:app/C10@HOSTNAME:1588:TNSNAME</connection-url>
| <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
| <user-name>app</user-name>
| C10
| <min-pool-size>5</min-pool-size>
| <max-pool-size>50</max-pool-size>
|
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name
| >
| </local-tx-datasource>
|
|
|
Thank you.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4239911#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...