i read the
professional java servlet 2.3from wrox press & got stuck in ch.8
my configuration in server.xml:
<Context path="/inventory" docBase="inventory">
<Resource name="jdbc/inventoryDB" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/inventoryDB">
<parameter><name>username</name><value>root</value></parameter>
<parameter><name>password</name><value>******</value></parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>
jdbc:mysql://localhost:3306/inventory</value>
</parameter>
</ResourceParams>
</Context>
but it complaint:
java.sql.SQLException: Cannot create JDBC driver of class 'org.gjt.mm.mysql.Driver' for connect URL 'null'
i tried replacing the
driverName w/
url, but it throws:
java.lang.UnsupportedOperationException
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:125)
what's the difference between 'driverName' & 'url'??
i'm using tomcat4.1.27, mysql 4.0.16 anybody experienced this before?
plz help