Struts datasource 配置問題

剛開始我的設定檔是這樣寫的::

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd">

<struts-config>
  <data-sources>
   <data-source key="DBsource" type="org.apache.commons.dbcp.BasicDataSource">
    <set-property property="driverName" value="org.gjt.mm.mysql.Driver"></set-property>
    <set-property property="url" value="jdbc:mysql://localhost:3306/mydb"></set-property>
    <set-property property="username" value="mzy"></set-property>
    <set-property property="password" value="root"></set-property>
   </data-source>
  </data-sources>
  <form-beans>
   <form-bean name="LogonForm" type="nn.fm.form.LogonForm"></form-bean> 

啟動tomcat5.時出錯:::

嚴重: Initializing application data source DBsource
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'jdbc:mysql://localhost:3306/mydb'
 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
 at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:959)
 at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:808)
 at org.apache.struts.action.ActionServlet.init(ActionServlet.java:335)
 at javax.servlet.GenericServlet.init(GenericServlet.java:211)
 at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
 at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
 at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3951)
 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4225)
 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
 at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
 at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
 at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
 at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
 at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
 at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
 at org.apache.catalina.core.StandardService.start(StandardService.java:450)
 at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
 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:585)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: java.sql.SQLException: No suitable driver
 at java.sql.DriverManager.getDriver(DriverManager.java:243)
 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
 ... 30 more

找了半天不知道是什麼原因,經過不斷的摸索,哈哈,找到了答案:

原來是property="driverName" 這裡的屬性名稱是不變的啊,一定要是  driverClassName哦!!

以後要小心這樣的小問題啦!