[opencms-dev] FW: OpenCMS JDBC connection hangs Oracle database

[Christoph P. Kukulies]

I don't know whether the post (now in double > >) was an accident
because of the indentation order of 1 (and otherwise empty) 
which should be indentation level 0 for a first post.

Anyway, a similar issue came up recently, that connections to an Oracle
database seem to die after some time of inactivity.

I'm chiming in into this thread because I had a similar problem at
a customers' site - it was not OpenCms but another application being connected
through OCI (Oracle Client Interface) to the Oracle server.

It turned out that the firewall inbetween had been the culprit.
Either some kind of wakeup (watchdog) mechanism should be used or better,
talk to the firewall admins to remove this (weird) feature.

On Thu, Jan 05, 2006 at 06:58:34PM +0530, Mehta, Girish wrote:
> > Dear All,
> > 
> > We are using OpenCMS with SAP Netweaver Application server. The OpenCMS
> > hangs after sometime on Application server. The connection made to Oracle
> > database from OpenCMS is using JDBC connection.
> > 
> > When OpenCMS is removed the SAP Netweaver server works fine and does not
> > hang.
...


--
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de