import java.sql.*;public class TestJDBC { public static void main(String[] args) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","longtou19871020"); }}
运行时抛出如下异常:
Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521:orcl
这是什么原因啊?请大家帮忙啊,谢谢了!
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","longtou19871020"); }}
运行时抛出如下异常:
Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521:orcl
这是什么原因啊?请大家帮忙啊,谢谢了!
换成
jdbc:oracle:thin:@192.168.0.1:1521:orcl
试试
还有对方的oracle的监听器和服务要启动.
把jdbc:oracle:thin:@127.0.0.1:1521:orcl 改为jdbc:oracle:thin:@localhost:1521:orcl
服务名是不是orcl?
也就是你要连接的ORACLE的数据库的名字不是orcl
请确认
package connection;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class DBConnection {
private final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
private final String DBURL = "jdbc:oracle:thin:@localhost:1521:TESTORA" ;
private final String USER = "SYSTEM" ;
private final String PASSWORD = "MANAGER" ;
private Connection conn = null ;
public DBConnection() {
try {
Class.forName(DBDRIVER) ;
conn = DriverManager.getConnection(DBURL, USER, PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
}
public Connection getConnection() {
return this.conn ;
}
public void closeConnection() {
try {
conn.close() ;
} catch (SQLException e) {
e.printStackTrace();
}
}
}如果和你上述所描述的错误一样,你确定下oracle中这两个服务是 不是开启的OracleOraHome90TNSListener
OracleServiceTESTORA如过开启的还是出现上述错误,请你查看你的数据库端口号是否已被占用。
建议楼主使用本机器的IP地址