Java Database Connectivity (JDBC)

import java.sql.*;

class JdbcOdbcDriver {


public static String loadJdbcOdbc() {
Connection con = null;
try {

// Load the JDBC-ODBC bridge driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
return ("JDBC-ODBC driver loaded ok.");

} catch (Exception e) {
return ("Exception: "+e.getMessage());
}
}
};



class JDBC_Driver
{
public static void main(String[] args)
{
JdbcOdbcDriver jod= new JdbcOdbcDriver();
System.out.println(jod.loadJdbcOdbc());
}
}


-----------------------------------------------------------------
Loaded the Class in Oracle 10g
c:\> loadjava -user abc/asdf@orcl JdbcOdbcDriver.class


Created the Package

CREATE OR REPLACE PACKAGE ASIF.JDBCODBCDRIVER AS

FUNCTION loadJdbcOdbc
return VARCHAR2
AS
LANGUAGE java
NAME 'JdbcOdbcDriver.loadJdbcOdbc() return java.lang.String';

end;
/

Calling Function

SELECT JDBCODBCDRIVER.LOADJDBCODBC() FROM DUAL;

I got the Exception Message

Exception: sun/jdbc/odbc/JdbcOdbcDriver

But when i run from Command Promt

C:\>java JDBC_Driver
I got the Message

JDBC-ODBC driver loaded ok.

Can anyone tell me, what to do?

shall i load classes12.jar file in Oracle 10g

Edited by: X7C7 on May 20, 2010 12:43 PM

Edited by: X7C7 on May 20, 2010 12:49 PM