大家好,我要远程访问oracle,用的是Oracle8i,classes12.jar加入了工程,代码如下:public void conn() throws ClassNotFoundException, SQLException{
String className = "oracle.jdbc.driver.OracleDriver";
String url ="jdbc:oracle:[email protected]:1521:ORCL";
String uid = "SYSTEM";
String pwd = "MANAGER"; Class.forName(className);
Connection cn = DriverManager.getConnection(url,uid,pwd);
cn.close();
}报错说指向非法的url,没有看出什么错误啊,请大家指导一下啊,谢谢
String className = "oracle.jdbc.driver.OracleDriver";
String url ="jdbc:oracle:[email protected]:1521:ORCL";
String uid = "SYSTEM";
String pwd = "MANAGER"; Class.forName(className);
Connection cn = DriverManager.getConnection(url,uid,pwd);
cn.close();
}报错说指向非法的url,没有看出什么错误啊,请大家指导一下啊,谢谢
Classs.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.87:1521:ORCL","SYSTEM","MANAGER");
这个还有问题吗 LZ44看哇
应该是String url ="jdbc:oracle:thin:@192.168.0.87:1521:ORCL";
不知道你的IP和服务ID是否正确
不知道你的IP和服务ID是否正确
# String URL="jdbc:oracle:thin:@loaclhost:1521:orcl"; //orcl为数据库的SID
# String Username="username"; //用户名
# String Password="password"; //密码
# Class.forName(Driver).newInstance(); //加载数据库驱动
# Connection con=DriverManager.getConnection(URL,Username,Password);
看看你的
String url ="jdbc:oracle:[email protected]:1521:ORCL";
很明显,thin后面少了一个冒号
String className = "oracle.jdbc.driver.OracleDriver";
String url ="jdbc:oracle:oci:@192.168.0.87:1521:ORCL";
String uid = "SYSTEM";
String pwd = "MANAGER"; Class.forName(className);
Connection cn = DriverManager.getConnection(url,uid,pwd);
cn.close();
}
String url ="jdbc:oracle:oci:@192.168.0.87:1521:ORCL";