Windows»·¾³ÏÂjavaÁ¬½ÓLinux»·¾³OracleÊý¾Ý¿â³ö´í

Çë½ÌΪʲô±¾»úWindows»·¾³ÏÂjavaÁ¬½ÓLinux»·¾³ÏÂOracleÊý¾Ý¿â³ö´í£¿£¨×¢£ºÒ»Ï´úÂëÁ¬½Ó±¾»úOracleÊý¾Ý¿âÕý³££¬Çý¶¯°üΪojdbc14.jar£©


ÒÔÏÂΪjavaÁ¬½ÓOracleÊý¾Ý¿â´úÂ룬ÔÚÁ¬½Ó±¾»úOracleÊý¾Ý¿âÕý³£
Connection con = null;
PreparedStatement pst = null;
ResultSet rs = null;

public Connection getConnection() {
  try {
  Class.forName("oracle.jdbc.driver.OracleDriver");
if(con == null || con.isClosed()){
con = DriverManager.getConnection("jdbc:oracle:thin:@10.216.8.212:1521:NXDC","mw_sys","sys");
}
  } catch (Exception e) {
e.printStackTrace();
System.out.print("Á¬½Ó³öÒì³££¡");
  }
return con;
}


Á¬½Ó·þÎñÆ÷OracleÒì³£ÐÅÏ¢£¨·þÎñÆ÷ϵͳ£ºLinux£©
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:
10.216.8.212:1521:NXDC

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:260)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>