Re: Oracle Connection inactive

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Thu, 25 Apr 2002 16:46:18 GMT
Message-ID: <3CC832D9.458412A6@exesolutions.com>

Oliver Huppert wrote:

> Hello *.*
>
> I have a problem with connections from JDBC to Oracle.
> We are using a middleware, that does not support Oracle by itself.
>
> So the problem is that the connections are not closed after processing.
> When I look on the view v$session the connection are still there, but
> inactive, because when the browser is closed, the middleware will not close
> the DB-Connection.
>
> Is there a procedure, that could delete the inactive connection from a
> specified user and with the timestamp before a specified time.
>
> Thanx
> Olli

You could certainly kill the session by any one of a number of means depending on your operating system which you don't mention.

But the best course of action would be to recognize that your middleware is the wrong product and likely has lots of other problems that will waste your time for years to come. Dump it and get something that works. Keeping bad software is just throwing good money after bad.

Daniel Morgan Received on Thu Apr 25 2002 - 11:46:18 CDT