driverClassName is :
com.microsoft.jdbc.sqlserver.SQLServerDriver
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
Not :
C:\Tomcat4.1\common\lib\msbase.jar;C:\Tomcat4.1\common\lib\mssqlserver.jar;C:\Tomcat4.1\common\lib\msutil.jar
these need to be somewhere in your classpath....
Also do not forget the resource-ref in web.xml
On Thursday 31 October 2002 01:49 pm, John Mattos wrote:
> Ah... interesting. No, I can't see them loading, but they're set up at the
> app and global level. Why wouldn't they be loading?
>
> Here's a snippet from server.xml....
> <ResourceParams name="jdbc/indemand">
> <parameter>
> <name>validationQuery</name>
> <value>select top 100 * from Subscriber</value>
> </parameter>
> <parameter>
> <name>url</name>
>
> <value>jdbc:microsoft:sqlserver://vc34:1433;databaseName=TibcoClearHouse</v
>alue> </parameter>
> <parameter>
> <name>password</name>
> <value>tibco_user</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>12</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>5000</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
>
> <value>C:\Tomcat4.1\common\lib\msbase.jar;C:\Tomcat4.1\common\lib\mssqlserv
>er.jar;C:\Tomcat4.1\common\lib\msutil.jar;</value> </parameter>
> <parameter>
> <name>username</name>
> <value>tibco_user</value>
> </parameter>
> </ResourceParams>
> Thoughts?
> [EMAIL PROTECTED] wrote:Where do you setup your datasource? If Global or
> default context, you should be able to see JNDI reference loading when you
> start your tomcat.
>
> Regards,
>
>
> Phillip Qin
>
> Software Developer
> Canadian Shareowner
> 121 Richmond Street W, 7th Floor
> Toronto, ON M5H 2K1
> (416) 595-9600 ext 291
>
>
> -----Original Message-----
> From: John Mattos [mailto:mattosj@;yahoo.com]
> Sent: October 31, 2002 3:33 PM
> To: Tomcat Users List
> Subject: Testing Datasources
>
>
> Is there as easy way to test datasources I set up in server.xml (or in the
> Administrator app)?
>
>
> John L. Mattos
> 302 East 88th Street Apt #5B
> New York, New York 10128-4939
> (M) (917) 202-8450
> (www) http://www.mattos.ws
>
>
> ---------------------------------
> Do you Yahoo!?
> HotJobs - Search new jobs daily now
>
>
>
> ---------------------------------
> Yahoo! - We Remember
> 9-11: A tribute to the more than 3,000 lives lost
--
To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
