jdbc:oracle:thin:@<TNSName>
示例:
使用SERVICE_NAME :
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.4.1)(PORT=1528)))(CONNECT_DATA=(SERVICE_NAME=name1)))
使用SID:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.4.1)(PORT=1528)))(CONNECT_DATA=(SID=name2)))
使用域名 和 service_name
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=www.baidu.com)(PORT = 1528)))(CONNECT_DATA=(SERVICE_NAME= name3)(SERVER = DEDICATED)))