Make sure the database resource is in the context you are accessing. Also make sure any classes JAR has .jar extension... .zip extenstion will not work.
e.g. Accessing by http://www.mydomain.com/mydomain <Host name="www.mydomain.com" debug="1" appBase="virtual_hosts" unpackWARs="true"> <Context path="/mydomain" docBase="mydomain" debug="0" reloadable="false" override="true"> <Resource name="jdbc/myConnection" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/myConnection"> <parameter><name>user</name><value>admin</value></parameter> <parameter><name>password</name><value>password</value></parameter> <parameter><name>driverClassName</name><value>oracle.jdbc.driver.OracleDrive r</value></parameter> <parameter> <name>driverName</name> <value>jdbc:oracle:thin:@127.0.0.1:1521:ORCL</value> </parameter> <parameter> <name>maxActive</name> <value>32</value> </parameter> <parameter> <name>maxIdle</name> <value>4</value> </parameter> </ResourceParams> </Context> </Host> -----Original Message----- From: Rob Casteen [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 May 2003 8:17 AM To: Tomcat Users List Subject: Re: Jaybird With Tomcat Part II Of course, and I wouldn't be asking the question without tons of research on my own. I will post the errors below for what I was receiving previously, yet now when I copy the libs into common/lib, the webapps are inaccessible. Here is my previous email: Hey guys, I am hoping I could get some help with this issue. The research I have done online reveals this error with several databases although I have yet to find a actionable answer nor anything firebird specific. I am attempting to connect Firebird to Tomcat based on the MYSQL example in the Tomcat Docs and through the datasource setup in the administration console. I have attempted to include all relevant data to show the activity on my server, including the log, the example code, and the relevant server.xml code. I appreciate all help that you can offer. Rob **************Log java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:529) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 12) at foo.DBTest.init(DBTest.java:23) at org.apache.jsp.test_jsp._jspService(test_jsp.java:49) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 04) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:530) at java.lang.Thread.run(Thread.java:536) ***************Server.xml additions: <ResourceParams name="TestDB"> <parameter> <name>validationQuery</name> <value></value> </parameter> <parameter> <name>maxWait</name> <value>5000</value> </parameter> <parameter> <name>maxActive</name> <value>4</value> </parameter> <parameter> <name>password</name> <value>masterkey</value> </parameter> <parameter> <name>url</name> <value>jdbc:firebirdsql:localhost/3050:C:\\Firebird\\DBcontain\\JAVATEST.FDB </value> </parameter> <parameter> <name>driverClassName</name> <value>org.firebirdsql.jdbc.FBDriver</value> </parameter> <parameter> <name>maxIdle</name> <value>2</value> </parameter> <parameter> <name>username</name> <value>sysdba</value> </parameter> </ResourceParams> </GlobalNamingResources> **********************code *******web-inf <?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd";> <web-app> <description>Firebird Test App</description> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/TestDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </web-app> *******jsp <html> <head> <title>DB Test</title> </head> <body> <% foo.DBTest tst = new foo.DBTest(); tst.init(); %> <h2>Results</h2> Foo <%= tst.getFoo() %><br/> Bar <%= tst.getBar() %> </body> </html> *********************\\\ I have included the dbtest class in the db_test\WEB-INF\classes\foo directory Jacob Kjome wrote: > > First, why not upgrade to Tomcat-4.1.24? Second, have you read about > DBCP? No one is going to spell it out unless you know a little about > what you want or can describe the problem you have. Are you trying to > use Tomcat's DBCP connection pooling but are running into various errors? > If so, post the errors. > > Jake > > At 02:13 PM 5/28/2003 -0700, you wrote: > >> Just to clarify: >> I am using >> Windows 2000 Pro >> Tomcat 4.1.18 >> Firebird Version 1 >> FirebirdSQL-1.0.0 (Jaybird) >> >> I just want Tomcat to connect to a Firebird database on a windows 2k >> system using the Jaybird Type 4 driver from Firebird. Simple as that. > > Just > >> a .jsp to test it and the Tomcat configurations. I have been work >> deligently on this for about a week now - could someone offer some >> insight? As indicated in my previous post, I have followed all >> documentation (what there is), search for answers on the firebird site, > > >> google, and submitted a paid question to google answers. Any help would > > be > >> greatly appreciated. >> >> -- >> Thanks, Robert Casteen >> TEST ADVANTAGE, Inc. Direct Tel: [1] 480-337-3367 1525 West > > 10th > >> Place Main Tel: [1] 480-337-3377 Tempe, Arizona 85281 >> USA Fax: [1] 480 337 3370 >> Email: [EMAIL PROTECTED] Web: www.testadvantage.com >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] > > -- Thanks, Robert Casteen TEST ADVANTAGE, Inc. Direct Tel: [1] 480-337-3367 1525 West 10th Place Main Tel: [1] 480-337-3377 Tempe, Arizona 85281 USA Fax: [1] 480 337 3370 Email: [EMAIL PROTECTED] Web: www.testadvantage.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
