本人刚学java,建立java object的时候,用了一下代码连远程数据库,成功连上:
public class oracleService {
Connection conn=null;
public Connection getconn(){
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.101:1521:crmhn","scott","tiger");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
}
但我在新建的web object,同样用
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.101:1521:crmhn","scott","tiger");
却连不上,报 Io 异常: The Network Adapter could not establish the connection错误。项目已经导入class12.jar,ojbdc6.jar,ojdbc5.jar,ojdbc14.jar,但仍然连接不上。目标数据库为10g。
最后我把IP改成我电脑本地的数据库
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:crmhn","scott","tiger");
也可以连接上,请问我问题出在哪?
------解决方案--------------------
我一般都用这种方式,
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:crmhn","scott","tiger");
或者localhost 换乘127.0.0.1
------解决方案--------------------
我的意思是JDK
------解决方案--------------------
我也不清楚,能力不够,还是等高手来回复吧~抱歉啊,帮不了你