|
遇见问题:
使用hibernate3来连接Oracle10g的集群,连接时不稳定,有时候正常连接,有时候不能正常连接.不知道是不是配置文件有问题,请大家帮我查看一下,谢谢各位了!
开发工具:Eclipse3.1
jdk版本:1.42
hibernate版本:3.0
中间件:tomcat5.0或者weblogic8.1
Oracle版本:10g(2台机器集群)
hibernate.cfg.xml配置文件:
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbcracle: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)))</property>
<property name="connection.username">zxk</property>
<property name="connection.password">zxk</property>
<property name="connection.pool_size">5</property>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>
<property name="show_sql">true</property>
<property name="use_outer_join">true</property>
<property name="statement_cache.size">0</property>
<property name="jdbc.use_scrollable_resultset">true</property>
<property name="cglib.user_reflection_optimizer">false</property>
<property name="jdbc.batch_size">200</property>
<property name="hibernate.connection.release_mode">auto</property>
使用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)
)
)
) |
|