tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Fincher" <...@tbird.com>
Subject Re: Jaybird With Tomcat Part II
Date Wed, 28 May 2003 23:43:00 GMT
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: 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
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message