I am developing an application using servlet program. In which, I need to connect with Database (Oracle)
I have tried with JDBC Type1 driver(JDBC-ODBC Bridge driver) to connect my servlet with Database with the help of DSN.
But it throws the following SQL exception at runtime: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 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(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) ...
The same DSN is tested with local java program(having main method) whic is working fine.
I would like to know,whether JDBC-ODBC brigde driver is supported with Oracle database through Servlet programming?
If yes the how?
If not,then I think we have to use other types of driver(2,3,4).Right?