On Feb 24, Michael Ni had something to say about RE: Tomcat and Microsoft...
>
>ive copied to my
>C:\Tomcat 4.1\webapps\ROOT\WEB-INF\lib
>C:\Tomcat 4.1\common\lib
>and it still doesn't work.
>
>has anyone actually got their scripts to query from SQL Server 2000 using
>the Microsoft SQL Server 2000 JDBC Driver? seems like sun products never
>work with microsofts
I have it working with the following server.xml entry:
<DefaultContext>
<Resource
name="jdbc/dbname" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/dbname">
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433</value>
</parameter>
<parameter>
<name>username</name>
<value>myusername</value>
</parameter>
<parameter>
<name>password</name>
<value>mypassword</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>100</value>
</parameter>
</ResourceParams>
</DefaultContext>
It's based on the entry in
http://www.autenroad.com/~jpajor/JNDIArticle.htm
--
mattwarden
mattwarden.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
