i am trying to Exceute this code:
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(); } }
the above programe is compiled successfully. i have also set the classpath to : ojdbc6.jar file but when i am executing this code i am getting this Error:
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.<init>(PhysicalConnection.java: 414) at oracle.jdbc.driver.T2CConnection.<init>(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)
Ads