tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amila Suriarachchi" <amilasuriarach...@gmail.com>
Subject Re: first jdbc tomcat application
Date Mon, 27 Feb 2006 04:46:36 GMT
On 2/26/06, David McMinn <d_mcminn@yahoo.com> wrote:
>
> I had not added an error-page tag to the web.xml - The default behavior
> would be  a stack trace which would be fine w/ me - In my jsp, I have @ page
> errorPage="errorpg.jsp"......
>
>   I don't get a stack trace but I get a page w/ this message...."Cannot
> create JDBC driver of class '' for connect URL 'null' ".
>
>
>   Here is my original posting.
>
>   I'm stepping through the example Professional Apache Tomcat 5 book by
> Wrox in Chapter 14 - I have set up the mysql database and confirmed it works
> and set up the tomcat server and confirmed that I can see my index.jsppage. When I try
to go to
> http://localhost:8070/jsp-examples/wroxjdbc/JDBCTest.jsp
>   I get a standard The page cannot be displayed page.
>
>   I've included all my steps below. Anyone that can help is most
> appreciated. Thanks in advance.....Dave
>
>   Steps I have done
>
>   1) Created a DB called everycitizen and a table called test with a
> column called pk. Created user everyuser w/ a password and granted Select
> privileges to that user.
>   2) Copied the mysql-connector-java-3.1.12-bin.jar into
> $CATALINA_HOME/common/lib.
>   3)Added the following to the $CATALINA_HOME/conf/server.xml just before
> the </Host tag>. Password is blotted out.
>
> <!-- added by DM 2/22/2006 -->
> <DefaultContext>
>   <Resource name="jdbc/WroxTC5" auth="Container" type="
> javax.sql.Datasource"
>   driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost/everycitizen"


 what is the port u run the mysql server?
the default is 3306

"jdbc:mysql://localhost:3306/test?autoReconnect=true"

  username="everyuser" password="everypass" maxActive="20" maxIdle="30000"
> maxWait="100"/>
> </DefaultContext>
>   4) Added the following to the
> $CATALINA_HOME/webapps/jsp-examples/WEB-INF web.xml file at the bottom
> just before the </web-app> entry after the last env-entry.
>
>     <resource-ref>
>       <res-ref-name>jdbc/WroxTC5</res-ref-name>
>       <res-type>javax.sql.DataSource</res-type>
>       <res-auth>Container</res-auth>
>     </resource-ref>
>
>   5) Added the JDBCTest.jsp file and the errorpg.jsp file to
> $CATALINA_HOME/webapps/jsp-examples/wroxjdbc directory. I created the
> wroxjdbc folder. The JDBC Test is:
>
>   <html>
> <head>
>   <%@ page errorPage="errorpg.jsp"
>    import="java.sql.*,
>      javax.sql.*,
>      java.io.*,
>      javax.naming.InitialContext,
>      javax.naming.Context" %>
> </head>
>    <h1>JDBC JNDI Resource Test</h1>
>   <%
>   InitialContext initCtx = new InitialContext();
>   DataSource ds =
> (DataSource)initCtx.lookup("java:comp/env/jdbc/WroxTC5");
>   Connection conn = ds.getConnection();
>   Statement stmt = conn.createStatement();
>   ResultSet rset = stmt.executeQuery("select * from test;");
>   %>
>   <table width = '600' border='1'>
>    <tr>
>     <th align='left'>XXXX</th>
>    </tr>
>    <%
>    while (rset.next())
>    {
>    %>
>     <tr><td> <%=rset.getInt(0)%></td></tr>
>    <% }
>    rset.close();
>    stmt.close();
>    conn.close();
>    initCtx.close();
>    %>
>   </table>
> </html>
>
>
>   and the errorpg is:
>
>   <html>
>    <%@ page isErrorPage="true" %>
>   <h1> An error has occurred </h1>
>   <%= exception.getMessage() %>
> </html>
>
>
> Glen Mazza <grm7790@verizon.net> wrote:
>   David McMinn escribió:
> >
> > Unfortunately the logs don't say anything - I just get a page not found.
> If I take that out (and all subsequent jsp) it works fine. So right up to
> that point the jsp page renders fine - When I include that one more line, it
> blows up. I'm still looking but if someone knows please chime in. Thanks,
> >
>
> OK, then, perhaps the error page to forward to *that you have defined in
> the webapp's web.xml file) doesn't exist. TC is trying to forward to
> that error page, can't find it, and hence returns the page not found
> error.
>
> Glen
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message