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)