getconnection() --> SQLException

[Vanitha Sugumaran]

Hi,
I have Oracle 8i personnal editon, jdk1.3, window98. I have installed the thin driver.
I tried to getconnection() it gives me error
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
My code

[fontsize ="+0"]
import java.sql.*;
import java.io.*;
class JdbcTest
{
public static void main(String s[]) throws ClassNotFoundException, SQLException
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url = "jdbc : odbc";
try 
{
Connection con =DriverManager.getConnection("jdbc [img]http://www.javaranch.com/ubb/redface.gif[/img]racle:thin:@localhost:1521:ORCL","scott", "tiger");
}
catch(SQLException e)
{
System.out.println("Exception occured");
System.out.println(e);
System.exit(0);
}
String createTableCoffees = "CREATE TABLE COFFEES " +
    "(COF_NAME VARCHAR(32), SUP_ID INTEGER, PRICE FLOAT, " +
    "SALES INTEGER, TOTAL INTEGER)";
Statement stmt = con.createStatement();
}}
[/font]

In the getconnection, we have to pass hostname, port# and sid.
I want to use oracle8i personnal edition, so I am using localhost, 1521 and ORCL. But I don't know what the SID is.
Thanks,
Vanitha.

[This message has been edited by Vanitha Sugumaran (edited October 29, 2001).]

[sanjay yermalkar]

SID is the "host String" you pass to connect to your local oracle database usind SQL*Plus. Basically, It's the name of the database you want to connect to.

[Vanitha Sugumaran]

Thanks for your reply Sanjay. I am totally new to this subject. So kindly guide me through this.
I don't know how to find the SID. I am using oracle8i personnal edition.
When I use sqlplus, I am not entering anything in the hoststring option. It is working fine for me.
I need to connect jdbc to oracle here is where I am having trouble with SID.
Vanitha.

[sanjay yermalkar]

The default database name is the one you provided while installing oracle. You can get it from the file -
<oracle_home>\network\ADMIN\tnsnames.ORA
It should look like this:

RAM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ram.home)
    )
  )

Here, "RAM" is the name of the default database I entered while installing oracle.
I could access my personal oracle by having SID = RAM in my java program.
hope this helps!

[This message has been edited by sanjay yermalkar (edited October 29, 2001).]

[Vanitha Sugumaran]

Thanks a lot sanjay!
Vanitha.