在使用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="hibernate.bytecode.use_reflection_optimizer">false</property> <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> <property name="hibernate.connection.password"></property> <property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost:1433/TTA;INSTANCE=SQL2000</property> <property name="hibernate.connection.username">sa</property> <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property> <property name="hibernate.current_session_context_class">thread</property> </session-factory></hibernate-configuration>
如果不指定服務名,將"hibernate.connection.url"行改為:
<property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost/TTA</property>