SHH整合数据库访问异常！！求助于各位啊！！！

Question

哎，这个问题花费了太多时间了，希望各位能帮忙看看！！org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection
org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:550)
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:377)
org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
$Proxy7.sel(Unknown Source)
com.shopcar.action.LoginAction.execute(LoginAction.java:28)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)...............................................
.......................................................root cause org.hibernate.exception.JDBCConnectionException: Cannot open connection
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29).............
.............
root cause java.sql.SQLException: No suitable driver
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119).............................................
希望大家帮忙看看很是无语啊

Answer 1

是spring配置文件出问题了吧，包都导了没。。

Answer 2

No suitable driver没有合适的驱动打开数据库连接
把驱动加上 如果有更换可用的

Answer 3

Driver类没加载，（可能性不大）
或， Driver类加载了，但是URL格式写得不对（很可能）贴含数据库配置的代码吧

Answer 4

<bean name="factory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
   <property name="configLocation">
<value>classpath:hibernate.cfg.xml</value>
</property>
  </bean>
  <!-- 事务管理器 -->
<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory"  ref="factory"></property>
</bean>
<!-- 配置事务的传播特性 -->
<tx:advice id="txAdvice" transaction-manager="txManager">
<tx:attributes>
<tx:method name="add*" propagation="REQUIRED"/>
<tx:method name="del*" propagation="REQUIRED"/>
<tx:method name="modify*" propagation="REQUIRED"/>
<tx:method name="*" read-only="true"/>
</tx:attributes>
</tx:advice>
<!-- 指明那些类的那些方法需要代理 -->
<aop:config>
<aop:pointcut id="doMethod" expression="execution(* com.shopcar1.bo.*.*(..))"/>
<aop:advisor pointcut-ref="doMethod" advice-ref="txAdvice"/>
</aop:config>
  <bean id="productdao" class="com.shopcar1.dao.ProductsDao">
   <property name="sessionFactory" ref="factory"></property>
  </bean>
  <bean id="productbo" class="com.shopcar1.bo.ProductsBo">
   <property name="dao" ref="productdao"></property>
  </bean>
  <bean name="action" class="com.shopcar1.action.LoginAction">
   <property name="bo" ref="productbo"></property>
  </bean>
</beans>