数据库信息: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可以连接啊
(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可以连接啊
把换行去掉即可。
java换行不方便,当然留着也没问题