Hello, I am new to Eclipse and am writing a .jsp that reads an oracle
(9) database.
Within the Eclipse J2ee perspective, I have the following (this is
somewhat abridged)
MyProject
MyProject -> Java Resources : src
MyProject -> Java Resources : src -> my.contrived.package.name
MyProject -> Java Resources : src -> my.contrived.package.name ->
Helper.java
MyProject -> Java Resources : src -> Libraries
MyProject -> Java Resources : src -> Libraries -> Apache Tomcat v5.5
MyProject -> Java Resources : src -> Libraries -> EAR libraries
MyProject -> Java Resources : src -> Libraries -> JRE System Library
(jre 1.4.2_16)
MyProject -> Java Resources : src -> Libraries -> Web App Libraries
MyProject -> Java Resources : src -> Libraries -> Web App Libraries ->
classes12.jar (oracle jdbc driver)
MyProject -> build
MyProject -> build -> classes
MyProject -> build -> classes -> my
MyProject -> build -> classes -> my -> contrived
MyProject -> build -> classes -> my -> contrived -> package
MyProject -> build -> classes -> my -> contrived -> package -> name
MyProject -> build -> classes -> my -> contrived -> package -> name ->
Helper.class
MyProject -> WebContent
MyProject -> WebContent -> mytest
MyProject -> WebContent -> mytest -> index.jsp
MyProject -> WebContent -> WEB-INF
MyProject -> WebContent -> WEB-INF -> lib
MyProject -> WebContent -> WEB-INF -> lib -> classes12.jar (oracle
jdbc driver)
I use the following code in the index.jsp to connect to my oracle
database..
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection Conn =
DriverManager.getConnection("jdbc:oracle:thin:@[EMAIL PROTECTED]
"userid", "password");
and this works ...
I want to do the actual database grunt work in class I have in the
Helper.java file. When I do the
Class.forName("oracle.jdbc.driver.OracleDriver");
in the Helper.java file, I keep getting ClassNotFoundException ....
Evidently, the Helper.java file cannot "see" the classes12.jar
file ????? Why and/or why not ???
Thanks
Mike
