Am I missing something here? Tomcat keeps on giving me the following exception about my JDBC connection driver not being loaded when I try to establish a datasource connection to a mysql database in struts :
Initializing application data source org.apache.struts.action.DATA_SOURCE java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:529) at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:381) at org.apache.struts.action.ActionServlet.initApplicationDataSources(ActionServlet.java:942) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:457) at javax.servlet.GenericServlet.init(GenericServlet.java:256) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:934) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:821) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3420) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3608) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardHost.start(StandardHost.java:738) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2189) 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(DelegatingMethodAcc essorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) My struts-config.xml looks like this : <struts-config> <!--- other parameters --> <!--- other parameters --> <!-- ========== Data Source Configuration =============================== --> <data-sources> <data-source type="org.apache.commons.dbcp.BasicDataSource"> <set-property property="autoCommit" value="false"/> <set-property property="description" value="MyProject Database Datasource Connection"/> <set-property property="driverClassName" value="com.mysql.jdbc.Driver"/> <set-property property="maxCount" value="4"/> <set-property property="minCount" value="2"/> <set-property property="password" value="myPassword"/> <set-property property="url" value="jdbc:mysql://localhost:3306/Mydatabase"/> <set-property property="user" value="root"/> </data-source> </data-sources> <!--- other parameters --> <!--- other parameters --> </struts-config> Info: This driver , com.mysql.jdbc.Driver, does establish connection to this same database with no exception when I use it in a normal java class. Can someone tell me or atleast point me to where I can find further help/information. I could not find anything at http://jakarta.apache.org/struts/faqs/database.html and also in this list's archives. Thanks, robert