If the app still had errors with the .jar file in the webapps own \WEB-INF\lib
then something else is broken (called a test). Since his webapp docBase is
outside the Tomcat directory structure there is merit with having associated
.jar files in that docBase. And in instances where there are multiple Tomcats
running and perhaps multiple versions, then keeping associated files with your
app has merit also.
>>> David Smith <[EMAIL PROTECTED]> 3/28/2008 8:45 AM >>>
Bad suggestion. It should exist in one and only one place. That place
is common/lib for tc 5.0, 5.5 so it's visible to both tomcat's internal
code and the webapp.
--David
Howard Watson wrote:
>Hi. Did you try putting your .jar files in \WEB-INF\lib of you webapp?
>
>
>
>>>>"Tom Henricksen" <[EMAIL PROTECTED]> 3/28/2008 8:08 AM >>>
>>>>
>>>>
>I have an application in Tomcat 5.0.30 that we are trying to get to use
>JDBC through JNDI.
>
>I am trying to follow along with
>akarta-tomcat-5.0.30/webapps/tomcat-docs/jndi-datasource-examples-howto.
>html.
>
>
>
>I have setup the context.xml
>
>
>
> <Context debug="4"
>docBase="C:/Java/eclipse-europa/europa-workspace/bop-med/web"
>path="/bop-med" reloadable="true"
>workDir="work\Catalina\localhost\bop-med">
>
> <Resource name="jdbc/medical"
>
> type="javax.sql.DataSource"
>
> password="password"
>
> driverClassName="com.ibm.db2.jcc.DB2Driver"
>
> maxIdle="2"
>
> maxWait="5000"
>
> validationQuery="select * from sysibm.SYSDUMMY1"
>
> username="user"
>
> url="jdbc:db2://server:50000/db"
>
> maxActive="4"/>
>
> </Context>
>
>
>
>And I have setup the web.xml with
>
>
>
> <resource-ref>
>
> <description>DB Connection</description>
>
> <res-ref-name>jdbc/medical</res-ref-name>
>
> <res-type>javax.sql.DataSource</res-type>
>
> <res-auth>Container</res-auth>
>
> </resource-ref>
>
>
>
>When I call the following code
>
>
>
> initCtx = new InitialContext();
>
>
>
> Context envCtx = (Context) initCtx.lookup("java:comp/env");
>
> DataSource ds = (DataSource) envCtx.lookup("jdbc/medical");
>
>
>
> Connection conn = ds.getConnection();
>
> System.out.println("DB Version : "
>
> +
>conn.getMetaData().getDatabaseMajorVersion());
>
> conn.close();
>
>
>
>
>
>I get the following error
>
>
>
>org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
>of class '' for connect URL 'null'
>
> at
>org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource
>.java:780)
>
> at
>org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.ja
>va:540)
>
> at
>com.advtechgrp.web.servlet.TestConn.processRequest(TestConn.java:37)
>
> at
>com.advtechgrp.web.servlet.TestConn.doGet(TestConn.java:20)
>
> at
>javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
>
> at
>javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>tionFilterChain.java:252)
>
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>erChain.java:173)
>
> at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
>e.java:214)
>
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
>ntext.java:104)
>
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
>20)
>
> at
>org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon
>textValve.java:198)
>
> at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
>e.java:152)
>
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
>ntext.java:104)
>
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
>20)
>
> at
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
>:137)
>
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
>ntext.java:104)
>
> at
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
>:118)
>
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
>ntext.java:102)
>
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
>20)
>
> at
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
>java:109)
>
> at
>org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
>ntext.java:104)
>
> at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
>20)
>
> at
>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
>
> at
>org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
>
> at
>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79
>9)
>
> at
>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
>onnection(Http11Protocol.java:705)
>
> at
>org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57
>7)
>
> at
>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
>.java:684)
>
> at java.lang.Thread.run(Thread.java:534)
>
>Caused by: java.lang.NullPointerException
>
> at
>java.util.StringTokenizer.<init>(StringTokenizer.java:146)
>
> at com.ibm.db2.jcc.DB2Driver.acceptsURL(DB2Driver.java:245)
>
> at java.sql.DriverManager.getDriver(DriverManager.java:232)
>
> at
>org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource
>.java:773)
>
> ... 29 more
>
>
>
>I have the DB2 jars in the common/lib
>
>
>
>Any suggestions?
>
>
>
>Thanks,
>
>
>
>Tom Henricksen
>Consultant
>Advanced Technologies Group, Inc.
>
>* Email: [EMAIL PROTECTED]
>
>
>
>
>Any views or opinions presented in this email are solely those of the author
>and do not necessarily represent those of the company. Employees of Easter
>Seals-Goodwill Northern Rocky Mountain are expressly required not to make
>defamatory statements and not to infringe or authorize any infringement of
>copyright or any other legal right by email communications. Any such
>communication is contrary to company policy and outside the scope of the
>employment of the individual concerned. The company will not accept any
>liability in respect of such communication, and the employee responsible will
>be personally liable for any damages or other liability arising.
>If you are not the intended recipient you are notified that disclosing,
>copying, distributing or taking any action in reliance on the contents of this
>information is strictly prohibited.
>Please report any inappropriate or abusive use of this email system to [EMAIL
>PROTECTED]
>
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Any views or opinions presented in this email are solely those of the author
and do not necessarily represent those of the company. Employees of Easter
Seals-Goodwill Northern Rocky Mountain are expressly required not to make
defamatory statements and not to infringe or authorize any infringement of
copyright or any other legal right by email communications. Any such
communication is contrary to company policy and outside the scope of the
employment of the individual concerned. The company will not accept any
liability in respect of such communication, and the employee responsible will
be personally liable for any damages or other liability arising.
If you are not the intended recipient you are notified that disclosing,
copying, distributing or taking any action in reliance on the contents of this
information is strictly prohibited.
Please report any inappropriate or abusive use of this email system to [EMAIL
PROTECTED]
