Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC how to resolve this JDBC Error?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Ravi kumar
how to resolve this JDBC Error?
0 Answer(s)      2 years ago
Posted in : JDBC


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)

Advertisement
View Answers

Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com