Struts+mySQL+JBoss configuration

[S.R.K.Vivek Raju]

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-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClass" value="com.mysql.jdbc.Driver"/>
<set-property property="url" value="jdbc:mysql://127.0.0.1:3306/eeeha_database"/>
<set-property property="maxCount" value="5"/>
<set-property property="minCount" value="1"/>
<set-property property="userid" value=""/>
<set-property property="password" value=""/>
</data-source>
</data-sources>

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://127.0.0.1:3306/test'

Please suggest

With Regards
S.R.K.Vivek Raju.

[Kevin Judd]

This is probably a JBOSS issue. Have you gone through the JBOSS wiki? Go through the check lists here:

http://www.jboss.org/wiki/Wiki.jsp?page=SetUpAMysqlDatasource

Good luck.