Bug 217141

From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.8) Gecko/20061107 Fedora/1.5.0.8-1.fc6 Firefox/1.5.0.8

Description of problem:
Try the example tomcat mysql connection in http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html

It does not work.

the reason is that naming-factory-dbcp.jar that comes with apache-tomcat-5.5.17.tar.gz is not included.

It can be fixed by including naming-factory-dbcp.jar that comes with apache-tomcat-5.5.17 into /var/lib/tomcat5/common/lib

Version-Release number of selected component (if applicable):
tomcat5-5.5.17-6jpp.2.i386

How reproducible:
Always


Steps to Reproduce:
1. Create the mysql database as stated in http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
2. Download the jar files for STL as stated in http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
3. Create the web.xml, context.xml and try a connection to http://localhost:8080/DBTest/test.jsp

It returns the error (copied from catalina.out):
WARNING: Failed to register in JMX: javax.naming.NamingException: Could not crea
te resource factory instance [Root exception is java.lang.ClassNotFoundException
: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory]

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver"
        at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unknown Source)
        at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknown Source)
        at org.apache.jsp.test_jsp._jspx_meth_sql_query_0(test_jsp.java:100)
        at org.apache.jsp.test_jsp._jspService(test_jsp.java:58)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)


Actual Results:
Exception was thrown on the browser

Expected Results:
Results
Foo hello
Bar 12345

Additional info: