You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Deep Chand <dg...@gmail.com> on 2005/10/04 21:43:16 UTC

No suitable driver error

Hi,
I'm kind of new to struts and/or web technologies. I'm trying to
configure mysql database for my struts appln using Tomcat. I'm getting
the following exception:

Initializing application data source org.apache.struts.action.DATA_SOURCE
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
of class '' for connect URL
'jdbc:mysql://localhost:3306/javatest?autoReconnect=true', cause:
java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:243)
	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:1087)
	at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
	at javax.servlet.GenericServlet.init(GenericServlet.java:256)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3427)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:3628)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
	at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:307)
	at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
	at org.apache.catalina.core.StandardService.start(StandardService.java:497)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
	at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
	at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)

I've put the following in struts-config.xml. Do I need to add
something to server.xml and web.xml too?

<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="javadude" />
<set-property property="user" value="javauser" />
<set-property property="driverClass" value="com.mysql.jdbc.Driver" />
<set-property property="description" value=" Database" />
<set-property property="url"
value="jdbc:mysql://localhost:3306/javatest?autoReconnect=true" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="validationQuery" value="SELECT COUNT(*) FROM author" />
</data-source>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org

Re: No suitable driver error

Posted by Deepak Gupta <de...@gmail.com>.
No, I had the msql driver in the common/lib directory but the problem
got fixed after I changed the data-source type attribute from
"org.apache.commons.dbcp.BasicDataSource" to
"org.apache.struts.util.GenericDataSource".

Any ideas why?

On 10/4/05, Manfred Wolff <wo...@manfred-wolff.de> wrote:
>
> Hi.
>
> Thats nothing to do with struts. You haven't placed your mysql driver in
> the tomcat directory e.g. $CATALINA_BASE/shared/lib. So Struts cannot
> initializing the datasource object.
>
> Manfred
>
> Deep Chand schrieb:
>
> >Hi,
> >I'm kind of new to struts and/or web technologies. I'm trying to
> >configure mysql database for my struts appln using Tomcat. I'm getting
> >the following exception:
> >
> >Initializing application data source org.apache.struts.action.DATA_SOURCE
> >org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
> >of class '' for connect URL
> >'jdbc:mysql://localhost:3306/javatest?autoReconnect=true', cause:
> >java.sql.SQLException: No suitable driver
> >       at java.sql.DriverManager.getDriver(DriverManager.java:243)
> >       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:1087)
> >       at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
> >       at javax.servlet.GenericServlet.init(GenericServlet.java:256)
> >       at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
> >       at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
> >       at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3427)
> >       at org.apache.catalina.core.StandardContext.start(StandardContext.java:3628)
> >       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)
> >       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
> >       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
> >       at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:307)
> >       at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
> >       at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559)
> >       at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
> >       at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
> >       at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
> >       at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
> >       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
> >       at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
> >       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
> >       at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
> >       at org.apache.catalina.core.StandardService.start(StandardService.java:497)
> >       at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
> >       at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
> >       at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
> >       at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
> >       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >       at java.lang.reflect.Method.invoke(Method.java:324)
> >       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
> >
> >I've put the following in struts-config.xml. Do I need to add
> >something to server.xml and web.xml too?
> >
> ><data-source type="org.apache.commons.dbcp.BasicDataSource">
> ><set-property property="password" value="javadude" />
> ><set-property property="user" value="javauser" />
> ><set-property property="driverClass" value="com.mysql.jdbc.Driver" />
> ><set-property property="description" value=" Database" />
> ><set-property property="url"
> >value="jdbc:mysql://localhost:3306/javatest?autoReconnect=true" />
> ><set-property property="readOnly" value="false" />
> ><set-property property="autoCommit" value="false" />
> ><set-property property="validationQuery" value="SELECT COUNT(*) FROM author" />
> ></data-source>
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> >For additional commands, e-mail: user-help@struts.apache.org
> >
> >
> >
>
>
> --
> ===========================================
> Dipl.-Inf. Manfred Wolff
> Software Engineer
> -------------------------------------------
> http://www.manfred-wolff.de
> http://www.struts-it.org
> http://www.unartigen.de
> -------------------------------------------
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org

Re: No suitable driver error

Posted by Manfred Wolff <wo...@manfred-wolff.de>.
Hi.

Thats nothing to do with struts. You haven't placed your mysql driver in
the tomcat directory e.g. $CATALINA_BASE/shared/lib. So Struts cannot
initializing the datasource object.

Manfred

Deep Chand schrieb:

>Hi,
>I'm kind of new to struts and/or web technologies. I'm trying to
>configure mysql database for my struts appln using Tomcat. I'm getting
>the following exception:
>
>Initializing application data source org.apache.struts.action.DATA_SOURCE
>org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
>of class '' for connect URL
>'jdbc:mysql://localhost:3306/javatest?autoReconnect=true', cause:
>java.sql.SQLException: No suitable driver
>	at java.sql.DriverManager.getDriver(DriverManager.java:243)
>	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:1087)
>	at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
>	at javax.servlet.GenericServlet.init(GenericServlet.java:256)
>	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
>	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
>	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3427)
>	at org.apache.catalina.core.StandardContext.start(StandardContext.java:3628)
>	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)
>	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
>	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
>	at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:307)
>	at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
>	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559)
>	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
>	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
>	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
>	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
>	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
>	at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
>	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
>	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
>	at org.apache.catalina.core.StandardService.start(StandardService.java:497)
>	at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
>	at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
>	at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
>	at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
>	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>	at java.lang.reflect.Method.invoke(Method.java:324)
>	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
>
>I've put the following in struts-config.xml. Do I need to add
>something to server.xml and web.xml too?
>
><data-source type="org.apache.commons.dbcp.BasicDataSource">
><set-property property="password" value="javadude" />
><set-property property="user" value="javauser" />
><set-property property="driverClass" value="com.mysql.jdbc.Driver" />
><set-property property="description" value=" Database" />
><set-property property="url"
>value="jdbc:mysql://localhost:3306/javatest?autoReconnect=true" />
><set-property property="readOnly" value="false" />
><set-property property="autoCommit" value="false" />
><set-property property="validationQuery" value="SELECT COUNT(*) FROM author" />
></data-source>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>For additional commands, e-mail: user-help@struts.apache.org
>
>  
>


-- 
===========================================
Dipl.-Inf. Manfred Wolff
Software Engineer
-------------------------------------------
http://www.manfred-wolff.de
http://www.struts-it.org
http://www.unartigen.de
-------------------------------------------


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org