You only need to copy your JDBC driver into common/lib, not all your jars. Keep most everything in WEB-INF/lib except the JDBC driver jar.
Jake
At 03:17 PM 5/28/2003 -0700, you wrote:
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.java:529)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
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:204)
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(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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 <% foo.DBTest tst = new foo.DBTest(); tst.init(); %>
Results
Foo <%= tst.getFoo() %> Bar <%= tst.getBar() %> *********************\\\ 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]
