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



Home Answers Viewqa JDBC how to resolve this JDBC Error?

Have Programming Question? Ask it here!
 
 
 


Ravi kumar
how to resolve this JDBC Error?
0 Answer(s)      a year and 5 months 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
Advertisements
 

 

 

DMCA.com