9i jdbc thin drive不支援Load balance

環境是WebSphere 6.0連線10g rac的時候連線出現負載均衡的問題。

原因：

當前WebSphere 6.0的JDBC驅動是9i的, 而且9.2.0.8以前的jdbc thin drive是不支援rac的負載均衡

JDBC Thin does not support redirection to another NET listener

解決方法當然是換成9.2.0.8或者10g的jdbc drive.

就是這樣，簡單記錄一下：

下面是metalink的內容轉載,供參考：
Subject:      Cannot Connect When Using 9.2.0.1 Thin Driver And Loadbalancing
    Doc ID:     Note:371702.1     Type:     PROBLEM
    Last Revision Date:     14-MAY-2008     Status:     PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

JDBC - Version: 9.2.0.1.0
This problem can occur on any platform.

Symptoms

Using 9.2.0.1 JDBC Thin driver to access a RAC cluster with the following connect string :

jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(LOAD_BALANCE=ON)(ADDRESS = (PROTO = TCP)(HOST =host2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521)))(CONNECT_DATA =(SERVER =DEDICATED)(SERVICE_NAME = DB102)))

At connection time,   the following exception is occuring :
java.sql.SQLException: Io exception: Connection refused (DESCRIPTION=(ERR=1153)(VSNNUM=153093632)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTO =TCP)(HOST=hostname)(PORT=1521))'))(ERROR=(ODE=305)(EMFI=1)))).]

Cause

The cause of this problem has been identified and verified in an unpublished Bug 2427185.

It is caused by the fact that the JDBC Thin does not support redirection to another NET listener

Solution

Upgrade the JDBC driver version to the latest version, for example 9.2.0.8.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12361284/viewspace-620293/，如需轉載，請註明出處，否則將追究法律責任。