Glancing at this, I have a couple suggestions.
1) Don't configure your data source in struts-config.xml. This is no longer accepted practice (although that doesn't mean it shouldn't work). Configure your data source in a Struts-independent way (in this case, by doing it in your context XML file -- the one that lives in $TOMCAT_HOME/conf/Catalina/<host> and that is paired with your web app, or by doing it globally in server.xml), and declare the resource-ref in web.xml, just as you would for any non-Struts J2EE app.
2) Your JDBC driver jar (mysql-connector-java-X.X.X-production-bin.jar), and servlet-api.jar, belong in $TOMCAT_HOME/common/lib. Is that where they are?
Hope that helps,
Erik
Philippe PONSONNET wrote:
Hello,
I try to use a datasource in the struts-config.xml
The file :
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="org.apache.commons.dbcp.BasicDataSource"/>
<set-property property="url"
value="jdbc:mysql://localhost:3306/chrono"/>
<set-property property="username"
value="root"/>
<set-property property="password"
value="root"/>
<set-property property="maxActive"
value="10"/>
<set-property property="maxWait"
value="5000"/>
<set-property property="defaultAutoCommit"
value="false"/>
<set-property property="defaultReadOnly"
value="false"/>
<set-property property="validationQuery"
value="SELECT COUNT(*) FROM UTILISATEUR"/>
</data-source>
</data-sources>
And when I start Tomcat, I have this error with tomcat 5, mysql 4.0.18 and struts 1.2.4 :
Buildfile: F:\Technique\WorkSpaceEclipse\StrutsLogin\build.xml
start.tomcat:
[java] 3 nov. 2004 22:44:34 org.apache.coyote.http11.Http11Protocol init
[java] INFO: Initialisation de Coyote HTTP/1.1 sur http-8080
[java] 3 nov. 2004 22:44:34 org.apache.catalina.startup.Catalina load
[java] INFO: Initialization processed in 1063 ms
[java] 3 nov. 2004 22:44:34 org.apache.catalina.core.StandardService start
[java] INFO: Démarrage du service Catalina
[java] 3 nov. 2004 22:44:34 org.apache.catalina.core.StandardEngine start
[java] INFO: Starting Servlet Engine: Apache Tomcat/5.0.28
[java] 3 nov. 2004 22:44:34 org.apache.catalina.core.StandardHost start
[java] INFO: XML validation disabled
[java] 3 nov. 2004 22:44:34 org.apache.catalina.core.StandardHost getDeployer
[java] INFO: Create Host deployer for direct deployment ( non-jmx )
[java] 3 nov. 2004 22:44:34 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\admin.xml
[java] 3 nov. 2004 22:44:34 org.apache.struts.util.PropertyMessageResources <init>
[java] INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
[java] 3 nov. 2004 22:44:34 org.apache.struts.util.PropertyMessageResources <init>
[java] INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
[java] 3 nov. 2004 22:44:35 org.apache.struts.util.PropertyMessageResources <init>
[java] INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true
[java] 3 nov. 2004 22:44:36 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\balancer.xml
[java] 3 nov. 2004 22:44:36 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\jsp-examples.xml
[java] 3 nov. 2004 22:44:36 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\manager.xml
[java] 3 nov. 2004 22:44:36 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\myStrutsProject.xml
[java] 3 nov. 2004 22:44:36 org.apache.catalina.loader.WebappClassLoader validateJarFile
[java] INFO: validateJarFile(E:\Tomcat 5.0\webapps\myStrutsProject\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
[java] 3 nov. 2004 22:44:36 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\ROOT.xml
[java] 3 nov. 2004 22:44:36 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\servlets-examples.xml
[java] 3 nov. 2004 22:44:36 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\strutsLogin.xml
[java] 3 nov. 2004 22:44:37 org.apache.struts.action.ActionServlet initModuleDataSources
[java] GRAVE: Initializing application data source org.apache.struts.action.DATA_SOURCE
[java] org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.apache.commons.dbcp.BasicDataSource' for connect URL 'jdbc:mysql://localhost:3306/chrono'
[java] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:780)
[java] at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:59 8)
[java] at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j ava:778)
[java] at org.apache.struts.action.ActionServlet.init(ActionServlet.java:331)
[java] at javax.servlet.GenericServlet.init(GenericServlet.java:211)
[java] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:10 29)
[java] at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
[java] at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java: 4013)
[java] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4357)
[java] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:8 23)
[java] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
[java] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
[java] at org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer. java:903)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 )
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:324)
[java] at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216)
[java] at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)
[java] at org.apache.commons.digester.Rule.end(Rule.java:276)
[java] at org.apache.commons.digester.Digester.endElement(Digester.java:1058)
[java] at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:7 6)
[java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatc her.dispatch(Unknown Source)
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
[java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
[java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
[java] at org.apache.commons.digester.Digester.parse(Digester.java:1567)
[java] at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.j ava:488)
[java] at org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
[java] at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483 )
[java] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
[java] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
[java] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
[java] at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor t.java:119)
[java] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
[java] at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
[java] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
[java] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
[java] at org.apache.catalina.core.StandardService.start(StandardService.java:480)
[java] at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
[java] at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 )
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:324)
[java] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
[java] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
[java] Caused by: java.sql.SQLException: No suitable driver
[java] at java.sql.DriverManager.getDriver(DriverManager.java:243)
[java] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:773)
[java] ... 50 more
[java] 3 nov. 2004 22:44:37 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\tomcat-docs.xml
[java] 3 nov. 2004 22:44:37 org.apache.catalina.core.StandardHostDeployer install
[java] INFO: Processing Context configuration file URL file:E:\Tomcat 5.0\conf\Catalina\localhost\webdav.xml
[java] 3 nov. 2004 22:44:37 org.apache.coyote.http11.Http11Protocol start
[java] INFO: Démarrage de Coyote HTTP/1.1 sur http-8080
[java] 3 nov. 2004 22:44:37 org.apache.jk.common.ChannelSocket init
[java] INFO: JK2: ajp13 listening on /0.0.0.0:8009
[java] 3 nov. 2004 22:44:37 org.apache.jk.server.JkMain start
[java] INFO: Jk running ID=0 time=0/16 config=E:\Tomcat 5.0\conf\jk2.properties
[java] 3 nov. 2004 22:44:37 org.apache.catalina.startup.Catalina start
[java] INFO: Server startup in 3578 ms
I put the good driver for mysql. I don’t understant !
Thanks for your help.
Philippe
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
