When using jdbc with TOMCAT. Rename the classes.zip file to classes.jar and make sure it is in the classpath
good luck
>From: Brian Moynihan <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Problem loading oracle jdbc driver in servlet under Tomcat
>Date: Wed, 2 Jan 2002 16:28:39 -0000
>
>Thanks for your reply Bill, however ...
>
>The classpath is set up correctly as the standalone java application can
>access the database.
>
>As regards a valid uid and pwd, this does not apply as the driver is not
>loading, therefore we do not arrive at the database connection step.
>
>We are also using the oracle thin jdbc driver, again it works fine in a
>standalone java application but seems not to like the idea with servlets.
>
>I'm fresh out of ideas, I just can't figure out why it works with a
>standalone app and not a servlet ... it has to be a simple mistake!!
>
>Thanks again for your own ideas so far ...
>
>
>
>-----Original Message-----
>From: Lindsay, William (USPC.PCT.Hopewell)
>[mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, January 02, 2002 3:59 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Problem loading oracle jdbc driver in servlet under Tomcat
>
>
>It could either be
>
>- the CLASSPATH
>- a Firewall between Apache and Oracle
>- Valid UID, PWD
>- Oracle install (We use the ThinClient driver which doesn't require SQL*NET
>(Client Side DLL's or .SO files))
>
>What is the println producing ?
>
>Bill Lindsay
>Retirement Group - VP
>Online Services
>
>-----Original Message-----
>From: Brian Moynihan [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, January 02, 2002 10:37 AM
>To: [EMAIL PROTECTED]
>Subject: Problem loading oracle jdbc driver in servlet under Tomcat
>
>Hi all,
>
>When running servlets under Apache Tomcat 4.0, attempting to load the oracle
>jdbc driver is crashing. The code I am using is as follows:
>
> // Try and connect to the database
> // Load the Oracle JDBC driver
> try {
> DriverManager.registerDriver(new
>oracle.jdbc.driver.OracleDriver());
> }
> catch (SQLException se) {
> System.out.println("Could not load jdbc driver: " + se);
> }
>
>This produces an html error page when the servlet is accessed. This code
>works fine in a standalone java program. Can anyone help define the
>difference in what a standalone program needs and a servlet needs to load
>the jdbc driver.
>
>Any help is appreciated ...
>
>
>**********************************************************************
>Privileged, confidential and/or copyright information may be contained
>in this e-mail. This e-mail is for the use only of the intended
>addressee. If you are not the intended addressee, or the person
>responsible for delivering it to the intended addressee, you may not
>copy, forward, disclose or otherwise use it or any part of it in any
>way whatsoever. To do so is prohibited and may be unlawful.
>
>If you receive this e-mail by mistake please advise the sender
>immediately by using the reply facility in your e-mail software.
>
>Orygen (Ireland) Limited may monitor the content of e-mails sent and
>received via its network for the purposes of ensuring compliance with
>its policies and procedures.
>
>This message is subject to and does not create or vary any contractual
>relationship between Orygen (Ireland) Limited and you.
>**********************************************************************
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
>**********************************************************************
>Privileged, confidential and/or copyright information may be contained
>in this e-mail. This e-mail is for the use only of the intended
>addressee. If you are not the intended addressee, or the person
>responsible for delivering it to the intended addressee, you may not
>copy, forward, disclose or otherwise use it or any part of it in any
>way whatsoever. To do so is prohibited and may be unlawful.
>
>If you receive this e-mail by mistake please advise the sender
>immediately by using the reply facility in your e-mail software.
>
>Orygen (Ireland) Limited may monitor the content of e-mails sent and
>received via its network for the purposes of ensuring compliance with
>its policies and procedures.
>
>This message is subject to and does not create or vary any contractual
>relationship between Orygen (Ireland) Limited and you.
>**********************************************************************
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
