Cannot create JDBC driver of class '' for connect URL 'jdbc:mysql...

[lasombra]

Hello
I try to get to a local MySQLDB by struts (1.2), Tomcat 5.0.16

I declare the data-source in the struts-config.xml. The DB-Driver is installed in the lib-directory of the webapps

struts-config.xml:

[tt] <data-sources>
<data-source
className=&quot;org.apache.struts.config.DataSourceConfig&quot;
type=&quot;org.apache.commons.dbcp.BasicDataSource&quot;
key=&quot;org.apache.struts.Globals.DATA_SOURCE_KEY&quot;
>
<set-property property=&quot;autoCommit&quot;
value=&quot;false&quot;/>
<set-property property=&quot;description&quot;
value=&quot;Example Data Source Configuration&quot;/>
<set-property property=&quot;driverClass&quot;
value=&quot;org.gjt.mm.mysql.Driver&quot;/>
<set-property property=&quot;maxCount&quot;
value=&quot;4&quot;/>
<set-property property=&quot;minCount&quot;
value=&quot;2&quot;/>
<set-property property=&quot;password&quot;
value=&quot;.....&quot;/>
<set-property property=&quot;url&quot;
value=&quot;jdbc:mysql://localhost/test&quot;/>
<set-property property=&quot;user&quot;
value=&quot;.....&quot;/>
</data-source>
</data-sources>[/tt]

I get an Error-Message in the stdout.log:
[tt]16.01.2004 21:56:07 org.apache.struts.action.ActionServlet initModuleDataSources
SCHWERWIEGEND: Initializing application data source org.apache.struts.Globals.DATA_SOURCE_KEY
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'jdbc:mysql://localhost/test', cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:743)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:576)
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:816)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:389)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3948)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4271)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:316)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:859)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:723)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:473)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1002)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:393)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1133)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:816)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:518)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2343)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)[/tt]

Why does it not find the class? What else do I have to do to get it working?

Thanks for helping

 

[venur]

Hi,

http://jakarta.apache.org/struts/faqs/database.html

Cheers,
Venu

 

[lasombra]

Thanks for your reply. I found the error last night after posting my message.
I have to use the [tt]property=&quot;driverClassName&quot;[/tt] instead of [tt]property=&quot;driverClass&quot;[/tt]