JSP-Oracle Connectivity, using Eclipse WTP for development [message #183171] |
Fri, 24 November 2006 10:31 |
Eclipse User |
|
|
|
Originally posted by: dolpheen.gmail.com
Dear All,
My database is Oracle9i Release 9.0.1.1.1 - Production.
I am using Eclipse WTP R-1.5.2-200610261841-win32.
I have coded as follows to connect to Oracle from a JSP.
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.31.121:1521:ithelp", "user","pass");
stmt = con.createStatement();
rs = stmt.executeQuery(mquery);
I also tried the following things:
Added ojdbc14.jar as an external jar to java build path of project.
Copied the same file to
WebContent\WEB-INF\lib
Used import statement as
<%@ page import="oracle.jdbc.driver.*"%>
But still I am getting
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
What may be the problem?
Please help.
-Sameer
|
|
|
Powered by
FUDForum. Page generated in 0.02531 seconds