Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 12321 invoked from network); 28 May 2003 22:14:25 -0000 Received: from exchange.sun.com (192.18.33.10) by daedalus.apache.org with SMTP; 28 May 2003 22:14:25 -0000 Received: (qmail 26647 invoked by uid 97); 28 May 2003 22:16:42 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org Received: (qmail 26640 invoked from network); 28 May 2003 22:16:42 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by nagoya.betaversion.org with SMTP; 28 May 2003 22:16:42 -0000 Received: (qmail 10965 invoked by uid 500); 28 May 2003 22:14:07 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 10951 invoked from network); 28 May 2003 22:14:07 -0000 Received: from test-adv-18-192-158.interwrx.com (HELO console.testadvantage.com) (168.158.192.18) by daedalus.apache.org with SMTP; 28 May 2003 22:14:07 -0000 Received: from testadvantage.com (10.1.1.1 [10.1.1.1]) by console.testadvantage.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id YF086DWG; Wed, 28 May 2003 15:10:30 -0700 Message-ID: <3ED53574.2090104@testadvantage.com> Date: Wed, 28 May 2003 15:17:24 -0700 From: Rob Casteen Reply-To: robert.casteen@testadvantage.com Organization: Test Advantage User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4a) Gecko/20030401 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tomcat Users List Subject: Re: Jaybird With Tomcat Part II References: <5.2.0.9.2.20030528164822.0263f470@shell.visi.com> In-Reply-To: <5.2.0.9.2.20030528164822.0263f470@shell.visi.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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: validationQuery maxWait 5000 maxActive 4 password masterkey url jdbc:firebirdsql:localhost/3050:C:\\Firebird\\DBcontain\\JAVATEST.FDB driverClassName org.firebirdsql.jdbc.FBDriver maxIdle 2 username sysdba **********************code *******web-inf Firebird Test App DB Connection jdbc/TestDB javax.sql.DataSource Container *******jsp DB Test <% 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: robert.casteen@testadvantage.com Web: www.testadvantage.com >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org >> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org > > -- 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: robert.casteen@testadvantage.com Web: www.testadvantage.com --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org