put the necessary jar file for the oracle driver (classes.zip or whatever) into ur WEB-INF\lib directory after changing its extension to .jar -Tim
-----Original Message----- From: Brian Moynihan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:29 AM To: [EMAIL PROTECTED] Subject: Re: Problem loading oracle jdbc driver in servlet under Tomcat 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
