Java spring hibernate应用程序：无法打开连接

Question

我正在用mssql数据库开发一个java Spring Hibernate应用程序。但是我无法与mssql数据库建立连接。

[请求处理失败；嵌套异常为org.springframework.transaction.CanNotCreateTransactionException：无法打开事务的Hibernate会话；嵌套异常为org.Hibernate.exception.GenericJDBcException：无法打开连接]

下面给出了我的applicationcontext.xml：

<?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:tx="http://www.springframework.org/schema/tx"
    xmlns:mvc="http://www.springframework.org/schema/mvc" 
    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/context
    http://www.springframework.org/schema/context/spring-context-3.0.xsd
    http://www.springframework.org/schema/mvc
    http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">

    <!-- Enable autowire -->
    <context:annotation-config></context:annotation-config>
    <context:component-scan base-package="com.adapt.smileboard"></context:component-scan>

    <mvc:annotation-driven></mvc:annotation-driven> 

    <mvc:resources mapping="/resources/**" location="/resources/"></mvc:resources>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" ></property>
        <property name="url" value="jdbc:sqlserver://localhost:1433;databaseName=test;" ></property>
        <property name="username" value="user" ></property>
        <property name="password" value="pwd" ></property>
    </bean>

    <!-- Session Factory Declaration -->
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource" ></property>
        <property name="packagesToScan" value="com.adapt.smileboard.entity" ></property>
        <property name="hibernateProperties">
            <props>
                <!-- SQL Dialect -->
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

                <!-- Your required Database Name -->
                <prop key="hibernate.default_schema">smileBoardDB</prop>

                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.enable_lazy_load_no_trans">true</prop>
                <prop key="format_sql">true</prop>
                <prop key="use_sql_comments">true</prop>
            </props>
        </property>
    </bean>

    <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>

    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" ></property>
    </bean>
</beans>`

Answer 1

您使用的是Microsoft SQL Server驱动程序和MySQL方言。

对于Microsoft SQL Server使用org.hibernate.dialt.sqlserverdiociate。

参考这个。