精简样式的服务名称仅受JDBC Thin驱动程序支持。语法为:
@ //主机名:端口号/服务名
例如:
jdbc:oracle:thin:scott / tiger @ /// myhost:1521 / myservicename
所以我会尝试:
jdbc:oracle:thin:@ /// oracle.hostserver2.mydomain.ca:1522/ABCD
另外,根据Robert Greathouse的回答,你还可以在JDBC URL中指定TNS名称,如下所示:
jdbc:oracle:thin:@(DEscriptION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL=TCP)(HOST=blah.example.com)(PORT=1521)))(CONNECT_DATA=(SID=BLAHSID)(GLOBAL_NAME=BLAHSID.WORLD)(SERVER=DEDICATED)))



