<beans>
<bean   id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property   name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property   name="url">
<value>
jdbc:mysql://localhost:3306/test
</value>
</property>
<property   name="username">
<value>root</value>
</property>
<property   name="password">
<value>123</value>
</property>
</bean>
<bean   id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property   name="dataSource">
<ref   local="dataSource"   />
</property>
<property   name="mappingResources">
<list>
<value>com/gyf/hibernate/UserBasicinfo.hbm.xml</value>
<value>com/gyf/hibernate/UserStateinfo.hbm.xml</value>
</list>
</property>
<property   name="hibernateProperties">
<props>
<prop   key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop   key="hibernate.show_sql">
true
</prop>
</props>
</property>
</bean>
<bean   id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property   name="sessionFactory">
<ref   local="sessionFactory"   />
</property>
</bean>
<bean   id="userDAO"   class="com.gyf.dao.UserDAO">
<property   name="sessionFactory">
<ref   local="sessionFactory"   />
</property>
</bean>
<bean   id="userDAOProxy"
class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property   name="transactionManager">
<ref   bean="transactionManager"   />
</property>
<property   name="target">
<ref   local="userDAO"   />
</property>
<property   name="transactionAttributes">
<props>
<prop   key="insert*">PROPAGATION_REQUIRED</prop>
<prop   key="get*">
PROPAGATION_REQUIRED,readOnly
</prop>
</props>
</property>
</bean>
</beans>
------------------

 2005-10-18   15:47:30,882     INFO   (ConnectionProviderFactory.java:53)   -   Initializing   connection   provider:   org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
2005-10-18   15:47:30,929   DEBUG   (JDBCExceptionReporter.java:63)   -   SQL   Exception
org.apache.commons.dbcp.SQLNestedException:   Cannot   create   JDBC   driver   of   class   'com.mysql.jdbc.Driver'   for   connect   URL   '
jdbc:mysql://localhost:3306/test
'
at   org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at   org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at   org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:79)
at   org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at   org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
at   org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)
at   org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:758)
at   org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:685)
at   org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:937)
at   org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:334)
at   org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:222)
at   org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:146)
at   org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)
at   org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)
at   org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:891)
at   org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:707)
at   org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:316)
at   org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:222)
at   org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:146)
at   org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)
at   org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)
at   org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:891)
at   org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:707)
at   org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:316)
at   org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:222)
at   org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:146)
at   com.gyf.domain.Hibernate_SpringTest.main(Hibernate_SpringTest.java:62)
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:773)
...   26   more

--转自