cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

Database Thing leaking connections to ORACLE

aamit
5-Regular Member

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;}

9 REPLIES 9
nbhinge
1-Newbie
(To:aamit)

Hi Asaf,

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



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

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></p>

aamit
5-Regular Member
(To:nbhinge)

Hi Nilesh,

Sorry, I do not know what's wrong.

Thanks,
Asaf.



YangJaeUng
5-Regular Member
(To:aamit)

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. 



Hi Jae

It worked for me too !!!! 

Thanks a lot for help.




aamit
5-Regular Member
(To:aamit)

The connection-leak has been resolved in 5.3.



aamit
5-Regular Member
(To:aamit)

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

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



Top Tags