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

    DB connection pool problem

    Andrey Demchenko Newbie

      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

      <!-- mysql-ds.xml -->

      <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.