connectivity problem - oracle10g XE with Java on Vista Home Premium 64 bit
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("jdbc:odbc:proj","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)
