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

遇见问题:

使用hibernate3来连接Oracle10g的集群,连接时不稳定,有时候正常连接,有时候不能正常连接.不知道是不是配置文件有问题,请大家帮我查看一下,谢谢各位了!

开发工具:Eclipse3.1

jdk版本:1.42

hibernate版本:3.0

中间件:tomcat5.0或者weblogic8.1

Oracle版本:10g(2台机器集群)

hibernate.cfg.xml配置文件:

oracle.jdbc.driver.OracleDriver

jdbc

racle:thin:@(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.152.101)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.152.102)(PORT=1521)) (LOAD_BALANCE=yes)(FAILOVER=on))(CONNECT_DATA=(SERVICE_NAME=r590p1)))

zxk

zxk

5

org.hibernate.dialect.OracleDialect

true

true

0

true

false

200

auto

使用PL/SQL连接正常,连接配置参数为:

RAC_DB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.152.101)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.152.102)(PORT = 1521))

(LOAD_BALANCE = yes)

(FAILOVER = on)

)

(CONNECT_DATA =

(SERVICE_NAME = r590p1)

(FAILOVER_MODE = (TYPE = SELECT)

(METHOD = BASIC)

(RETRIES = 20)

(DELAY = 10)

)

)

)