parthasara,
You need to connect via jdbc, not odbc. Jdbc drivers are included with Oracle product -- check documentation for thei location. I've attached code below that does a simple connect to an Oracle db and does a simple SQL as an example.
/*
* This sample can be used to check the JDBC installation.
* Just run it and provide the connect information. It will select
* "Hello World" from the database.
*/
// You need to import the java.sql package to use JDBC
import java.sql.*;
// We import java.io to be able to read from the command line
import java.io.*;
class JdbcCheckup_dos
{
public static void main (String args [])
throws SQLException, IOException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Prompt the user for connect information
System.out.println ("Please enter information to test connection to the database"

;
String user;
String password;
String database;
user = readEntry ("user: "

;
int slash_index = user.indexOf ('/');
if (slash_index != -1)
{
password = user.substring (slash_index + 1);
user = user.substring (0, slash_index);
}
else
password = readEntry ("password: "

;
database = readEntry ("database (a TNSNAME entry): "

;
System.out.print ("Connecting to the database..."

;
System.out.flush ();
System.out.println ("Connecting..."

;
Connection conn =
DriverManager.getConnection ("jdbc

racle:thin

" + database,
user, password);
// DriverManager.getConnection ("jdbc

racle

ci8

" + database,
// user, password);
System.out.println ("connected."

;
// Create a statement
Statement stmt = conn.createStatement ();
// Do the SQL "Hello World" thing
ResultSet rset = stmt.executeQuery ("select 'Hello World' from dual"

;
while (rset.next ())
System.out.println (rset.getString (1));
System.out.println ("Your JDBC installation is correct."

;
// close the resultSet
rset.close();
// Close the statement
stmt.close();
// Close the connection
conn.close();
}
// Utility function to read a line from standard input
static String readEntry (String prompt)
{
try
{
StringBuffer buffer = new StringBuffer ();
System.out.print (prompt);
System.out.flush ();
int c = System.in.read ();
while (c != '\n' && c != -1)
{
buffer.append ((char)c);
c = System.in.read ();
}
return buffer.toString ().trim ();
}
catch (IOException e)
{
return "";
}
}
}