newbie question Eclipse/WebApp architecture/Oracle JDBC



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:@jdbc:oracle:thin:@machineName:port:SID,
"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

.



Relevant Pages

  • Problem with SQLLoader Date columns and JDBC access
    ... I'm importing a text file using SQLLoader into an Oracle 9i database. ... But when I try to access this column via JDBC using getTimestampthe driver throws an IllegalArgumentException ) ... I tried the JDBC driver for Oracle9, 10gR1 and 10gR2, no difference. ...
    (comp.databases.oracle.misc)
  • Re: J2EE 1.4 and Oracle database version
    ... and we use Oracle application sever. ... Inevitably we'll also upgrade the app server from 9iAS ... server which uses 10.1.3 Oralce JDBC driver work with the Oracle 9i ... driverand the database version matching. ...
    (comp.databases.oracle.misc)
  • J2EE 1.4 and Oracle database version
    ... and we use Oracle application sever. ... Inevitably we'll also upgrade the app server from 9iAS ... server which uses 10.1.3 Oralce JDBC driver work with the Oracle 9i ... driverand the database version matching. ...
    (comp.databases.oracle.misc)
  • Re: JDBC Driver
    ... into the documentation of this database and will find out the driver. ... >>How can I find out which JDBC driver is available on my system? ... Examples might be Oracle, Sybase, UniData, ...
    (comp.lang.java.programmer)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)