Cannot connect java with oracle

Not open for further replies.


Broken In
Hiplease help as i have problem connecting java with oracle the connectioncode which i m implementing is working in my college but not a my place


Connection con = DriverManager.getConnection("jdbc:Oracle:thin:mad://ip address of college:1521/orcl9i", "name", "password");

as i m entering the loop back address i.e which is not accepting
Last edited:


Staff member
yeah the loopback is for when the server is runnin on same computer
import java.sql.*;
class dbAccess {
  public static void main (String args []) throws SQLException
    Connection con=null;
        try {
              Class.forName ("oracle.jdbc.driver.OracleDriver");
        System.out.println("Driver loaded successfully");
        con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:dsn","scott","tiger");
                                              // @machineName:port:SID,   userid,  password
        System.out.println("connection established");
        Statement db_statement = con.createStatement();
        // Create a simple table, which stores an employee ID and name
        db_statement.executeUpdate("create table employee( empid varchar2(5), firstname varchar2(10), salary number(7))");
        // Insert an employee, so the table contains data
        db_statement.executeUpdate("insert into employee values('1234','JohnDoe',1234567)");

        // Execute query
        ResultSet result = db_statement.executeQuery("select * from employee");

        // While more rows exist, print them
        while ( )
        // Use the getInt method to obtain emp. id
        System.out.println ("ID : " + result.getString("empid"));

        // Use the getString method to obtain emp. name
        System.out.println ("Name : " + result.getString("firstname"));
        System.out.println ("Salary : " + result.getInt("salary"));
        //System.out.println ();
        // Commit changes

        } catch (ClassNotFoundException e) {

Not open for further replies.
Top Bottom