I am trying to set up a database connection with
Struts and DBCP (Commons Database Connection Pool) and keep getting this error:
type: Status report
message:
Servlet action is not available
description: The requested resource (Servlet action is not available) is not available.
I've copied commons-dbcp-1.2.1.jar, commons-pool-1.2.jar, and mysql-connector-java-3.1.12-bin.jar into the LIB folders of
Tomcat, restarted the server... Here is my struts-config.xml:
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property
property="driverClassName"
value="com.mysql.jdbc.Driver" />
<set-property
property="url"
value="jdbc:mysql://XXXX.pair.com/XXXX" />
<set-property
property="username"
value="XXXXXXX" />
<set-property
property="password"
value="XXXXXXX" />
<set-property
property="maxActive"
value="10" />
<set-property
property="maxWait"
value="5000" />
<set-property
property="defaultAutoCommit"
value="false" />
<set-property
property="defaultReadOnly"
value="false" />
<set-property
property="validationQuery"
value="SELECT COUNT(*) FROM products" />
</data-source>
</data-sources>
And yes, all the XXX is valid information..
Thank you!!!