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
