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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > -- > =========================================== > Dipl.-Inf. Manfred Wolff > Software Engineer > ------------------------------------------- > http://www.manfred-wolff.de > http://www.struts-it.org > http://www.unartigen.de > ------------------------------------------- > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
