Connection pooling for MS Sql server

[Venkat]

Hi,
I am able to create a connection poll for ms acess and itz working fine.Now
i want to create a connection poll for MsSql server.

For MS access the server.xml looks like this.

<!--1/23/2003 Added By  venkat
           The following block of code add the datasource for
connecting
            MS Acess database using Connector JDBC Driver -->

        <Context path="/test docBase="C:\Test\test"
                debug="5" reloadable="true" crossContext="true">

        <Logger className = "org.apache.catalina.logger.FileLogger"
                prefix="localhost_DBTest_log." suffix=".txt"
                timestamp="true"/>
        <Resource name="jdbc/TestDB"
                auth="Container"
                type="javax.sql.DataSource"/>

        <ResourceParams name = "jdbc/TestDB">
                <parameter>
                  <name>factory</name>

<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                </parameter>

        <!--Maximum number of dBconnections in pool.  Make sure you
configure your
            MS Acess max_connection large enough to handle all you
connections-->

                <parameter>
                  <name>maxActive</name>
                  <value>100</value>
                </parameter>

                <parameter>
                  <name>password</name>
                  <value></value>
                </parameter>

        <!-- Class name for JDBC driver -->

                <parameter>
                  <name>driverClassName</name>
                  <value>sun.jdbc.odbc.JdbcOdbcDriver</value>
                </parameter>

        <!--  The JDBC connection url for connecting to your MS Acess db
                if the connection closes then auto connect -->

                <parameter>
                  <name>url</name>
                  <value>jdbc:odbc:Test</value>
                </parameter>

        </ResourceParams>

        </Context>

My problem is i have to specify username and password for MS Sql server.
Password i can specify Here
           <parameter>
                  <name>password</name>
                  <value></value>
                </parameter>

But Where to specify  the user name?

Thanks in advance.

regards
venkat


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>