Cannot create JDBC driver of class

经过N小时的努力，终于解决了在tomcat5.0上配置jndi出现Cannot create JDBC driver of class 的问题。数据库为mysql server 5.0。

错误原因为：

 

<parameter>
         <name>driveClassName</name>
         <value>com.mysql.jdbc.Driver</value>
</parameter>

上面的driveClassName写错了，应该为driverClassName

下面给出正确的配置方法，以免下次继续出现这种低级错误。

 

<Server port="8005" shutdown="SHUTDOWN" debug="0">


  <!-- Comment these entries out to disable JMX MBeans support -->
  <!-- You may also configure custom components (e.g. Valves/Realms) by 
       including your own mbean-descriptor file(s), and setting the 
       "descriptors" attribute to point to a ';' seperated list of paths
       (in the ClassLoader sense) of files to add to the default list.
       e.g. descriptors="/com/myfirm/mypackage/mbean-descriptor.xml"
  -->
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
            debug="0"/>
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
            debug="0"/>

  <!-- Global JNDI resources -->
  <GlobalNamingResources>

    <!-- Test entry for demonstration purposes -->
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>

    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users -->
    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved">
    </Resource>
    <ResourceParams name="UserDatabase">
      <parameter>
        <name>factory</name>
        <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
      </parameter>
      <parameter>
        <name>pathname</name>
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>

  </GlobalNamingResources>

  <Service name="Catalina">

    <Connector 
port="80"               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               debug="0" connectionTimeout="20000" 
               disableUploadTimeout="true" />
    <Connector port="8009" 
               enableLookups="false" redirectPort="8443" debug="0"
               protocol="AJP/1.3" />


    <Engine name="Catalina" defaultHost="localhost" debug="0">

      <Logger className="org.apache.catalina.logger.FileLogger"
              prefix="catalina_log." suffix=".txt"
              timestamp="true"/>

      <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
                 debug="0" resourceName="UserDatabase"/>

      <Host name="localhost" debug="0" appBase="webapps"
       unpackWARs="true" autoDeploy="true"
       xmlValidation="false" xmlNamespaceAware="false">
     
    <Context path="/bookshop" docBase="D:workspaceBookShopWebRoot" debug="0" reloadable="true">
        <!-- 配置JNDI数据源 -->
        <!-- 数据源名称，拥有者，类型 -->
        <Resource name="jdbc/bookstore"
            auth="Container"
             type="javax.sql.DataSource"/>
         <!-- 设置数据源参数 name值必须与上相同 -->
        <ResourceParams name="jdbc/bookstore">
         <!-- 设置生成DataSource的factory 类 -->
            <parameter>
             <name>factory</name>
             <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
             </parameter>
                     
         <!-- 设置连接池在活动状态下的数据库连接最大数目,
          即同时连接到数据库的最大数目 -->
             <parameter>
             <name>maxActive</name>
             <value>20</value>
             </parameter>
                         
        <!-- 设置连接池在空闲状态下的数据库连接最大数目 
         即表示在无人使用数据库的状态下保持的连接数目-->
                     
             <parameter>
             <name>maxIdle</name>
             <value>20</value>
             </parameter>
        <!-- 设置数据库连接在空闲状态下的最长时时间,
         超过时间将抛出异常.-->
             <parameter>
             <name>maxWait</name>
             <value>-1</value>
             </parameter>
                     
        <!-- 设置数据库账号 -->
             <parameter>
             <name>username</name>
             <value>root</value>
             </parameter>
        <!-- 设置数据密码 -->
            <parameter>
            <name>password</name>
             <value>******</value>
            </parameter>
        <!-- 设置驱动程序 -->
            <parameter>
             <name>driverClassName</name>
             <value>com.mysql.jdbc.Driver</value>
             </parameter>
                     
        <!-- 设置URL -->
            <parameter>
             <name>url</name>
             <value>jdbc:mysql://localhost:3306/bookstore</value>
             </parameter>
        </ResourceParams>                 
    </Context>
    
      </Host>

    </Engine>

  </Service>

</Server>