You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Paul Wong <Pa...@ACL.com> on 2006/09/22 21:56:21 UTC
Tomcat 5.0 Config with SQL Server 2005
Dear all:
I hope someone can give me some advices here.
Here is some config. info for SQL Server 2000 and I am trying to have
the application to talk to SQL 2005. I have downloaded the JDBC driver,
but not sure what will be the correct configuration/steps:
<Resource name="jdbc/xxxdbProxy" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/xxxdbProxy">
<parameter>
<name>factory</name>
<value>com.xxx.jaas.DataSourceProxyFactory</value>
</parameter>
</ResourceParams>
<Resource name="jdbc/xxxdb" auth="Application"
type="com.microsoft.sqlserver.jdbc.SQLServerXADataSource" />
<ResourceParams name="jdbc/xxxdb">
<parameter>
<name>factory</name>
<value>com.microsoft.sqlserver.jdbc.SQLServerDataSourceObjectFactory</va
lue>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
</parameter>
....
Thanks a lot for your kind help.
Yours Truly,
Paul
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org