连接方案：
public class Conn {
public static String DRIVER="oracle.jdbc.driver.OracleDriver";
public static String URL="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
public static String NAME="system";
public static String PWD="ly";
public static Connection getConn() throws Exception
{
Class.forName(DRIVER);
Connection conn=DriverManager.getConnection(URL, NAME, PWD);
return conn;
}
public static void main(String[] args) throws Exception {
Conn conn=new Conn();
if(conn.getConn()!=null)System.out.println("OK!");
}
}
报错：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
错误原因：给的sid不对
已做过的处理：1.select instance_name from v$instance---------------结果为orcl
2.怀疑监听不稳定，重新配置监听服务
[color=#FF0000]但是仍然报上面错误，郁闷，求助！！！！！！！！！！！[/color]
同情ing.....
看看有没有这里面的情况
http://hi.baidu.com/%D3%C5%D3%CE%D7%D4%B5%C3/blog/item/c615fcf03f4dccaca40f523d.html
up
你能在本机使用客户端连接到数据库吗?
路过........
