0 Replies Latest reply on May 13, 2003 9:13 AM by andrewdem

DB connection pool problem

andrewdem May 13, 2003 9:13 AM

Hi,
I have detected that number of instances of class "com.mysql.jdbc.Connection"
(referenced from "org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory")
permanently increase, but number of physical connections
to MYSQL DB more less that number of class instances. Why?
And this connections allocates a lot of char[] objects in
"com.mysql.jdbc.StringUtils.toAsciiString()" method.
I use MySql only for MQ Persistence.
The same situation with Oracle connections (oracle.jdbc.driver.OracleConnection).

Can you help me solve this problem?
JBoss 3.2.1 (3.2.0), MySql 4.0



<local-tx-datasource>
<jndi-name>mysqlMQDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/mess_queue</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>user</user-name>
password
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
</local-tx-datasource>

--
Best regards,
Andrey Demchenko.