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]
