"Lam Kwok Wa, Computer Centre, HKU" wrote:
>
> Dear all,
>
> My apache server 1.3.3 and Jserv 0.9.11.
> I got a problem with the jdbc connection to Oracle.
> My servlet connects to Oracle databases via JDBC
> > >(type 4). When the page generated by the servlet
> is loaded for the first time, it works properly even
> it is reloaded again.
> But, After 10 mins time, if the page is reloaded again,
> part of data retrieved from the Oracle database are
> lost. I checked the execution of the servlet and I
> found that the servlet could not create "Statement"
> class, so the sql statement could not be executed.
> I suspected that the DB connection may have been
> timeout. But, I found that the connection is not null.
> (I am sure whether it is the right way to check it).
> When it executes the "createStatement", it
> throws exeception.
>
> Please let me know if you can give me some suggestion
> to fix it. Thanks
>
> Eric
Hi Eric
What error message do you get?
I had a problem with exceeding maximum cursors, which turned out, that I had to
explicitly close() all ResultSets immediately after
use.
BTW:
Checking a connection is done via:
Connection.isClosed()
But this isn't always correct.
Tschau
Christian
----------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html/>
Problems?: [EMAIL PROTECTED]
