connectivity problem - oracle10g XE with Java on Vista Home Premium 64 bit

[venkateshcoolmoon]

hi friends

i am trying to connect oracle with Java on vista 64 bit os...i made DSN by using odbcad32.exe situated in %windir%syswom64/odbcad32.exe file and using Driver for oracle...but while executing the foll proog in java i am getting the error as ORA-06413 connection not open ...

plz help me...



Program
import java.sql.*;
import java.net.*;
import java.util.*;
import java.awt.*;
public class oracle
{
public static void main(String asas[])
{
try
{

// JOptionPane.showMessageDialog(null," arg1");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newI nstance();
// JOptionPane.showMessageDialog(null," arg2");
System.out.println("dsdsd");
Connection cn=DriverManager.getConnection("jdbcdbcroj","s ystem","edison");
System.out.println("dsdsd2");
// JOptionPane.showMessageDialog(null," arg3");
Statement st=cn.createStatement();

ResultSet rs=st.executeQuery("Select * from candidate ");

while(rs.next())
{
System.out.println(rs.getString("voterid"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
}



ERROR

dsdsd
java.sql.SQLException: [Microsoft][ODBC driver for Oracle][Oracle]ORA-06413: Connection not open.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknow n Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at oracle.main(oracle.java:16)

[FON]

What is full path of your 'oracle' class ?

Are you running this from 'oracle' class
that is in some directory with a special character in the name or
an extra dot?

[venkateshcoolmoon]

ya..my class name is "oracle" only...

and it does not in the directory that hav any invalid char in name..i hav doubt wether this prob is due to 64 bit OS..

[Tolls]

Why are you using the jdbc/odbc bridge? Oracle has a far better driver than that shaky old thing.

[venkateshcoolmoon]

then can u plz send me sample code of connecting java with oracle on 64 bit OS.....

[Tolls]

Go to Oracle's site and download the driver from there?
Then maybe look at Suns tutorial on JDBC.