David,
I had a similar problem and solved it by adding the parameters using
resourceparams instead of specifying all the parameters in the resource tag
itself. Like this:
<Resource name="jdbc/galleryDB" auth="Container" type="javax.sql.DataSource
"/>
<ResourceParams name="jdbc/galleryDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp
.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/Gallery?autoReconnect=true</value>
</parameter>
<parameter>
<name>username</name>
<value>GalleryUser</value>
</parameter>
<parameter>
<name>password</name>
<value>hwaying</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
Umesh
On 2/25/06, David McMinn <[EMAIL PROTECTED]> 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"
> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
