tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David McMinn <>
Subject First JDBC tomcat app
Date Fri, 24 Feb 2006 08:21:27 GMT
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.jsp page. 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 -->
  <Resource name="jdbc/WroxTC5" auth="Container" type="javax.sql.Datasource"
  driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/everycitizen"
  username="everyuser" password="everypass" maxActive="20" maxIdle="30000" maxWait="100"/>
  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. 

  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:
  <%@ page errorPage="errorpg.jsp"
     javax.naming.Context" %>
   <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'>
    <th align='left'>XXXX</th>
   while (
    <tr><td> <%=rset.getInt(0)%></td></tr>
   <% } 
  and the errorpg is:
   <%@ page isErrorPage="true" %>
  <h1> An error has occurred </h1>
  <%= exception.getMessage() %>

  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message