Hello,
I've testing my app on both glassfishv2 and glassfishv2ur2 with
same results. I've observed that the maxNumConnUsed is always 1.
As I understand, maxNumConnUsed is the number of actual connections
from pool to the database server. Why is it always 1? How can I increase
it!? Please find below the pool configuration options.
config:
allow-non-component-callers="true" associate-with-thread="true" connection-creation-retry-attempts="100" connection-creation-retry-interval-in-seconds="5" connection-leak-reclaim="true" connection-leak-timeout-in-seconds="30" connection-validation-method="table" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" fail-all-connections="false" idle-timeout-in-seconds="25200" is-connection-validation-required="true" is-isolation-level-guaranteed="true" lazy-connection-association="true" lazy-connection-enlistment="true" match-connections="true" max-connection-usage-count="1000" max-pool-size="45" max-wait-time-in-millis="60000" name="csp-pool" non-transactional-connections="true" pool-resize-quantity="10" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="25" transaction-isolation-level="read-committed" validate-atmost-once-period-in-seconds="10" validation-table-name="dual" wrap-jdbc-objects="false"
Kind Regards,
Sanjeev
[Message sent by forum member 'sanjeev_any' (sanjeev_any)]
http://forums.java.net/jive/thread.jspa?messageID=280804