连接到SQL Server 2008 R2与Hibernate

Question

我试图连接到Microsoft SQL 2008服务器通过hibernate.it不是越来越连接，下面是hibernate.cfg.xml的

<!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="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>  
<property name="hibernate.connection.password">1234</property> 
<property name="hibernate.connection.url">jdbc:sqlserver://localhost:1433;databaseName=TEST</property> 
<property name="hibernate.connection.username">username</property> 
<property name="hibernate.default_schema">dbo</property> 
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property> 
<property name="hibernate.show_sql">true</property> 
</session-factory> 
</hibernate-configuration> 

`

而且这里是我用它来尝试建立连接，并做了查询代码：

package com.simpleprogrammer; 

import org.hibernate.HibernateException; 
import org.hibernate.SessionFactory; 
import org.hibernate.cfg.Configuration; 
import org.hibernate.service.ServiceRegistry; 
import org.hibernate.service.ServiceRegistryBuilder; 
public class HibernateUtilities { 
private static SessionFactory sessionFactory; 
private static ServiceRegistry serviceRegistry; 

static { 

try { 
Configuration config = new Configuration().configure().addResource("hibernate.cfg.xml"); 
serviceRegistry = new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry(); 
sessionFactory = config.buildSessionFactory(serviceRegistry); 
}catch(HibernateException he){ 
System.out.println("Problem Caught ! " + he); 
} 
} 

public static SessionFactory getSessionFactory(){ 
return sessionFactory; 
} 
} 

`

主要方法： package com.simpleprogrammer;

import org.hibernate.Session; 

public class Program { 
public static void main(String[] args) { 
System.out.println("Hello World!") ; 
Session session = HibernateUtilities.getSessionFactory().openSession(); 
session.close(); 
} 

} 

Answer 1

jar文件缺少的jboss-交易api_1.2_spec-1.0.0，只需在项目中添加它，它开始工作