Connection pooling for MS Sql server

[Venkat <ve...@convergelabs.com>]

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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Connection pooling for MS Sql server

[Peng Tuck Kwok <pe...@makmal.net>]

> 
> 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?
You can specify the username as another parameter.

<parameter>
<name>username</name>
<value></value>
</parameter>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>