aspose file tools*
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
Author

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-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
Greenhorn

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:

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

Good luck.


Kevin Judd, SCJP
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Struts+mySQL+JBoss configuration