aspose file tools*
The moose likes JDBC and the fly likes Oracle Connectivity with thin drivers !! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Connectivity with thin drivers !!" Watch "Oracle Connectivity with thin drivers !!" New topic
Author

Oracle Connectivity with thin drivers !!

shamshs
Greenhorn

Joined: Feb 16, 2001
Posts: 3
I want to make a Database Connection to Personal oracle 8 using thin driver classes12.zip 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.*;
import java.io.*;
public class Jdbc1test
{
static String DB,USER,PASS, Query;
static Connection connection;
static Statement stmt;
static ResultSet rs;
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
connection=DriverManager.getConnection ("jdbc racle:thin:@192.168.0.1:1521 rcl","scott","tiger");
stmt=connection.createStatement();
Query="select * from emp";
rs=stmt.executeQuery(Query);
while(rs.next()) // while loop
{
int s1=rs.getInt("empno");
String s2=rs.getString("ename");
System.out.println(s1+ " " + s2);
}
rs.close();
connection.close();
} // 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
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
"shamshs",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please choose a new name which meets the requirements.
Thanks.

Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
 
 
subject: Oracle Connectivity with thin drivers !!