import java.sql.DatabaseMetaData; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class ConnectionDemo{ public static void main(String args[])throws ClassNotFoundException, SQLException{ Connection con = null; String driverClass = "oracle.jdbc.driver.OracleDriver"; String dburl = "jdbc:oracle:oci:@localhost:1521:orcl"; String dbuser = "scott"; String dbpassword = "tiger"; Class.forName(driverClass); con = DriverManager.getConnection(dburl, dbuser, dbpassword); if(con== null){ System.out.println("Not Connected to DataBase"); return; } DatabaseMetaData dm = con.getMetaData(); String pn = dm.getDatabaseProductName(); String pv = dm.getDatabaseProductVersion(); System.out.println("Connected to : "+pn); System.out.println("Version of DataBase is : "+pv); con.close(); } }
Exception in thread "main" java.sql.SQLException: ORA-12505: TNS:listener does n ot currently know of SID given in connect descriptor at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:672) at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:346) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java: 414) at oracle.jdbc.driver.T2CConnection.(T2CConnection.java:132) at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtensio n.java:78) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at ConnectionDemo.main(ConnectionDemo.java:15)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)