Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > JSP Basics
Reload this Page mysql connect problem
|
JSP Basics Beginning-level questions on JSP. More advanced coders should post to Pro JSP.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the JSP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 31st, 2004, 10:02 AM
Registered User
  
Join Date: Jul 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to protozoa
Default mysql connect problem
Hi guys,

I am new to jsp and reading Beginning JSP 2.0.

I am having problems running the example on page 91.

The code goes as follows:


<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jstl/sql_rt" prefix="sql" %>
 <%@ taglib uri="http://java.sun.com/jstl/fmt_rt" prefix="fmt" %>

 <html>
 <head>
 <sql:setDataSource url="jdbc:mysql://localhost/catalog"
                    driver="com.mysql.jdbc.Driver"
            user="root" password="admin" />

<sql:query var="catalog">
SELECT * FROM products
WHERE price>10000
ORDER BY price
</sql:query>

<table>
<tr>
<td>
Item
</td>
<td>
Description
</td>
<td>
Price
</td>
</tr>

<c:forEach varStatus="status" var="row" items="${catalog.rows}">
<tr>
<td>
${row.name}
</td>
<td>
${row.description}
</td>
<td>
<fmt:formatNumber value="${row.price/100}" type="currency" />

</td>

</tr>
</c:forEach>
</table>
</body>
</html>


and I am getting the following error:


org.apache.jasper.JasperException: In <driver>, invalid driver class name: "com.mysql.jdbc.Driver"
 at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:254)
 at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:295)
 at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:241)
 at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
 at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:256)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
 at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
 at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
 at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
 at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2416)
 at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:171)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
 at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
 at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
 at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:223)
 at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:601)
 at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:392)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:565)
 at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:619)
 at java.lang.Thread.run(Thread.java:534)


root cause

javax.servlet.ServletException: In <driver>, invalid driver class name: "com.mysql.jdbc.Driver"
 at org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:533)
 at org.apache.jsp.catalog_jsp._jspService(catalog_jsp .java:127)
 at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:137)
 at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
 at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:210)
 at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:295)
 at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:241)
 at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
 at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:256)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
 at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
 at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
 at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
 at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2416)
 at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:171)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
 at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
 at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
 at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:223)
 at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:601)
 at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:392)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:565)
 at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:619)
 at java.lang.Thread.run(Thread.java:534)


I AM WORKING ON SUSE 9.0,TOMCAT- 4.1.27.

I have put mysql-connector-java-2.0.14-bin.jar in my applications lib directory

thanks

protozoa
 
Old August 9th, 2004, 03:46 AM
Friend of Wrox
  
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default
Error : In <driver>, invalid driver class name: "com.mysql.jdbc.Driver"

Try to locate the driver file and check have you included in classpath.
put a copy of the mysql-connector-java-2.0.14-bin.jar file to TomcatInstallDir\Lib folder.
 
Old August 14th, 2004, 04:56 AM
Registered User
  
Join Date: Jul 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to protozoa
Default
Dear gokul

where can i find the driver file

protozoa
 
Old August 17th, 2004, 12:21 AM
Friend of Wrox
  
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default
you can download from (pls check ver.)

http://dev.mysql.com/downloads/





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem connect to MySql from script sabra MySQL 1 July 25th, 2006 07:23 PM
Trying to connect to Mysql tp194 Classic ASP Databases 4 November 11th, 2004 12:12 AM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.