java - 使用 MSSQL Server 2008 进行 hibernate

Question

我对 hibernate 非常陌生。我使用 hibernate 创建了简单的应用程序，并与 MSSQL server 2008 连接。在执行程序时，我遇到了 Exception.请帮助我。提前致谢。

Exception in thread "main" org.hibernate.HibernateException: Could not parse configuration: hibernate.cfg.xml
    at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1491)
    at org.hibernate.cfg.Configuration.configure(Configuration.java:1425)
    at com.main.StoreData.main(StoreData.java:15)
Caused by: org.dom4j.DocumentException: Connection refused: connect Nested exception: Connection refused: connect
    at org.dom4j.io.SAXReader.read(SAXReader.java:484)
    at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1481)
    ... 2 more

我的conf文件。

employee.hbm.xml

 <?xml version='1.0' encoding='UTF-8'?>  
   <!DOCTYPE hibernate-mapping PUBLIC  
 "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  

 <hibernate-mapping>  
  <class name="com.pojo.Employee" table="employee">  
    <id name="id">  
     <generator class="assigned"></generator>  
    </id>  
    <property name="firstName" column="first_name" type="string"></property>  
    <property name="lastName" column="last_name" type="string"></property>         
  </class>           
 </hibernate-mapping>

hibernate 配置文件

  <?xml version='1.0' encoding='UTF-8'?>  
    <!DOCTYPE hibernate-configuration PUBLIC  
              "-//Hibernate/Hibernate Configuration DTD 3.0//EN"  
              "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">  

    <hibernate-configuration>         
        <session-factory>         
            <property name="hbm2ddl.auto">update</property>  
            <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>  
            <property name="connection.url">jdbc:sqlserver://localhost;databaseName=sampleDB</property>  
            <property name="connection.username">sa</property>  
            <property name="connection.password">sa123</property>  
            <property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>              
        <mapping resource="employee.hbm.xml"/>  
        </session-factory>  
    </hibernate-configuration>

Answer 1

您必须关闭所有打开的标签，例如这个:

<property name="connection.password"sa123</property>

应改为:

<property name="connection.password">sa123</property>