----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Jon,
Thanks, yes, the problem seems to be with the null checking. If I prevent
the servlet from either closing the connection at the very end or remove the
NULL checking up-front, it works fine. I will check out Jason Hunter's book
to see why this is the case.
Thanks for the response,
Anthony
----- Original Message -----
From: "Jon Stevens" <[EMAIL PROTECTED]>
To: "Java Apache Users" <[EMAIL PROTECTED]>
Sent: Wednesday, July 05, 2000 4:23 PM
Subject: Re: Odd Oracle Connection Closed problem using servlets...
> ----------------------------------------------------------------
> BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
> WHEN YOU POST, include all relevant version numbers, log files,
> and configuration files. Don't make us guess your problem!!!
> ----------------------------------------------------------------
>
> on 7/5/2000 12:58 PM, "Anthony Quon" <[EMAIL PROTECTED]> wrote:
>
> > ...
> > static final String driver_class = "oracle.jdbc.driver.OracleDriver";
> > Connection conn;
> > ...
>
> is the Connection conn; within your doGet/doPost or outside of it?
>
> If it is outside of it (which I'm guessing that is the case since you are
> checking to see if it is null), then that is your problem. go get a copy
of
> jason hunters servlet book and read up on multithreaded servlets. you
should
> also look into using a connection pool. there are a ton of them out there.
>
> if it is inside of it, then i suspect it is a problem with oracle.
>
> -jon
>
>
>
> --
> --------------------------------------------------------------
> Please read the FAQ! <http://java.apache.org/faq/>
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search Archives:
> <http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
