oracle jdbc help needed

[Br...@Broadwing.com]

I have just implemented Tomcat 4.0 on a Linux box.  I will be writing some
JSPs that will connect to an Oracle 8.1.7 database on a remote machine.  I
am having trouble connecting to the database with my JSPs.  The error
message I get is:

java.sql.SQLException: No Suitable driver


Can anyone help?
This is my first post, so please do not flame me too bad.

Brad
+++++++++++++++++++++++++++++
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.   If you received
this in error, please contact the sender and destroy any copies of this
document.
+++++++++++++++++++++++++++++

Re: oracle jdbc help needed

[Matt Larson <la...@ncep.noaa.gov>]

does your CLASSPATH include oracle's driver (usually classes12.zip)?

Re: oracle jdbc help needed

[Dmitri Colebatch <di...@bigpond.net.au>]

Have you dont a Class.forName("oracle.jdbc.driver.OracleDriver") or
whatever the name for the driver is?  (I cant remember exactly).  You need
to load the class (there are other ways, but in the simplest case), so
that it can register with the DriverManager.

hth
dim

On Wed, 10 Oct 2001 Brad.Moreland@Broadwing.com wrote:

> I have just implemented Tomcat 4.0 on a Linux box.  I will be writing some
> JSPs that will connect to an Oracle 8.1.7 database on a remote machine.  I
> am having trouble connecting to the database with my JSPs.  The error
> message I get is:
> 
> java.sql.SQLException: No Suitable driver
> 
> 
> Can anyone help?
> This is my first post, so please do not flame me too bad.
> 
> Brad
> +++++++++++++++++++++++++++++
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material.  Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited.   If you received
> this in error, please contact the sender and destroy any copies of this
> document.
> +++++++++++++++++++++++++++++
>