Mar 04, 2006 21:31:00
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!!!
, Ranch Hand
Mar 05, 2006 22:55:00
My advice to anyone looking to set up your connection pooling through struts is simply this: Don't do it.
Since it is the Application server that is ultimately responsible for maintaining a connection pool, it makes sense to do it through your Application Server and to follow the specific instructions provided by the Application Server to set it up. Just look at the Tomcat documentation, and you will find an example for setting up a MYSQl Data Source.
Wink, wink, nudge, nudge, say no more ...
All times above are in ranch (not your local) time.
The current ranch time is
Dec 12, 2017 07:19:53.