how to resolve this JDBC Error?

Ads
 

how to resolve this JDBC Error?

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)
View Answers

Ads









Related Tutorials/Questions & Answers:
how to resolve this JDBC Error?
errore
Advertisements
Can anybody tell me how to resolve this issue?
How to show all errors in PHP?
error occured in following page ... how to resolve it?
java find the error1
How to validate a form in action class and forward errors to the jsp in struts?
errors
how to display action errors in jsp which is in a form list
my hibernate showing the following exception so how i can resolve it
How do I resolve this Java Class not found exception?
How to resolve this error The filename, directory name, or volume label syntax is incorrect
java find the error4
java find the error7
java find the error3
java find the error2
java find the error5
How to customize property type conversion errors in Spring MVC 3.
how to connect jdbc
Getting Exception on UseDefinedException sample program - Please help me how to resolve
How to download MySQL JDBC driver?
How Jdbc program can be run??
HOW TO RUN JDBC PRORAM ON JDK1.5.0
how to run jdbc program in linux-ubuntu?
how to resolve the problem like when i extract the struts-blank-1.3.10.war it shows java .io.filenotfound
what is ment by jdbc and how to connect with database?
ModuleNotFoundError: No module named 'resolve'
how to set fetch size for jdbc odbc driver
how to run jdbc program in linux-ubuntu?
how to implements jdbc connections using awt
ModuleNotFoundError: No module named 'errors'

Ads