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 > reconnect the > pool once the db was available again. Is this > possible?</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"></SPAN></FONT> </P> > <P class=MsoNormal><FONT face=Arial size=2><SPAN > style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks!</SPAN></FONT></P> > <P class=MsoNormal><FONT face=Arial size=2><SPAN > style="FONT-SIZE: 10pt; FONT-FAMILY: > Arial"></SPAN></FONT> </P></DIV></BLOCKQUOTE></BODY></HTML> > ------------------------------------------------------- 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
