Database Thing leaking connections to ORACLE

aamit · ‎Nov 24, 2014

Hi, Working on 5.2, I am using the Database Thing, configured to connect to Oracle database, using the JDBC driver from Oracle. 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. It seems the TWX SQL connector is leaking. Is this leak a known issue? Is there a way to avoid it? Also, what is "Connection Monitoring Setting"? Can it be used to understand where the leak is? Thanks, Asaf. <!--[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="--"></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;}

nbhinge · ‎Nov 25, 2014

Hi Asaf,

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

SteveGhee · ‎Nov 25, 2014

Hi,

1. I downloaded

ojdbc6.jar

from

<a href="http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html">http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html</a> and dropped it in lib/ directory of Tomcat and then restarted tomcat. 2. I created a database thing with the following configuration: <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"> Name </td> <td style="padding:.75pt .75pt .75pt .75pt"> Value </td> </tr> <tr style="mso-yfti-irow:1"> <td style="padding:.75pt .75pt .75pt .75pt"> JDBC Driver Class Name </td> <td style="padding:.75pt .75pt .75pt .75pt"> oracle.jdbc.driver.OracleDriver </td> </tr> <tr style="mso-yfti-irow:2"> <td style="padding:.75pt .75pt .75pt .75pt"> JDBC Connection String </td> <td style="padding:.75pt .75pt .75pt .75pt"> jdbc:oracle:thin:@ORACLE-SERVER-NAME:PORT:DATABASE-NAME </td> </tr> <tr style="mso-yfti-irow:3"> <td style="padding:.75pt .75pt .75pt .75pt"> connectionValidationString </td> <td style="padding:.75pt .75pt .75pt .75pt"> SELECT NOW() </td> </tr> <tr style="mso-yfti-irow:4"> <td style="padding:.75pt .75pt .75pt .75pt"> Maxium Number of Connections </td> <td style="padding:.75pt .75pt .75pt .75pt"> 5 </td> </tr> <tr style="mso-yfti-irow:5"> <td style="padding:.75pt .75pt .75pt .75pt"> Database User Name </td> <td style="padding:.75pt .75pt .75pt .75pt"> USERNAME </td> </tr> <tr style="mso-yfti-irow:6;mso-yfti-lastrow:yes"> <td style="padding:.75pt .75pt .75pt .75pt"> Database Password </td> <td style="padding:.75pt .75pt .75pt .75pt"> ******** </td> </tr> </tbody></table> <!--[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="--"></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;}

nbhinge · ‎Nov 27, 2014

Thanks a ton Steve. I have performed this step & it help me out.

I have created service with SQL Query & in table/columns it shows desired database.

But when I tried to 'Test' service it give error "[context: com.thingworx.webservices.context.HttpExecutionContext@3187ba32][message: Unable to Invoke Service GetData on MyService : Could not execute service after making (2) attempts]"</div>

aamit · ‎Nov 27, 2014

Hi Nilesh,

Sorry, I do not know what's wrong.

Thanks,
Asaf.

YangJaeUng · ‎Nov 28, 2014

Hi...

I' JU Yang pre sales in Korea.

Please change SQL like this;

select sysdate from dual;

"SELECT NOW()" is not working in my case.

nbhinge · ‎Nov 28, 2014

Hi Jae

It worked for me too !!!!

Thanks a lot for help.

aamit · ‎Dec 18, 2014

The connection-leak has been resolved in 5.3.

aamit · ‎Jan 15, 2015

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  <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"> mso-bidi-font-family:Arial">Name mso-bidi-font-family:Arial"> </td> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">Value mso-bidi-font-family:Arial"> </td> </tr> <tr style="mso-yfti-irow:1"> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">JDBC Driver Class Name </td> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">oracle.jdbc.driver.OracleDriver </td> </tr> <tr style="mso-yfti-irow:2"> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">JDBC Connection String </td> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">jdbc:oracle:thin:@ORACLE-SERVER-NAME:PORT/SID </td> </tr> <tr style="mso-yfti-irow:3"> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">connectionValidationString </td> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">select sysdate from dual </td> </tr> <tr style="mso-yfti-irow:4"> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">Maxium Number of Connections </td> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">5 </td> </tr> <tr style="mso-yfti-irow:5"> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">Database User Name </td> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">USERNAME </td> </tr> <tr style="mso-yfti-irow:6;mso-yfti-lastrow:yes"> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">Database Password </td> <td style="padding:.75pt .75pt .75pt .75pt"> mso-bidi-font-family:Arial">******** </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;}

Alessio · ‎Apr 08, 2015

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