permaculture playing cards
The moose likes JDBC and Relational Databases and the fly likes oracle Conenctivity using Thin Drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "oracle Conenctivity using Thin Drivers" Watch "oracle Conenctivity using Thin Drivers" New topic

oracle Conenctivity using Thin Drivers

shams sh

Joined: Feb 19, 2001
Posts: 7
I want to make a Database Connection to Personal oracle 8 using thin driver I am using windows98 and personal oracle. It compiles properly but when I run it i get the following SQL error :
"error My Own Sql error:IO exception:The network Adapter cannot establish the connection ".
I havent made a SID in my oracle. Is a SID important?
oracle 8import java.sql.*;
public class Jdbc1test
static String DB,USER,PASS, Query;
static Connection connection;
static Statement stmt;
static ResultSet rs;
public static void main(String args[])
connection=DriverManager.getConnection ("jdbc racle:thin:@ rcl","scott","tiger");
Query="select * from emp";
while( // while loop
int s1=rs.getInt("empno");
String s2=rs.getString("ename");
System.out.println(s1+ " " + s2);
} // end of try
catch(ClassNotFoundException e)
System.out.println("Error My Own class not found : "+e.getMessage());
catch(SQLException e)
System.out.println("Error My Own sql error: "+e.getMessage());
catch(Exception e)
System.out.println("Error My Own other errors: "+e.getMessage());
}// end of main
}// end of class
I agree. Here's the link:
subject: oracle Conenctivity using Thin Drivers
It's not a secret anymore!