The datasource setup in the admin console is unstable and usually does not work. Define your contexxt in conf/server.xml manually. See my previous post for details.
Rick ----- Original Message ----- > 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]