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
RE: Testing Datasources
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
RE: Testing Datasources
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 namevalidationQuery/name valueselect top 100 * from Subscriber/value /parameter parameter nameurl/name valuejdbc:microsoft:sqlserver://vc34:1433;databaseName=TibcoClearHouse/value /parameter parameter namepassword/name valuetibco_user/value /parameter parameter namemaxActive/name value12/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valueC:\Tomcat4.1\common\lib\msbase.jar;C:\Tomcat4.1\common\lib\mssqlserver.jar;C:\Tomcat4.1\common\lib\msutil.jar;/value /parameter parameter nameusername/name valuetibco_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
Re: Testing Datasources
Ah! Thank you! Good catch. Alright 2 more dumb questions (I'm not above that) in web xml, the resource-ref is... resource-ref descriptionDB Connection/description res-ref-namejdbc/indemand/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/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=TibcoClearHousealue 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: For additional commands, e-mail: - Do you Yahoo!? HotJobs - Search new jobs daily now
Re: Testing Datasources
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 descriptionDB Connection/description res-ref-namejdbc/indemand/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/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=TibcoClearHousealue 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