c3p0配置中遇到的一个及其郁闷的问题

s2sh使用的是mysql一直报错，applicationContext是从网上copy来的如下：

 

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xmlns:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="
  http://www.springframework.org/schema/beans
  http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
  http://www.springframework.org/schema/tx
  http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
  http://www.springframework.org/schema/aop
  http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
  http://www.springframework.org/schema/context
  http://www.springframework.org/schema/context/spring-context-3.0.xsd">

 <!-- 扫描注释 -->
 <context:component-scan base-package="cd.xf"></context:component-scan>

 <!-- 数据源 -->
 <bean id="dataSource"
  class="com.mchange.v2.c3p0.ComboPooledDataSource"
  destroy-method="close">
  <property name="driverClass">
   <value>com.mysql.jdbc.Driver</value>
  </property>
  <property name="jdbcUrl">
   <value>
    jdbc:mysql://localhost:3306/memory
   </value>
  </property>
  <property name="user">
   <value>root</value>
  </property>
  <property name="password">
   <value>root</value>
  </property>

  <!--连接池中保留的最小连接数。-->
  <property name="minPoolSize">
   <value>5</value>
  </property>

  <!--连接池中保留的最大连接数。Default: 15 -->
  <property name="maxPoolSize">
   <value>30</value>
  </property>

  <!--初始化时获取的连接数，取值应在minPoolSize与maxPoolSize之间。Default: 3 -->
  <property name="initialPoolSize">
   <value>10</value>
  </property>

  <!--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
  <property name="maxIdleTime">
   <value>60</value>
  </property>

  <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
  <property name="acquireIncrement">
   <value>5</value>
  </property>

  <!--JDBC的标准参数，用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements 
   属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。 
   如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0-->
  <property name="maxStatements">
   <value>0</value>
  </property>

  <!--每60秒检查所有连接池中的空闲连接。Default: 0 -->
  <property name="idleConnectionTestPeriod">
   <value>60</value>
  </property>

  <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 负数表示不限制次数-->
  <property name="acquireRetryAttempts">
   <value>-1</value>
  </property>

  <!--获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效 
   保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试 
   获取连接失败后该数据源将申明已断开并永久关闭。Default: false-->
  <property name="breakAfterAcquireFailure">
   <value>true</value>
  </property>

  <!--因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的 
   时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable 
   等方法来提升连接测试的性能。Default: false -->
  <property name="testConnectionOnCheckout">
   <value>false</value>
  </property>
 </bean>
 <!-- Hibernate SessionFactory -->
 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref local="dataSource" />
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">
     org.hibernate.dialect.MySQLDialect
    </prop>
    <prop key="hibernate.show_sql">true</prop>
    <prop key="hibernate.generate_statistics">false</prop>
    <prop key="hibernate.connection.release_mode">
     auto
    </prop>
    <prop key="hibernate.autoReconnect">true</prop>
   </props>
  </property>
 </bean>

 <!-- 
  <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
  <property name="configLocation"
  value="classpath:hibernate.cfg.xml">
  </property>
  </bean>
 -->

</beans>

 

报错如下：

信息: An exception occurred while acquiring a poolable resource. Will retry.
java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(Unknown Source)
	at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
2010-12-30 21:10:38 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
信息: An exception occurred while acquiring a poolable resource. Will retry.

 

最后发现变成下面的样子就不会报错了，极其郁闷……

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xmlns:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="
  http://www.springframework.org/schema/beans
  http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
  http://www.springframework.org/schema/tx
  http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
  http://www.springframework.org/schema/aop
  http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
  http://www.springframework.org/schema/context
  http://www.springframework.org/schema/context/spring-context-3.0.xsd">

 <!-- 扫描注释 -->
 <context:component-scan base-package="cd.xf"></context:component-scan>

 <!-- 数据源 -->
 <bean id="dataSource"
  class="com.mchange.v2.c3p0.ComboPooledDataSource"
  destroy-method="close">
  <property name="driverClass">
   <value>com.mysql.jdbc.Driver</value>
  </property>
  <property name="jdbcUrl">
   <value>jdbc:mysql://localhost:3306/memory</value>
  </property>
  <property name="user">
   <value>root</value>
  </property>
  <property name="password">
   <value>root</value>
  </property>

  <!--连接池中保留的最小连接数。-->
  <property name="minPoolSize">
   <value>5</value>
  </property>

  <!--连接池中保留的最大连接数。Default: 15 -->
  <property name="maxPoolSize">
   <value>30</value>
  </property>

  <!--初始化时获取的连接数，取值应在minPoolSize与maxPoolSize之间。Default: 3 -->
  <property name="initialPoolSize">
   <value>10</value>
  </property>

  <!--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
  <property name="maxIdleTime">
   <value>60</value>
  </property>

  <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
  <property name="acquireIncrement">
   <value>5</value>
  </property>

  <!--JDBC的标准参数，用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements 
   属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。 
   如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0-->
  <property name="maxStatements">
   <value>0</value>
  </property>

  <!--每60秒检查所有连接池中的空闲连接。Default: 0 -->
  <property name="idleConnectionTestPeriod">
   <value>60</value>
  </property>

  <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 负数表示不限制次数-->
  <property name="acquireRetryAttempts">
   <value>-1</value>
  </property>

  <!--获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效 
   保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试 
   获取连接失败后该数据源将申明已断开并永久关闭。Default: false-->
  <property name="breakAfterAcquireFailure">
   <value>true</value>
  </property>

  <!--因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的 
   时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable 
   等方法来提升连接测试的性能。Default: false -->
  <property name="testConnectionOnCheckout">
   <value>false</value>
  </property>
 </bean>
 <!-- Hibernate SessionFactory -->
 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref local="dataSource" />
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">
     org.hibernate.dialect.MySQLDialect
    </prop>
    <prop key="hibernate.show_sql">true</prop>
    <prop key="hibernate.generate_statistics">false</prop>
    <prop key="hibernate.connection.release_mode">
     auto
    </prop>
    <prop key="hibernate.autoReconnect">true</prop>
   </props>
  </property>
 </bean>

 <!-- 
  <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
  <property name="configLocation"
  value="classpath:hibernate.cfg.xml">
  </property>
  </bean>
 -->

</beans>

 

写好后看到文件有点凌乱，format了一下，结果干了多余的事……哎！