File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes Struts+mySQL+JBoss configuration Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Struts+mySQL+JBoss configuration" Watch "Struts+mySQL+JBoss configuration" New topic

Struts+mySQL+JBoss configuration

S.R.K.Vivek Raju
Ranch Hand

Joined: Sep 23, 2004
Posts: 58
Hi all,

I have been trying to configure these three together but with little success.

I am using direct JDBC driver to connect to the database.
I have configured the Jboss xml files in the conf folder to work with mysql.
The mysql server works for a stand alone application in java.

But when running with struts in the DAO it gives the following problem.
My datasources tag in the struts-config is as follows

<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClass" value="com.mysql.jdbc.Driver"/>
<set-property property="url" value="jdbc:mysql://"/>
<set-property property="maxCount" value="5"/>
<set-property property="minCount" value="1"/>
<set-property property="userid" value=""/>
<set-property property="password" value=""/>

It gives an error message saying::

initialising application datasource org.apache.struts.action.DATA_SOURCE
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'jdbc:mysql://'

Please suggest

With Regards
S.R.K.Vivek Raju.
Kevin Judd

Joined: Dec 02, 2004
Posts: 9
This is probably a JBOSS issue. Have you gone through the JBOSS wiki? Go through the check lists here:

Good luck.

Kevin Judd, SCJP
I agree. Here's the link:
subject: Struts+mySQL+JBoss configuration
It's not a secret anymore!