关于“org.apache.commons.dbcp.SQLNestedException:”

<?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"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
<!-- 配置连接池 -->
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
</property>
<property name="url">
<value>
jdbc:sqlserver://localhost:1433;databaseName=wangjiaxing
</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>123456</value>
</property>
</bean> <!-- 配置sessionFactory -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property> <property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property> <property name="mappingResources">
<list>
<value>com/sxdx/wangjiaxing/vo/Account.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/ArrangeEveryday.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/Asset.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/AssetBorrowRevert.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/AssetType.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Auth.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Card.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/CardType.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/CheckOnWorkAttendance.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/CheckOnWorkAttendanceParam.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/CheckOnWorkAttendanceStudent.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/CheckOnWorkAttendanceSum.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/Classes.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Classroom.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/ClassroomArrangeType.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/CourseArrange.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/CourseType.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/Dd.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/DdType.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Dep.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/Department.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/DepartmentPositionDetails.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/Ecd.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Employee.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/EmployeeRoleDetails.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/Experience.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/FamilyInfo.hbm.xml
</value>
<value>
com/sxdx/wangjiaxing/vo/ForumModel.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/ForumNote.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/ForumUsers.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/Functions.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/JobInfo.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Leave.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/LeaveType.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Levels.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Mail.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Messages.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/MessageType.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/News.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/NoteType.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Profiles.hbm.xml</value>
<value>
com/sxdx/wangjiaxing/vo/RevertNote.hbm.xml
</value>
<value>com/sxdx/wangjiaxing/vo/RoleAuth.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Roles.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/Student.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/TreeNode.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/WebHouse.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/WebType.hbm.xml</value>
<value>com/sxdx/wangjiaxing/vo/WorkLog.hbm.xml</value>
</list>
</property> </bean>
<!--  配置事务管理器 --> <bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean> <!--怎么管理事务  -->
<tx:advice id="txAdvice">
<tx:attributes>
<tx:method name="add*" propagation="REQUIRED" />
<tx:method name="update*" propagation="REQUIRED" />
<tx:method name="del*" propagation="REQUIRED" />
<tx:method name="find*" propagation="REQUIRED" />
<tx:method name="*" read-only="true" />
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="allManagerMethod"
expression="execution (* com.sxdx.wangjiaxing.*.dao.*.*(..))" />
<aop:advisor advice-ref="txAdvice"
pointcut-ref="allManagerMethod" />
</aop:config></beans>
————————————————————以上为applicationContent.xml代码——————————————异常为：08:36:39,703 ERROR JDBCExceptionReporter:72 - Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL '
jdbc:sqlserver://localhost:1433;databaseName=wangjiaxing
'
08:36:39,718 ERROR SchemaUpdate:134 - could not get database metadata求牛人帮忙，复制党莫来

解决方案 »

  1.   

    url错了。是不是端口号或者数据库名错误了
      

  2.   

    Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL '
    jdbc:sqlserver://localhost:1433;databaseName=wangjiaxing'
    改为：com.microsoft.jdbc.sqlserver.SQLServerDriver 
    jdbc:microsoft:sqlserver://localhost:1433;databaseName=wangjiaxing这位同学，如果不知道用哪一个驱动类，或者不会写URL你去搜索啊~  
      

  3.   

    问题解决了，不是驱动和url 的问题
    将<value>
    jdbc:sqlserver://localhost:1433;databaseName=wangjiaxing
    </value>
    改为
    <value>jdbc:sqlserver://localhost:1433;databaseName=wangjiaxing</value>
    就解决问题了
    ，还是感谢各位的回帖，以后会小心的