tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wang, Hansen" <Hansen_W...@inter-tel.com>
Subject RE: first jdbc tomcat application
Date Thu, 23 Feb 2006 18:44:02 GMT
If you are using tomcat5, do not use ResourceParams. Instead, define
those params as attribute of <Resource>, as this:
 <Resource name="jdbc/WroxTC5" auth="Container"
type="javax.sql.Datasource"
    driverClassName="com.mysql.jdbc.Driver"
	username="xyz" ...
/>
 

-----Original Message-----
From: David McMinn [mailto:d_mcminn@yahoo.com] 
Sent: Thursday, February 23, 2006 9:20 AM
To: users@tomcat.apache.org
Subject: first jdbc tomcat application

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 -->
 <DefaultContext>
  <Resource name="jdbc/WroxTC5" auth="Container"
type="javax.sql.Datasource"/>
  <ResourceParams name="jdbc/WroxTC5">
   <parameter>
    <name>driverClassName</name>
    <value>com.mysql.jdbc.Driver</value>
   </parameter>
   <parameter>
    <name>url</name>
    <value>jdbc:mysql://localhost/everycitizen</value>
   </parameter>
   <parameter>
    <name>username</name>
    <value>everyuser</value>
   </parameter>
   <parameter>
    <name>password</name>
    <value>*****</value>
   </parameter>
   <parameter>
    <name>maxActive</name>
   ; <value>20</value>
   </parameter>
   <parameter>
    <name>maxIdle</name>
    <value>30000</value>
   </parameter>
   <parameter>
    <name>maxWait</name>
    <value>100</value>
   </parameter>
  </ResourceParams>
 </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>
 <body>
  <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>
 </body>
</html>
   
   
  and the errorpg is:
   
  <html>
 <body>
  <%@ page isErrorPage="true" %>
  <h1> An error has occurred </h1>
  <%= exception.getMessage() %>
 </body>
</html>



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message