Java連oracle庫—(數據庫在改為集群之后URL的相應調整)

muzhouren

Java連oracle庫—(數據庫在改為集群之后URL的相應調整)

出于系統性能以及安全方面考慮﹐我們工廠的其中一系統的數據庫的方式改為集群方式。這樣我們的JAVA系統的連庫方式也要改動﹐因以前沒有使用過集群數據庫﹐也沒有相應的資料﹐系統就暫時采用連接集群中的一台電腦。

經過測試最后才知道﹐原來URL還可以以Oracle別名字串來連接數據庫。
問題最終得以解決。

Oracle 別名
原別名﹕
test =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 122.117.12.50)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = test))
  )

集群方式別名﹕
test =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 112.117.12.50)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 112.117.12.51)(PORT = 1521))
      (LOAD_BALANCE = yes)
      (FAILOVER = yes)
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (INSTANCE_ROLE = PRIMARY)
      (FAILOVER_MODE =
        (TYPE = SESSION)
        (METHOD = BASIC)
      )
      (SERVICE_NAME = test)
    )
  )


Java連庫URL方式變更如下
原方式﹕
jdbc.url=jdbc:oracle:thin:@112.117.12.50:1521:test

改為集群后的方式﹕
jdbc.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 112.117.12.50)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 112.117.12.51)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = yes))(CONNECT_DATA = (SERVER = DEDICATED)(INSTANCE_ROLE = PRIMARY)(FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC))(SERVICE_NAME = test)))





本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/22331/showart_229436.html