-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
There are two possibilites:
1) Why not write a monitor servlet which periodically uses the
connection(s) to execute a query against Oracle's DUAL table?
2) Use connection pooling. Refer to Jason Hunter's book for an
example of how to get started. His examples would need more
work to keep the connection alive.
Match
At 10/5/1999 10:17 AM, you wrote:
>-----------------------------
>Please read the FAQ!
><http://java.apache.org/faq/>
>-----------------------------
>
>Hi there
>
>In my current JServ/Apache configuration I have a number of servlets loaded
>at startup which (in their initialization)
>instantiate a database connection to a remote database. My problem is that
>the database uses a TCP connection to
>a machine outside our lan and thus goes through a router. The router has a
>set timeout on these connections. So here's
>my question (And my most sincere apologies if this issue has already been
>dealt with) :
>
> How can I check if the database connection has been dropped and
>re-initialize it if so ? Idealy I wouldn't like
> to be forced to re-init it during a doGet/doPost request as this will
>cause browsers to wait longer for their
> requests to be serviced. I've tried the following in the doGet method of
>one of my servlets to no avail :
>
> if(DatabaseConnection.isClosed())
> DatabaseConnection = DriverManager.getConnection
>("jdbc:oracle:oci8:@"+DatabaseHost,DatabaseUser,DatabasePassword);
>
> My configuration is as follows:
>
> Apache 1.3.9/ JServ 1.0
> RedHat Linux 6.0
> Oracle8 using OCI (Native) JDBC Drivers
> Blackdown Java 1.1.7v3
>
>Any help appreciated.
>Reuben
>
>
>
>
>--
>--------------------------------------------------------------
>Please read the FAQ! <http://java.apache.org/faq/>
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Archives and Other: <http://java.apache.org/main/mail.html>
>Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
