| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> follow-up: jdbc connection refresh function?
This is a multi-part message in MIME format.
------=_NextPart_000_0047_01C05323.BFC45610 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
ofcourse, i could have the "clients" of my connection pool take the =
responsinility
of closiing their statements/resultsets before releasing the connection, =
but I don't
want to depend that they will do it propmptly every time (going with =
Oracle provided
support for ConnectionPool isan option but we are trying to address a =
generic database
solution)
it would be great if we can query a connection and get all its open =
statements... the
only way I can think of now is to have the clients register all their =
statements with the
pool manager up-front.
thanks,
-krishna.
is there a way to "refresh" a connection without closing and reopening =
a newone so
that any statements/result-sets etc. associated with it is =
refreshed/released?
I'm using a connection-pool and don't know the state of a connection - =
if possible, i would
like to do these cleanups before giving it to another user.
thanks,
-krishna.
------=_NextPart_000_0047_01C05323.BFC45610 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>ofcourse, i could have the "clients" of =
my=20
connection pool take the responsinility</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>of closiing their statements/resultsets =
before=20
releasing the connection, but I don't</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>want to depend that they will do it =
propmptly every=20
time (going with Oracle provided</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>support for ConnectionPool isan option =
but we are=20
trying to address a generic database</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>solution)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>it would be great if we can query a =
connection and=20
get all its open statements... the</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>only way I can think of now is to have =
the clients=20
register all their statements with the</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>pool manager up-front.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>-krishna.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:krishna_at_nehanet.com" =
title=3Dkrishna_at_nehanet.com>Krishna=20
Prasad</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
href=3D"mailto:ORACLE-L_at_fatcity.com"=20
title=3DORACLE-L_at_fatcity.com>ORACLE-L_at_fatcity.com</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, November 20, 2000 =
6:53=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> jdbc connection =
refresh=20
function?</DIV>
<DIV><BR></DIV>
<DIV><FONT face=3DArial size=3D2>is there a way to "refresh" a =
connection without=20
closing and reopening a newone so</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>that any statements/result-sets etc. =
associated=20
with it is refreshed/released?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm using a connection-pool and don't =
know the=20
state of a connection - if possible, i would</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>like to do these cleanups before =
giving it to=20
another user.</FONT></DIV>
<DIV> </DIV> <DIV><FONT face=3DArial size=3D2>thanks,</FONT></DIV> <DIV><FONT face=3DArial =Received on Mon Nov 20 2000 - 20:57:37 CST
 |
 |