java connect oracle Error ORA-12505

来源:互联网 发布:火箭 模拟软件 编辑:程序博客网 时间:2024/06/06 16:55

Use

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:SXT", "scott", "tiger");

exception

Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


Change to 

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXX)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XX)))", "scott", "tiger");


阅读全文
0 0
原创粉丝点击