netBeans Oracle connection through ODBC JDBC bridge

[jimi4you]

Hi every one,

I am having problem connecting ORACLE through JSP. I am using netBeans IDE, though I am able to connect to ORACLE using ODBC-JDBC bridge drivers and can browse Oracle tables, but when I try it through JSP page it stucks some where.
Note- before I do this I make sure that the Oracle instance is running and Tomacat has started at localhost:8081

Here is little code for JDBC api. ("cprofile" is my Oracle Instance)

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"
String url = "jdbcdbc:cprofile";
Connection con = DriverManager.getConnection(url, "scott", "tiger"

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT ENAME,JOB FROM EMP"

 

[venur]

Hi,

If you are connecting to ORACLE from Tomcat, you need to have classes12.jar in your Web Application lib folder. Just make sure you have this jar file, which loads the dirver for oracle.

Cheers,
-Venu

 

[sedj]

Once using the classes12.zip packages, your connection String will look a little different eg :

jdbcracle:thin@serverHost:1521atabaseSID