1 Reply Latest reply on Jan 10, 2005 10:28 AM by hariv

    pool of connections

    walter

      Hello, in the version 3.0.x of jboss, I could setting pool of connections to the data base, but version 3.2.5 in where she setting herself. In version 3.0.6 he was thus:

      <depends optional-attribute-name="ManagedConnectionPool">
      <!--embedded mbean-->


      0
      50
      5000
      15
      <!--criteria indicates if Subject (from security domain) or app supplied
      parameters (such as from getConnection(user, pw)) are used to distinguish
      connections in the pool. Choices are
      ByContainerAndApplication (use both),
      ByContainer (use Subject),
      ByApplication (use app supplied params only),
      ByNothing (all connections are equivalent, usually if adapter supports
      reauthentication)-->
      ByContainer


      but in the version 3.2.5 as it is formed?

      thank's

        • 1. Re: pool of connections
          hariv

          In 3.2.5 the format for specifying the datasource is different. The following is a xml file for connecting to MS SQL Server 2000 with a pool for 100 connections. This file should be under your server deploy directory.


          <local-tx-datasource>
          <jndi-name>varsdb</jndi-name>
          <connection-url></connection-url>
          <driver-class>com.inet.tds.TdsDriver</driver-class>
          <user-name>tnadmin</user-name>
          tnadmin
          <blocking-timeout-millis>3000</blocking-timeout-millis>
          <max-pool-size>100</max-pool-size>
          <idle-timeout-minutes>1</idle-timeout-minutes>
          </local-tx-datasource>