JDBC and Oracle Host

[Sanjay Jadhav]

Hi..
I try to connect jdbc to oracle 8 but it gives me error on hostname.
can any one tell me how should i get hostname for oralce.

[Rene Larsen]

Hi
Where is Oracle located (e.g. IP-adr)?
What is the URL to Oracle (e.g. 'jdbc:oracle:thin:@<HOST>:<PORT>:<SID>')?
/Rene
[ June 13, 2002: Message edited by: Rene Larsen ]

[Sanjay Jadhav]

hi..
I write prg which just connect to oracle,where as you said (('jdbc racle:thin:@<HOST>:<PORT>:<SID> ) i have port and sid found but not host is this mean oracle server name or path were i installed oracle.
clarify the same.

[Rene Larsen]

Hi
Did you install oracle the same PC as you are trying to connect from - if yes then HOST = '127.0.0.1' or 'localhost' - if no then the host is the IP-adr or PC name where you have installed oracle.
/Rene

[Sanjay Jadhav]

hi.
I tried your solution but it raised the SQLException saying Connection refused : connect.
I need the host parameter for oracle which i used.

[Rene Larsen]

Hi
Try to change: 'jdbc:oracle:thin:@....'
To: 'jdbc:oracle:oci8:@....'
Oracle 8 (ver. 8.0.x) can not use the thin driver - it is java - but oci8 is a native driver. But Oracle 8i (ver. 8.1.x) can use them both.
/Rene
[ June 22, 2002: Message edited by: Rene Larsen ]
[ June 22, 2002: Message edited by: Rene Larsen ]

[Sanjay Jadhav]

Hi..
My code..

/*
This sample shows how to list all the names from the EMP table  It uses the JDBC THIN driver.  See the same program in the  oci7 or oci8 samples directories to see how to use the other drivers.
*/
// You need to import the java.sql package to use JDBC
import java.sql.*;
class Employee {
  
  public static void main (String args[]) throws SQLException, ClassNotFoundException {
  try {
    // Load the Oracle JDBC driver
 Class.forName("oracle.jdbc.driver.OracleDriver");
  // Connect to the database
  // You must put a database name after the @ sign in the connection URL.
    // You can use either the fully specified SQL*net syntax or a short cut
    // syntax as <host>:<port>:<sid>.  The example uses the short cut syntax.
    //Connection conn = DriverManager.getConnection("jdbc :-o	 racle :-o	 ci8:@127.0.0.1","scott","tiger");
    Connection conn = DriverManager.getConnection("jdbc :-o	 racle :-o	 ci7:@127.0.0.1","scott","tiger");
    // Create a Statement
    //Statement stmt = conn.createStatement();
    // Select the ENAME column from the EMP table
    //ResultSet rset = stmt.executeQuery("select * from emp");
    // Iterate through the result and print the employee names
    //while (rset.next ()) 
    //  System.out.println (rset.getString (1));
    
   }catch(SQLException e) { 
   System.out.println(e);
   }
  
  }
}
 

but give an exception in main unsatisfiedlinkerror: make_c_state
i don't understand it. The probs only with host port and sid or correct.

[Rene Larsen]

Hi
What is the version of your oracle?
If it is a 8.0.x and up, then you can not use the 'oci7' driver.
You always have to provide HOST (127.0.0.1) PORT and SID.
/Rene

[Rene Larsen]

Hi
Try read this post: http://p2p.wrox.com/archive/java_databases/2001-02/11.asp
/Rene

[Mark Spritzler]

Hi
Mark
sorry it just struck me as funny that each and every post in this thread started with Hi.

[Sanjay Jadhav]

Hi
As I got that Oracle8 client is not properly installed, so i removed that one and installed Oracle8i.
Give me the exact systext or small prg to evalute the jdbc connection.

[Rene Larsen]

import java.sql.*;
class JdbcTest {
   public static void main (String args []) throws SQLException {
      // Load Oracle driver
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      // Connect to the local database
      Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl",
                                                    "system", "manager");
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select 'Hello World' from dual");
      // Print the name out
      while(rs.next())
         System.out.println(rs.getString(1));
      // close the resultSet
      rs.close();
      // Close the statement
      stmt.close();
      // Close the connection
      conn.close();
   }
}

Remember to change HOST - PORT - SID
/Rene
[ June 27, 2002: Message edited by: Rene Larsen ]

[Sanjay Jadhav]

Hi..
what is default host-port-sid for Oracle8i,As i look into tnsname.ora file it give me host as sanjay,port as 1521 and sid as oracle8i which as choose when i enter the global database name.

[Rene Larsen]

HOST - PC where you installed Oracle 8i - e.g. 127.0.0.1 (for this PC if it is the same as you installed the database) or the IP-adr of the PC where it is installed.
PORT - default is 1521, but you can change it when you make a Network Configuration.
SID - when you created the Database you typed two names, the first was the Database name, the second was the SID name.
/Rene