Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdprc\configwlm003.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Configuring JDBC Clients for Connection Failure Notification</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1 Build 135" /> <meta name="date" content="2009-06-04T14:31:50Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Configuring JDBC Clients for Connection Failure Notification" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10743-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="configwlm002.htm" title="Previous" type="text/html" /> <link rel="next" href="tdprc_config_oci_client.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="configwlm002.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdprc_config_oci_client.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CACBFIHB" name="CACBFIHB"></a><a id="TDPRC315" name="TDPRC315"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Configuring JDBC Clients for Connection Failure Notification</h1> <a name="BEGIN" id="BEGIN"></a> <p>JDBC Connection Failure Notification enables stand-alone Oracle JDBC connections to respond to node failures quicker. This feature enables a stand-alone connection to listen for Oracle RAC node down events and respond to a node down event by marking the connection closed, permitting user applications to begin recovery quicker. It does not alter the behavior of the application, except that JDBC method calls will throw exceptions more quickly after a node goes down.</p> <p>To configure Connection Failure Notification, you use the ConnectionFailureNotification connection property.</p> <a id="TDPRC316" name="TDPRC316"></a> <p class="subhead2">To configure JDBC clients for Connection Failure Notification:</p> <ol> <li> <p>Set the Connection Failure Notification property either as a system property using the -D option, or by including it in the connection properties argument when creating a connection.</p> <p>To set it as a system property, use a command similar to the following:</p> <pre xml:space="preserve" class="oac_no_warn"> java -Doracle.jdbc.ConnectionFailureNotification=true </pre> <p>To set it within the connection properties argument, use code similar to the following:</p> <pre xml:space="preserve" class="oac_no_warn"> Properties props = new Properties(); props.put("ConnectionFailureNotification", "true"); Connection = DriverManager.getConnection(url, props); </pre></li> <li> <p>Configure the transport mechanism by which the node down events are received. If ONS is the selected transport mechanism, then use the SetONSConfiguration property, as demonstrated in the following code, where <code>docrac1</code> and <code>docrac2</code> represent nodes in the cluster that have ONS running on them:</p> <pre xml:space="preserve" class="oac_no_warn"> props.setONSConfiguration(“nodes=docrac1:4200,docrac2:4200”); </pre></li> <li> <p>Make sure that <code>ons.jar</code> is in the application CLASSPATH.</p> </li> </ol> </div> <!-- class="sect3" --> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2006, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="configwlm002.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdprc_config_oci_client.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de