JDBC连接字符串的三种配置方式
格式一: Oracle JDBC Thin using a ServiceName:
jdbc:oracle:thin:@//<host>:<port>/<service_name> Example: jdbc:oracle:thin:@//192.168.2.1:1521/XE
此类型适合配置RAC集群的service_name
格式二: Oracle JDBC Thin using an SID:
jdbc:oracle:thin:@<host>:<port>:<SID> Example: jdbc:oracle:thin:@192.168.2.1:1521:X01A
此类型适合配置单实例的ORACLE,一般单实例的ORACLE的SID和service_name会一致
格式三: Oracle JDBC Thin using a TNSName:
jdbc:oracle:thin:@<TNSName> Example: jdbc:oracle:thin:@GL
也有直接配置如下
jdbc:oracle:thin:@(description= (address_list= (address=(host=192.168.60.132)(protocol=tcp)(port=1521)) (address=(host=192.168.60.144)(protocol=tcp)(port=1521)) (load_balance=yes)(failover=yes) ) (connect_data=(service_name= oratest)) )