Hibernate3 +Oracle10g 集群,hibernate配置文件中如何编写连接参数

Question

rt:请高手赐教

Answer 1

JDBC连接oracle 集群，配置如下：Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST =(LOAD_BALANCE = yes)(ADDRESS=(PROTO =TCP)(HOST=192.168.1.1)(PORT=1521))(ADDRESS=(PROTO =TCP)(HOST=192.168.1.2)(PORT=1521))(ADDRESS=(PROTO =TCP)(HOST=192.168.1.3)(PORT=1521))(ADDRESS=(PROTO =TCP)(HOST=192.168.1.4)(PORT=1521))(CONNECT_DATA =(SERVICE_NAME = oracleServerName)(failover_mode = (type = select)(method = basic)(retries = 20)(delay = 15)))))";
String user="userName";
String password="userPassword";
conn= DriverManager.getConnection(url,user,password);Hibernate连接Oracle集群，其实是差不多的，请参考如下配置：http://www.itpub.net/thread-639190-1-1.html他里面的配置是正确的

Answer 2

<session-factory>
<property name="hibernate.connection.url">
jdbc:oracle:thin:@192.168.1.50:1521:XE
</property>
<property name="hibernate.connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="hibernate.connection.username">sshm</property>
<property name="hibernate.connection.password">sshm</property>
<property name="hibernate.dialect">
org.hibernate.dialect.OracleDialect
</property>
<property name="hibernate.show_sql">true</property>
<!-- <mapping resource="com/bjsxt/hibernate/User.hbm.xml"/> -->
</session-factory>