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

    DB connection pool problem

    Andrey Demchenko Newbie

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


      Best regards,
      Andrey Demchenko.