Hi-

I racked my brains trying to get the sample code to work. Here
is what you need to do.

First, add the following line to the code
on page 484 of JSP 2.0:

   <ResourceParams name ="jdbc/BooksDB">

It goes after the <Resource .../> tag and before
the first <parameter> tag.

2nd be sure to put mysql-connector-java-3.0.8-stable-bin.jar in your classpath or in $JAVA_HOME/jre/lib/ext. The authors fail to remind the readers about this one. So be careful.

I changed driverClassName value in server.xml to:
 com.mysql.jdbc.Driver
Check the readme in the mysql-connector-java
download for the specifics.



Hope This Helps,

Newtonian

Ok, I've copied the Wrox Code from the download and I'm pretty sure there's not much that can go wrong in that simple class and jsp anyway and I still can't get this first example to work.

    <Context path="/Advanced" docBase="Advanced" debug="5" reloadable="true" crossContext="true">

    <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_Advanced_log." suffix=".txt" timestamp="true"/>

    <Resource name="jdbc/BooksDB" auth="Container" type="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/BooksDB">
    <parameter>
     <name>factory</name>
     <value>org.apache.commons.dbcp.BasicDataSourceFact ory</value>
    </parameter>
    <parameter>
     <name>maxActive</name>
     <value>100</value>
    </parameter>
    <parameter>
     <name>maxIdle</name>
     <value>30000</value>
    </parameter>
    <parameter>
     <name>maxWait</name>
     <value>100</value>
    </parameter>
    <parameter>
     <name>username</name>
     <value>bookuser</value>
    </parameter><parameter>
     <name>password</name>
     <value>bookpass</value>
    </parameter>
    <parameter>
     <name>driverClassName</name>
     <value>com.mysql.jdbc.Driver</value>
    </parameter>
    <parameter>
     <name>url</name>
     <value>jdbc:mysql://localhost:3306/books</value>
    </parameter>
        </ResourceParams>
       </Context>
      </Host>

    </Engine>

  </Service>

</Server>


does any of that look wrong?

I'll also note that I did copy the mysql-connector-java-3.0.11-stable-bin.jar to the G:\j2sdk1.4.2_03\jre\lib\ext directory.

AHH!! i found the problem.. i had put the mysql connector along with the pooling, collections and dbcp .jar's into the web-inf/lib directory

http://jakarta.apache.org/tomcat/tom...les-howto.html

that page is extremely helpful... id also like to note that the first example is pretty much the exact same thing thats in the wrox book.. hmm =)