2 Replies Latest reply on Feb 21, 2005 3:31 AM by Robin Roos

    Configuring Connection Pools for Sybase

    Robin Roos Newbie

      Hi All

      I have a datasource mapped to a Sybase database. I've chosen min-pool-size=40, max-pool-size=70, idle-timeout-minutes=0. I understand using 0 means connections in the pool should not timeout.

      I would expect the minumum number of connections (40) to be established when the JBoss server starts, and for these connections to remain open. However what I see is 40 initial logins to the database, followed by regular subsequent logins. (My DBA cannot tell me of logouts). The implication is that connections are becoming closed regularly.

      Any help would be appreciated.

      Thanks, Robin.

      JBoss 3.2.3, Sybase 12.5.3, jConnect 6.0 (JDBC driver for Sybase)

      <local-tx-datasource>
      <jndi-name>jdbc/mylocaltxdatasource</jndi-name>
      <connection-url>jdbc:sybase:Tds:myhostname.com:9200</connection-url>
      <driver-class>com.sybase.jdbc3.jdbc.SybDriver</driver-class>
      <user-name>myusername</user-name>
      mypassword
      <min-pool-size>40</min-pool-size>
      <max-pool-size>70</max-pool-size>
      <idle-timeout-minutes>0</idle-timeout-minutes>
      <connection-property name="DYNAMIC_PREPARE">true</connection-property>
      <connection-property name="SERVER_INITIATED_TRANSACTIONS">true</connection-property>
      <prepared-statement-cache-size>150</prepared-statement-cache-size>
      </local-tx-datasource>