
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)
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.