[問題] 請問oracle load balance連線方式
使用JDBC與oracle database做connection
以下是source code:
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver).newInstance();
pass= EncryptionUtils.decrypt(pass);
PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource();
pds.setConnectionFactoryClassName("oracle.jdbc.pool.OracleDataSource");
pds.setURL("jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(ADDRESS_LIST="
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.60)(PORT=1521))"
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.61)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVICE_NAME=test)))");
pds.setUser(user);
pds.setPassword(pass);
pds.setMinPoolSize(10);
pds.setMaxPoolSize(20);
pds.setFastConnectionFailoverEnabled(true);
Connection conn = pds.getConnection();
在取得connection時產生error:
java.lang.NullPointerException
請問是url上有什麼錯誤或是要注意哪些部份嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.248.27.129
※ 文章網址: https://www.ptt.cc/bbs/java/M.1457490321.A.958.html
→
03/10 02:59, , 1F
03/10 02:59, 1F
→
03/10 09:49, , 2F
03/10 09:49, 2F
→
03/10 09:50, , 3F
03/10 09:50, 3F
→
03/10 09:51, , 4F
03/10 09:51, 4F
→
03/10 10:26, , 5F
03/10 10:26, 5F
→
03/10 10:26, , 6F
03/10 10:26, 6F
→
03/10 10:26, , 7F
03/10 10:26, 7F
→
03/10 10:49, , 8F
03/10 10:49, 8F
→
03/10 10:50, , 9F
03/10 10:50, 9F
java 近期熱門文章
PTT數位生活區 即時熱門文章
