9 Replies Latest reply on Apr 8, 2015 2:59 AM by alessiomar RSS
    asafa Explorer

    Database Thing leaking connections to ORACLE

    <p><!--[if gte mso 9]><xml>  <o:OfficeDocumentSettings>   <o:RelyOnVML></o:RelyOnVML>   <o:AllowPNG></o:AllowPNG>  </o:OfficeDocumentSettings> </xml><![endif]-->  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial">Hi,</span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"> Working on 5.2, I am using the Database Thing, configured to connect to Oracle database, using the JDBC driver from Oracle.</span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial">After one day of development, the ORACLE database reported "too-many-open-connections" and indeed over 60 connections were listed as coming from my machine. The situation was resolved once I restarted the tomcat servers.</span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"> It seems the TWX SQL connector is leaking.</span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial">Is this leak a known issue?</span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial">Is there a way to avoid it?</span></p>    <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial">Also, what is "Connection Monitoring Setting"?</span><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"><br></span></p><p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial">Can it be used to understand where the leak is?</span>  </p><p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"> </span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial">Thanks,</span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial">Asaf.</span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"> </span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"> </span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"> </span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"> </span></p>  <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;; mso-bidi-font-family:Arial"> </span></p>  <!--[if gte mso 9]><xml>  <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:TrackMoves></w:TrackMoves>   <w:TrackFormatting></w:TrackFormatting>   <w:PunctuationKerning></w:PunctuationKerning>   <w:ValidateAgainstSchemas></w:ValidateAgainstSchemas>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:DoNotPromoteQF></w:DoNotPromoteQF>   <w:LidThemeOther>EN-US</w:LidThemeOther>   <w:LidThemeAsian>X-NONE</w:LidThemeAsian>   <w:LidThemeComplexScript>HE</w:LidThemeComplexScript>   <w:Compatibility>    <w:BreakWrappedTables></w:BreakWrappedTables>    <w:SnapToGridInCell></w:SnapToGridInCell>    <w:WrapTextWithPunct></w:WrapTextWithPunct>    <w:UseAsianBreakRules></w:UseAsianBreakRules>    <w:DontGrowAutofit></w:DontGrowAutofit>    <w:SplitPgBreakAndParaMark></w:SplitPgBreakAndParaMark>    <w:EnableOpenTypeKerning></w:EnableOpenTypeKerning>    <w:DontFlipMirrorIndents></w:DontFlipMirrorIndents>    <w:OverrideTableStyleHps></w:OverrideTableStyleHps>   </w:Compatibility>   <m:mathPr>    <m:mathFont m:val="Cambria Math"></m:mathFont>    <m:brkBin m:val="before"></m:brkBin>    <m:brkBinSub m:val="&#45;-"></m:brkBinSub>    <m:smallFrac m:val="off"></m:smallFrac>    <m:dispDef></m:dispDef>    <m:lMargin m:val="0"></m:lMargin>    <m:rMargin m:val="0"></m:rMargin>    <m:defJc m:val="centerGroup"></m:defJc>    <m:wrapIndent m:val="1440"></m:wrapIndent>    <m:intLim m:val="subSup"></m:intLim>    <m:naryLim m:val="undOvr"></m:naryLim>   </m:mathPr></w:WordDocument> </xml><![endif]><![if gte mso 9]><![endif]><![if gte mso 10]>

    /* Style Definitions */
    table.MsoNormalTable
    {mso-style-name:"Table Normal";
    mso-tstyle-rowband-size:0;
    mso-tstyle-colband-size:0;
    mso-style-noshow:yes;
    mso-style-priority:99;
    mso-style-parent:"";
    mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
    mso-para-margin:0cm;
    mso-para-margin-bottom:.0001pt;
    mso-pagination:widow-orphan;
    font-size:11.0pt;
    font-family:"Calibri","sans-serif";
    mso-ascii-font-family:Calibri;
    mso-ascii-theme-font:minor-latin;
    mso-hansi-font-family:Calibri;
    mso-hansi-theme-font:minor-latin;}

      • Database Thing leaking connections to ORACLE
        nileshbhi Newbie

        Hi Asaf,

         

        Can you help me by providing details how you have connected oracle ?

          • Database Thing leaking connections to ORACLE
            stevegh Newbie



            Hi,



             



            1. I downloaded










            ojdbc6.jar




            from



                

            http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html</span></p> <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;"> </span></p> <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">and dropped it in lib/ directory of Tomcat and then restarted tomcat.</span></p> <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;"> </span></p> <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">2. I created a database thing with the following configuration: </span><br><b><span style="font-family:&quot;Courier New&quot;"></span></b></p> <table class="MsoNormalTable" style="mso-cellspacing:1.5pt; mso-yfti-tbllook:1184" border="0" cellpadding="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><b><span style="font-family:&quot;Courier New&quot;">Name</span></b></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><b><span style="font-family:&quot;Courier New&quot;">Value</span></b></p>   </td> </tr> <tr style="mso-yfti-irow:1">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">JDBC Driver Class   Name</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">oracle.jdbc.driver.OracleDriver</span></p>   </td> </tr> <tr style="mso-yfti-irow:2">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">JDBC Connection   String</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">jdbc:oracle:thin:@ORACLE-SERVER-NAME:PORT:DATABASE-NAME</span></p>   </td> </tr> <tr style="mso-yfti-irow:3">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">connectionValidationString</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">SELECT NOW()</span></p>   </td> </tr> <tr style="mso-yfti-irow:4">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">Maxium Number of   Connections</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">5</span></p>   </td> </tr> <tr style="mso-yfti-irow:5">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">Database User Name</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">USERNAME</span></p>   </td> </tr> <tr style="mso-yfti-irow:6;mso-yfti-lastrow:yes">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">Database Password</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;">********</span></p>   </td> </tr> </tbody></table> <p class="MsoNormal"><span style="font-family:&quot;Courier New&quot;"> </span></p> <!--[if gte mso 9]><xml> <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:TrackMoves></w:TrackMoves>   <w:TrackFormatting></w:TrackFormatting>   <w:PunctuationKerning></w:PunctuationKerning>   <w:ValidateAgainstSchemas></w:ValidateAgainstSchemas>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:DoNotPromoteQF></w:DoNotPromoteQF>   <w:LidThemeOther>EN-US</w:LidThemeOther>   <w:LidThemeAsian>X-NONE</w:LidThemeAsian>   <w:LidThemeComplexScript>HE</w:LidThemeComplexScript>   <w:Compatibility>    <w:BreakWrappedTables></w:BreakWrappedTables>    <w:SnapToGridInCell></w:SnapToGridInCell>    <w:WrapTextWithPunct></w:WrapTextWithPunct>    <w:UseAsianBreakRules></w:UseAsianBreakRules>    <w:DontGrowAutofit></w:DontGrowAutofit>    <w:SplitPgBreakAndParaMark></w:SplitPgBreakAndParaMark>    <w:EnableOpenTypeKerning></w:EnableOpenTypeKerning>    <w:DontFlipMirrorIndents></w:DontFlipMirrorIndents>    <w:OverrideTableStyleHps></w:OverrideTableStyleHps>   </w:Compatibility>   <m:mathPr>    <m:mathFont m:val="Cambria Math"></m:mathFont>    <m:brkBin m:val="before"></m:brkBin>    <m:brkBinSub m:val="&#45;-"></m:brkBinSub>    <m:smallFrac m:val="off"></m:smallFrac>    <m:dispDef></m:dispDef>    <m:lMargin m:val="0"></m:lMargin>    <m:rMargin m:val="0"></m:rMargin>    <m:defJc m:val="centerGroup"></m:defJc>    <m:wrapIndent m:val="1440"></m:wrapIndent>    <m:intLim m:val="subSup"></m:intLim>    <m:naryLim m:val="undOvr"></m:naryLim>   </m:mathPr></w:WordDocument> </xml><![endif]><![if gte mso 9]><![endif]><![if gte mso 10]>

            /* Style Definitions */
            table.MsoNormalTable
            {mso-style-name:"Table Normal";
            mso-tstyle-rowband-size:0;
            mso-tstyle-colband-size:0;
            mso-style-noshow:yes;
            mso-style-priority:99;
            mso-style-parent:"";
            mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
            mso-para-margin:0cm;
            mso-para-margin-bottom:.0001pt;
            mso-pagination:widow-orphan;
            font-size:11.0pt;
            font-family:"Calibri","sans-serif";
            mso-ascii-font-family:Calibri;
            mso-ascii-theme-font:minor-latin;
            mso-hansi-font-family:Calibri;
            mso-hansi-theme-font:minor-latin;}

          • Database Thing leaking connections to ORACLE
            asafa Explorer

            The connection-leak has been resolved in 5.3.

             



            • Database Thing leaking connections to ORACLE
              asafa Explorer

              <p>For completeness, I'm providing updated JDBC settings that include the fix of 'Select date from dual", and a solution for a problem that SO kindly solved for me -  http://stackoverflow.com/a/20508453<br><br><!--[if gte mso 9]><xml> <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:TrackMoves></w:TrackMoves>   <w:TrackFormatting></w:TrackFormatting>   <w:PunctuationKerning></w:PunctuationKerning>   <w:ValidateAgainstSchemas></w:ValidateAgainstSchemas>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:DoNotPromoteQF></w:DoNotPromoteQF>   <w:LidThemeOther>EN-US</w:LidThemeOther>   <w:LidThemeAsian>X-NONE</w:LidThemeAsian>   <w:LidThemeComplexScript>HE</w:LidThemeComplexScript>   <w:Compatibility>    <w:BreakWrappedTables></w:BreakWrappedTables>    <w:SnapToGridInCell></w:SnapToGridInCell>    <w:WrapTextWithPunct></w:WrapTextWithPunct>    <w:UseAsianBreakRules></w:UseAsianBreakRules>    <w:DontGrowAutofit></w:DontGrowAutofit>    <w:SplitPgBreakAndParaMark></w:SplitPgBreakAndParaMark>    <w:EnableOpenTypeKerning></w:EnableOpenTypeKerning>    <w:DontFlipMirrorIndents></w:DontFlipMirrorIndents>    <w:OverrideTableStyleHps></w:OverrideTableStyleHps>   </w:Compatibility>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>   <m:mathPr>    <m:mathFont m:val="Cambria Math"></m:mathFont>    <m:brkBin m:val="before"></m:brkBin>    <m:brkBinSub m:val="&#45;-"></m:brkBinSub>    <m:smallFrac m:val="off"></m:smallFrac>    <m:dispDef></m:dispDef>    <m:lMargin m:val="0"></m:lMargin>    <m:rMargin m:val="0"></m:rMargin>    <m:defJc m:val="centerGroup"></m:defJc>    <m:wrapIndent m:val="1440"></m:wrapIndent>    <m:intLim m:val="subSup"></m:intLim>    <m:naryLim m:val="undOvr"></m:naryLim>   </m:mathPr></w:WordDocument> </xml><![endif]--> <table class="MsoNormalTable" style="mso-cellspacing:1.5pt; mso-yfti-tbllook:1184;mso-padding-alt:0cm 0cm 0cm 0cm" border="0" cellpadding="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><b><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">Name</span></b><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial"></span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><b><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">Value</span></b><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial"></span></p>   </td> </tr> <tr style="mso-yfti-irow:1">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">JDBC Driver Class Name</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">oracle.jdbc.driver.OracleDriver</span></p>   </td> </tr> <tr style="mso-yfti-irow:2">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">JDBC Connection String</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">jdbc:oracle:thin:@ORACLE-SERVER-NAME:PORT/SID</span></p>   </td> </tr> <tr style="mso-yfti-irow:3">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">connectionValidationString</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">select sysdate from dual</span></p>   </td> </tr> <tr style="mso-yfti-irow:4">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">Maxium Number of Connections</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">5</span></p>   </td> </tr> <tr style="mso-yfti-irow:5">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">Database User Name</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">USERNAME</span></p>   </td> </tr> <tr style="mso-yfti-irow:6;mso-yfti-lastrow:yes">   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">Database Password</span></p>   </td>   <td style="padding:.75pt .75pt .75pt .75pt">   <p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;;   mso-bidi-font-family:Arial">********</span></p>   </td> </tr> </tbody></table> <!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"   DefSemiHidden="true" DefQFormat="false" DefPriority="99"   LatentStyleCount="267">   <w:LsdException Locked="false" Priority="0" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Normal"></w:LsdException>   <w:LsdException Locked="false" Priority="9" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="heading 1"></w:LsdException>   <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"></w:LsdException>   <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"></w:LsdException>   <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"></w:LsdException>   <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"></w:LsdException>   <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"></w:LsdException>   <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"></w:LsdException>   <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"></w:LsdException>   <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 1"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 2"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 3"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 4"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 5"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 6"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 7"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 8"></w:LsdException>   <w:LsdException Locked="false" Priority="39" Name="toc 9"></w:LsdException>   <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"></w:LsdException>   <w:LsdException Locked="false" Priority="10" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Title"></w:LsdException>   <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"></w:LsdException>   <w:LsdException Locked="false" Priority="11" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Subtitle"></w:LsdException>   <w:LsdException Locked="false" Priority="22" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Strong"></w:LsdException>   <w:LsdException Locked="false" Priority="20" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Emphasis"></w:LsdException>   <w:LsdException Locked="false" Priority="59" SemiHidden="false"    UnhideWhenUsed="false" Name="Table Grid"></w:LsdException>   <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"></w:LsdException>   <w:LsdException Locked="false" Priority="1" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="No Spacing"></w:LsdException>   <w:LsdException Locked="false" Priority="60" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Shading"></w:LsdException>   <w:LsdException Locked="false" Priority="61" SemiHidden="false"    UnhideWhenUsed="false" Name="Light List"></w:LsdException>   <w:LsdException Locked="false" Priority="62" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Grid"></w:LsdException>   <w:LsdException Locked="false" Priority="63" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 1"></w:LsdException>   <w:LsdException Locked="false" Priority="64" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 2"></w:LsdException>   <w:LsdException Locked="false" Priority="65" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 1"></w:LsdException>   <w:LsdException Locked="false" Priority="66" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 2"></w:LsdException>   <w:LsdException Locked="false" Priority="67" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 1"></w:LsdException>   <w:LsdException Locked="false" Priority="68" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 2"></w:LsdException>   <w:LsdException Locked="false" Priority="69" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 3"></w:LsdException>   <w:LsdException Locked="false" Priority="70" SemiHidden="false"    UnhideWhenUsed="false" Name="Dark List"></w:LsdException>   <w:LsdException Locked="false" Priority="71" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Shading"></w:LsdException>   <w:LsdException Locked="false" Priority="72" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful List"></w:LsdException>   <w:LsdException Locked="false" Priority="73" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Grid"></w:LsdException>   <w:LsdException Locked="false" Priority="60" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Shading Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="61" SemiHidden="false"    UnhideWhenUsed="false" Name="Light List Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="62" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Grid Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="63" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="64" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="65" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 1 Accent 1"></w:LsdException>   <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"></w:LsdException>   <w:LsdException Locked="false" Priority="34" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"></w:LsdException>   <w:LsdException Locked="false" Priority="29" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Quote"></w:LsdException>   <w:LsdException Locked="false" Priority="30" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"></w:LsdException>   <w:LsdException Locked="false" Priority="66" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 2 Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="67" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="68" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="69" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="70" SemiHidden="false"    UnhideWhenUsed="false" Name="Dark List Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="71" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Shading Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="72" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful List Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="73" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Grid Accent 1"></w:LsdException>   <w:LsdException Locked="false" Priority="60" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Shading Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="61" SemiHidden="false"    UnhideWhenUsed="false" Name="Light List Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="62" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Grid Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="63" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="64" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="65" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 1 Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="66" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 2 Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="67" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="68" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="69" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="70" SemiHidden="false"    UnhideWhenUsed="false" Name="Dark List Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="71" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Shading Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="72" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful List Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="73" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Grid Accent 2"></w:LsdException>   <w:LsdException Locked="false" Priority="60" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Shading Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="61" SemiHidden="false"    UnhideWhenUsed="false" Name="Light List Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="62" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Grid Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="63" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="64" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="65" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 1 Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="66" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 2 Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="67" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="68" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="69" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="70" SemiHidden="false"    UnhideWhenUsed="false" Name="Dark List Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="71" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Shading Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="72" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful List Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="73" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Grid Accent 3"></w:LsdException>   <w:LsdException Locked="false" Priority="60" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Shading Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="61" SemiHidden="false"    UnhideWhenUsed="false" Name="Light List Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="62" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Grid Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="63" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="64" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="65" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 1 Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="66" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 2 Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="67" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="68" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="69" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="70" SemiHidden="false"    UnhideWhenUsed="false" Name="Dark List Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="71" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Shading Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="72" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful List Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="73" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Grid Accent 4"></w:LsdException>   <w:LsdException Locked="false" Priority="60" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Shading Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="61" SemiHidden="false"    UnhideWhenUsed="false" Name="Light List Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="62" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Grid Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="63" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="64" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="65" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 1 Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="66" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 2 Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="67" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="68" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="69" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="70" SemiHidden="false"    UnhideWhenUsed="false" Name="Dark List Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="71" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Shading Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="72" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful List Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="73" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Grid Accent 5"></w:LsdException>   <w:LsdException Locked="false" Priority="60" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Shading Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="61" SemiHidden="false"    UnhideWhenUsed="false" Name="Light List Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="62" SemiHidden="false"    UnhideWhenUsed="false" Name="Light Grid Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="63" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="64" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="65" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 1 Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="66" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium List 2 Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="67" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="68" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="69" SemiHidden="false"    UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="70" SemiHidden="false"    UnhideWhenUsed="false" Name="Dark List Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="71" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Shading Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="72" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful List Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="73" SemiHidden="false"    UnhideWhenUsed="false" Name="Colorful Grid Accent 6"></w:LsdException>   <w:LsdException Locked="false" Priority="19" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"></w:LsdException>   <w:LsdException Locked="false" Priority="21" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"></w:LsdException>   <w:LsdException Locked="false" Priority="31" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"></w:LsdException>   <w:LsdException Locked="false" Priority="32" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"></w:LsdException>   <w:LsdException Locked="false" Priority="33" SemiHidden="false"    UnhideWhenUsed="false" QFormat="true" Name="Book Title"></w:LsdException>   <w:LsdException Locked="false" Priority="37" Name="Bibliography"></w:LsdException>   <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"></w:LsdException> </w:LatentStyles> </xml><![endif]><![if gte mso 10]>

              /* Style Definitions */
              table.MsoNormalTable
              {mso-style-name:"Table Normal";
              mso-tstyle-rowband-size:0;
              mso-tstyle-colband-size:0;
              mso-style-noshow:yes;
              mso-style-priority:99;
              mso-style-parent:"";
              mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
              mso-para-margin:0cm;
              mso-para-margin-bottom:.0001pt;
              mso-pagination:widow-orphan;
              font-size:11.0pt;
              font-family:"Calibri","sans-serif";
              mso-ascii-font-family:Calibri;
              mso-ascii-theme-font:minor-latin;
              mso-hansi-font-family:Calibri;
              mso-hansi-theme-font:minor-latin;}

              • Database Thing leaking connections to ORACLE
                alessiomar Explorer

                This configuration also worked for me.
                In addition I just wanted to point out that Oracle has different JDBC drivers for different minor releases of the DBMS.
                For instance, 11g version 11.2.0.3 has a different driver than 11.2.0.4