当前位置: 技术问答>java相关
oracle连接问题
来源: 互联网 发布时间:2015-07-19
本文导语: package netbar; import oracle.jdbc.*; import java.sql.*; public class Test { public static void main(String[] args) { try{ DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); String url="jdbc:oracle:thin:...
package netbar;
import oracle.jdbc.*;
import java.sql.*;
public class Test {
public static void main(String[] args) {
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url="jdbc:oracle:thin:@192.168.0.211:1521:netbardb";
String user="system";
String passwd="manager";
Connection conn =DriverManager.getConnection(url,user,passwd);
System.out.println("succ");
}catch(Exception e){
//System.out.println("无法连接数据库!");
e.printStackTrace();
}
//获得连接
}
}
抱错:
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at netbar.Test.main(Test.java:14)
高手指点!!!!!
import oracle.jdbc.*;
import java.sql.*;
public class Test {
public static void main(String[] args) {
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url="jdbc:oracle:thin:@192.168.0.211:1521:netbardb";
String user="system";
String passwd="manager";
Connection conn =DriverManager.getConnection(url,user,passwd);
System.out.println("succ");
}catch(Exception e){
//System.out.println("无法连接数据库!");
e.printStackTrace();
}
//获得连接
}
}
抱错:
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at netbar.Test.main(Test.java:14)
高手指点!!!!!
|
Sorry,something wrong with my computer ,I can only write in English.
I meet the same problem before,perhaps there a firewall in the computer where the oracle server locate ,and the firewall resist the connection from your program to the server.
I meet the same problem before,perhaps there a firewall in the computer where the oracle server locate ,and the firewall resist the connection from your program to the server.