【求助，在线等】Java连oracle报sid错误

[angleretar]

数据库信息：

jjhww =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wrac)
(INSTANCE_NAME = wrac1)
)
)

用户名和密码：

yycms cfpayycms


Java程序：

String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@192.168.200.11:1521:wrac";
String user = "yycms";
String pwd = "cfpayycms";


报错信息：

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
172.16.200.11:1521:wrac


who can tell me why why why????
plsql可以连接啊

[shy315]

jdbc:oracle:thin:@(DESCRIPTION =...) 把换行去掉即可。

[angleretar]

哪儿的换行啊？

[shy315]

(DESCRIPTION = (ADDRESS = (PROTOCOL ... java换行不方便，当然留着也没问题