Looks fine, I would put the DBname as part of the URL, but I think it will work the way you have it..... jdbc:microsoft:sqlserver://vc34:1433/TibcoClearHouse
On Thursday 31 October 2002 02:23 pm, John Mattos wrote: > Ah! Thank you! Good catch. Alright 2 more dumb questions (I'm not above > that) in web xml, the <resource-ref> is... <resource-ref> > <description>DB Connection</description> > <res-ref-name>jdbc/indemand</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > Correct? > > Also, the db url I'm using is... > > jdbc:microsoft:sqlserver://vc34:1433;databaseName=TibcoClearHouse > > and I'm wondering if that's in the right format... > > Thanks > > John > > > shawn <[EMAIL PROTECTED]> wrote:driverClassName is : > com.microsoft.jdbc.sqlserver.SQLServerDriver > > > > driverClassName > com.microsoft.jdbc.sqlserver.SQLServerDriver > > > > > 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.... > > > > > > > > validationQuery > > select top 100 * from Subscriber > > > > > > > > > > url > > > > jdbc:microsoft:sqlserver://vc34:1433;databaseName=TibcoClearHouse>alue> > > > > > > > > password > > tibco_user > > > > > > > > > > maxActive > > 12 > > > > > > > > > > maxWait > > 5000 > > > > > > > > > > driverClassName > > > > C:\Tomcat4.1\common\lib\msbase.jar;C:\Tomcat4.1\common\lib\mssqlserv > >er.jar;C:\Tomcat4.1\common\lib\msutil.jar; > > > > > > > > username > > tibco_user > > > > > > > > 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>
