Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > JSP Basics
Reload this Page problem with jdbc
|
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, 02:24 PM
Registered User
  
Join Date: Jul 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to protozoa
Default problem with jdbc
Hi,

I am having problems running code on page 91 of beginning JSP2.0.

My code is :

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

<sql:setDataSource var="datasource"
                     url="jdbc:mysql://localhost:8080/publish"
                    driver="com.mysql.jdbc.Driver"
                   user="root" password="admin" />


           <sql:query var="publish">

            select id,title,price from book
            </sql:query>

            <html>
            <head>
            <body>
            <table>
            <tr>
            <td>id</td>
            <td>title</td>
            <td>price</td>
            <c:forEach items="${publish.row}" var="row">
            <tr>
            <td>
            <c:out value="${row.id}" /></td>
            <td>
            <c:out value="${row.title}" /></td>
            <td>
            <c:out value="${row.price}" /></td>
            </tr>
            </c:forEach>
            </table>
            </body>
            </head>
            </html>

and the error I am getting is :


org.apache.jasper.JasperException: Unable to get connection, DataSource invalid: "null"
        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.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:494)
        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.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: Unable to get connection, DataSource invalid: "null"
        at org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:533)
        at org.apache.jsp.book_jsp._jspService(book_jsp.java: 129)
        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.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:494)
        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.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 tomcat 4.1.27.

please help me guys with this.

protozoa
 
Old August 4th, 2004, 05:07 AM
Registered User
  
Join Date: Aug 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default
check ur datasource name and its connection to your file


PRAVEEN
 
Old August 14th, 2004, 04:49 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
I have put mysql-connector-java-2.0.14-bin.jar in tomcat/common/lib but still I am getting the

 Unable to get connection, DataSource invalid: "No suitable driver".
 
Old December 30th, 2006, 06:08 AM
Registered User
  
Join Date: Dec 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Quote:
quote:Originally posted by praveen
 check ur datasource name and its connection to your file


PRAVEEN
plz use the following for getting connection-

<sql:setDataSource var="datasource"
                     url="jdbc:mysql://localhost:3306/shopping_cart"
                    driver="com.mysql.jdbc.Driver"
                   user="deepak" password="deepak" />

plz put 3306 inplace of 8080 if u are running your application at localhost.






sushil pal





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with JDBC realm aadz5 Apache Tomcat 1 September 2nd, 2009 06:32 PM
problem with JDBC Poman Prashant Java Databases 2 June 20th, 2007 02:06 AM
Connection Problem with Java JDBC dontknowmuch SQL Server 2005 3 April 4th, 2006 01:51 PM
Cannot load JDBC driver class with com.mysql.jdbc. dzis Apache Tomcat 0 January 29th, 2004 11:57 AM
Cannot load JDBC driver class with com.mysql.jdbc. dzis MySQL 0 January 29th, 2004 11:31 AM




Contact Us - Wrox - Privacy Statement - Top

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