hibernate配置文件如何连接sql server 2008数据库

Question

如题所述

Answer 1

<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="hibernate.connection.url">jdbc:sqlserver://localhost:1433;DatabaseName=Test</property>
<property name="hibernate.connection.username">sa</property>
<property name="hibernate.connection.password">123</property>
<property name="c3p0.min_size">5</property>
<property name="c3p0.max_size">20</property>
<property name="c3p0.timeout">2000</property>
<property name="c3p0.max_statements">50</property>
<property name="hibernate.connection.autocommit">false</property>
<property name="hibernate.show_sql">true</property>

<mapping resource="test/test.hbm.xml"/>
</session-factory>
</hibernate-configuration>

其中c3p0连接池部分如果你不需要，可以去掉。如果需要，则需要导入c3p0的jar包

Answer 2

<property name="driverClassName" value="${driverClassName}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<property name="initialSize" value="${initialSize}"/>
<property name="maxActive" value="${maxActive}"/>
<property name="maxIdle" value="${maxIdle}"/>
<property name="minIdle" value="${minIdle}"/>

这些要用的都可以在hibernate下的jdbc.properties文件中找到

Answer 3

去microsoft.com下载较新的jdbc驱动，根据驱动的帮助，配置连接信息