In 3.0.x, is there a way to tell the pool to invalidate all connections? --- David Jencks <[EMAIL PROTECTED]> wrote: > The problem is that there is no standard way of > distinguishing say a index > violation exception from a total db crash. I tried > closing connections on > any exception, but it didn't work very well. You > can reenable it if you > wish with I think a single line change in > BaseWrapperManagedConnection (3.2 > and 4) or LocalManagedConnection in 3.0.x. > > I thought it would be good to write db-specific > wrappers that could > interpret the exceptions from that db and take > appropriate action, but so > far no one, including me, has done so. > > david jencks > > On 2002.11.25 18:36:19 -0500 Bill Burke wrote: > > In 2.4 we had the feature to remove a connection > from pool if the > > connection > > caused an exception. I don't think 3.x has this. > David Jencks? > > > > XXXXXXXXXXXXXXXX > > Bill Burke > > Chief Architect > > JBoss Group, LLC > > XXXXXXXXXXXXXXXX > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On > Behalf Of Giles, Mick > > Sent: Monday, November 25, 2002 5:20 PM > > To: [EMAIL PROTECTED] > > Subject: [JBoss-user] Database failure > > > > > > A little background. > > > > We're using JBOSS 3.0.3 with an Oracle 902 RAC > database. > > > > > > > > The question is, when the database fails, or the > network fails, or > > whatever other event that can cause the > connections in the pool to close > > is > > there a way for JBOSS to know that the connections > are no longer valid > > and > > reconnect them? What is the default behavior when > you lose the db and > > what > > are the alternative behaviors? > > > > > > > > Ideally JBOSS would reconnect the pool once the > db was available again. > > Is > > this possible? > > > > > > > > > > > > Thanks! > > > > > > > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 > Transitional//EN"> > > <HTML><HEAD> > > <META http-equiv=Content-Type content="text/html; > charset=us-ascii"> > > <META content="MSHTML 6.00.2600.0" name=GENERATOR> > > <STYLE>@page Section1 {size: 8.5in 11.0in; margin: > 1.0in 1.25in 1.0in > > 1.25in; } > > P.MsoNormal { > > FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; > FONT-FAMILY: "Times New > > Roman" > > } > > LI.MsoNormal { > > FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; > FONT-FAMILY: "Times New > > Roman" > > } > > DIV.MsoNormal { > > FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; > FONT-FAMILY: "Times New > > Roman" > > } > > A:link { > > COLOR: blue; TEXT-DECORATION: underline > > } > > SPAN.MsoHyperlink { > > COLOR: blue; TEXT-DECORATION: underline > > } > > A:visited { > > COLOR: purple; TEXT-DECORATION: underline > > } > > SPAN.MsoHyperlinkFollowed { > > COLOR: purple; TEXT-DECORATION: underline > > } > > SPAN.EmailStyle17 { > > COLOR: windowtext; FONT-FAMILY: Arial > > } > > DIV.Section1 { > > page: Section1 > > } > > </STYLE> > > </HEAD> > > <BODY lang=EN-US vLink=purple link=blue> > > <DIV><SPAN class=897053523-25112002><FONT > face=Arial color=#0000ff > > size=2>In 2.4 > > we had the feature to remove a connection from > pool if the connection > > caused an > > exception. I don't think 3.x has this. > David > > Jencks?</FONT></SPAN></DIV> > > <DIV><SPAN class=897053523-25112002><FONT > face=Arial color=#0000ff > > size=2></FONT></SPAN> </DIV> > > <DIV><SPAN class=897053523-25112002> > > <P><FONT size=2>XXXXXXXXXXXXXXXX<BR>Bill > Burke<BR>Chief > > Architect<BR>JBoss > > Group, > LLC<BR>XXXXXXXXXXXXXXXX<BR></FONT></P></SPAN></DIV> > > <BLOCKQUOTE dir=ltr > > style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; > BORDER-LEFT: #0000ff 2px > > solid; MARGIN-RIGHT: 0px"> > > <DIV class=OutlookMessageHeader dir=ltr > align=left><FONT face=Tahoma > > size=2>-----Original > Message-----<BR><B>From:</B> > > [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED]]<B>On > Behalf Of > > </B>Giles, > > Mick<BR><B>Sent:</B> Monday, November 25, 2002 > 5:20 PM<BR><B>To:</B> > > > [EMAIL PROTECTED]<BR><B>Subject:</B> > [JBoss-user] > > Database > > failure<BR><BR></FONT></DIV> > > <DIV class=Section1> > > <P class=MsoNormal><FONT face=Arial size=2><SPAN > > > style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">A > little background… > > </SPAN></FONT></P> > > <P class=MsoNormal><FONT face=Arial size=2><SPAN > > > style="FONT-SIZE: 10pt; FONT-FAMILY: > Arial">We’re using JBOSS > > 3.0.3 with an > > Oracle 902 RAC database.</SPAN></FONT></P> > > <P class=MsoNormal><FONT face=Arial size=2><SPAN > > > style="FONT-SIZE: 10pt; FONT-FAMILY: > Arial"></SPAN></FONT> </P> > > <P class=MsoNormal><FONT face=Arial size=2><SPAN > > > style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The > question is, when the > > database > > fails, or the network fails, or whatever other > event that can cause the > > > > connections in the pool to close is there a way > for JBOSS to know that > > the > > connections are no longer valid and reconnect > them? What is the default > > > > behavior when you lose the db and what are the > alternative > > behaviors?</SPAN></FONT></P> > > <P class=MsoNormal><FONT face=Arial size=2><SPAN > > > style="FONT-SIZE: 10pt; FONT-FAMILY: > Arial"></SPAN></FONT> </P> > > <P class=MsoNormal><FONT face=Arial size=2><SPAN > > > style="FONT-SIZE: 10pt; FONT-FAMILY: > Arial">Ideally JBOSS would > === message truncated ===
__________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ------------------------------------------------------- This SF.net email is sponsored by: Get the new Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
