| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
| <head> |
| <meta http-equiv="content-type" content="text/html; charset=UTF-8" /> |
| <title>ServerApiSqlFetch xref</title> |
| <link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" /> |
| </head> |
| <body> |
| <div id="overview"><a href="../../../../../../apidocs/org/trafodion/dcs/servermt/serverHandler/ServerApiSqlFetch.html">View Javadoc</a></div><pre> |
| |
| <a class="jxr_linenumber" name="1" href="#1">1</a> <em class="jxr_javadoccomment">/**</em> |
| <a class="jxr_linenumber" name="2" href="#2">2</a> <em class="jxr_javadoccomment">* @@@ START COPYRIGHT @@@</em> |
| <a class="jxr_linenumber" name="3" href="#3">3</a> |
| <a class="jxr_linenumber" name="4" href="#4">4</a> <em class="jxr_javadoccomment">* Licensed to the Apache Software Foundation (ASF) under one</em> |
| <a class="jxr_linenumber" name="5" href="#5">5</a> <em class="jxr_javadoccomment">* or more contributor license agreements. See the NOTICE file</em> |
| <a class="jxr_linenumber" name="6" href="#6">6</a> <em class="jxr_javadoccomment">* distributed with this work for additional information</em> |
| <a class="jxr_linenumber" name="7" href="#7">7</a> <em class="jxr_javadoccomment">* regarding copyright ownership. The ASF licenses this file</em> |
| <a class="jxr_linenumber" name="8" href="#8">8</a> <em class="jxr_javadoccomment">* to you under the Apache License, Version 2.0 (the</em> |
| <a class="jxr_linenumber" name="9" href="#9">9</a> <em class="jxr_javadoccomment">* "License"); you may not use this file except in compliance</em> |
| <a class="jxr_linenumber" name="10" href="#10">10</a> <em class="jxr_javadoccomment">* with the License. You may obtain a copy of the License at</em> |
| <a class="jxr_linenumber" name="11" href="#11">11</a> |
| <a class="jxr_linenumber" name="12" href="#12">12</a> <em class="jxr_javadoccomment">* <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em> |
| <a class="jxr_linenumber" name="13" href="#13">13</a> |
| <a class="jxr_linenumber" name="14" href="#14">14</a> <em class="jxr_javadoccomment">* Unless required by applicable law or agreed to in writing,</em> |
| <a class="jxr_linenumber" name="15" href="#15">15</a> <em class="jxr_javadoccomment">* software distributed under the License is distributed on an</em> |
| <a class="jxr_linenumber" name="16" href="#16">16</a> <em class="jxr_javadoccomment">* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY</em> |
| <a class="jxr_linenumber" name="17" href="#17">17</a> <em class="jxr_javadoccomment">* KIND, either express or implied. See the License for the</em> |
| <a class="jxr_linenumber" name="18" href="#18">18</a> <em class="jxr_javadoccomment">* specific language governing permissions and limitations</em> |
| <a class="jxr_linenumber" name="19" href="#19">19</a> <em class="jxr_javadoccomment">* under the License.</em> |
| <a class="jxr_linenumber" name="20" href="#20">20</a> |
| <a class="jxr_linenumber" name="21" href="#21">21</a> <em class="jxr_javadoccomment">* @@@ END COPYRIGHT @@@</em> |
| <a class="jxr_linenumber" name="22" href="#22">22</a> <em class="jxr_javadoccomment"> */</em> |
| <a class="jxr_linenumber" name="23" href="#23">23</a> <strong class="jxr_keyword">package</strong> org.trafodion.dcs.servermt.serverHandler; |
| <a class="jxr_linenumber" name="24" href="#24">24</a> |
| <a class="jxr_linenumber" name="25" href="#25">25</a> <strong class="jxr_keyword">import</strong> java.sql.*; |
| <a class="jxr_linenumber" name="26" href="#26">26</a> <strong class="jxr_keyword">import</strong> java.net.*; |
| <a class="jxr_linenumber" name="27" href="#27">27</a> <strong class="jxr_keyword">import</strong> java.io.*; |
| <a class="jxr_linenumber" name="28" href="#28">28</a> <strong class="jxr_keyword">import</strong> java.nio.*; |
| <a class="jxr_linenumber" name="29" href="#29">29</a> <strong class="jxr_keyword">import</strong> java.nio.channels.*; |
| <a class="jxr_linenumber" name="30" href="#30">30</a> <strong class="jxr_keyword">import</strong> java.nio.channels.spi.*; |
| <a class="jxr_linenumber" name="31" href="#31">31</a> <strong class="jxr_keyword">import</strong> java.sql.SQLException; |
| <a class="jxr_linenumber" name="32" href="#32">32</a> <strong class="jxr_keyword">import</strong> java.util.*; |
| <a class="jxr_linenumber" name="33" href="#33">33</a> <strong class="jxr_keyword">import</strong> java.lang.reflect.Array; |
| <a class="jxr_linenumber" name="34" href="#34">34</a> <strong class="jxr_keyword">import</strong> java.math.*; |
| <a class="jxr_linenumber" name="35" href="#35">35</a> |
| <a class="jxr_linenumber" name="36" href="#36">36</a> <strong class="jxr_keyword">import</strong> org.apache.trafodion.jdbc.t2.*; |
| <a class="jxr_linenumber" name="37" href="#37">37</a> |
| <a class="jxr_linenumber" name="38" href="#38">38</a> <strong class="jxr_keyword">import</strong> org.trafodion.dcs.Constants; |
| <a class="jxr_linenumber" name="39" href="#39">39</a> <strong class="jxr_keyword">import</strong> org.trafodion.dcs.util.*; |
| <a class="jxr_linenumber" name="40" href="#40">40</a> <strong class="jxr_keyword">import</strong> org.trafodion.dcs.servermt.ServerConstants; |
| <a class="jxr_linenumber" name="41" href="#41">41</a> <strong class="jxr_keyword">import</strong> org.trafodion.dcs.servermt.ServerUtils; |
| <a class="jxr_linenumber" name="42" href="#42">42</a> <strong class="jxr_keyword">import</strong> org.trafodion.dcs.servermt.serverDriverInputOutput.*; |
| <a class="jxr_linenumber" name="43" href="#43">43</a> <strong class="jxr_keyword">import</strong> org.trafodion.dcs.servermt.serverSql.*; |
| <a class="jxr_linenumber" name="44" href="#44">44</a> |
| <a class="jxr_linenumber" name="45" href="#45">45</a> <strong class="jxr_keyword">import</strong> org.apache.commons.logging.Log; |
| <a class="jxr_linenumber" name="46" href="#46">46</a> <strong class="jxr_keyword">import</strong> org.apache.commons.logging.LogFactory; |
| <a class="jxr_linenumber" name="47" href="#47">47</a> |
| <a class="jxr_linenumber" name="48" href="#48">48</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverHandler/ServerApiSqlFetch.html">ServerApiSqlFetch</a> { |
| <a class="jxr_linenumber" name="49" href="#49">49</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> odbc_SQLSvc_Fetch_ParamError_exn_ = 1; |
| <a class="jxr_linenumber" name="50" href="#50">50</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> odbc_SQLSvc_Fetch_InvalidConnection_exn_ = 2; |
| <a class="jxr_linenumber" name="51" href="#51">51</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> odbc_SQLSvc_Fetch_SQLError_exn_ = 3; |
| <a class="jxr_linenumber" name="52" href="#52">52</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> odbc_SQLSvc_Fetch_SQLInvalidHandle_exn_ = 4; |
| <a class="jxr_linenumber" name="53" href="#53">53</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> odbc_SQLSvc_Fetch_SQLNoDataFound_exn_ = 5; |
| <a class="jxr_linenumber" name="54" href="#54">54</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> odbc_SQLSvc_Fetch_SQLStillExecuting_exn_ = 6; |
| <a class="jxr_linenumber" name="55" href="#55">55</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> odbc_SQLSvc_Fetch_SQLQueryCancelled_exn_ = 7; |
| <a class="jxr_linenumber" name="56" href="#56">56</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> odbc_SQLSvc_Fetch_TransactionError_exn_ = 8; |
| <a class="jxr_linenumber" name="57" href="#57">57</a> |
| <a class="jxr_linenumber" name="58" href="#58">58</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> dateLength = 10; |
| <a class="jxr_linenumber" name="59" href="#59">59</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> timeLength = 8; |
| <a class="jxr_linenumber" name="60" href="#60">60</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> timestampLength = 26; |
| <a class="jxr_linenumber" name="61" href="#61">61</a> |
| <a class="jxr_linenumber" name="62" href="#62">62</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> Log LOG = LogFactory.getLog(ServerApiSqlFetch.<strong class="jxr_keyword">class</strong>); |
| <a class="jxr_linenumber" name="63" href="#63">63</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> instance; |
| <a class="jxr_linenumber" name="64" href="#64">64</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> serverThread; |
| <a class="jxr_linenumber" name="65" href="#65">65</a> <strong class="jxr_keyword">private</strong> String serverWorkerName; |
| <a class="jxr_linenumber" name="66" href="#66">66</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverHandler/ClientData.html">ClientData</a> clientData; |
| <a class="jxr_linenumber" name="67" href="#67">67</a> <em class="jxr_comment">//-----------------------------------------------</em> |
| <a class="jxr_linenumber" name="68" href="#68">68</a> <strong class="jxr_keyword">private</strong> Statement stmt; |
| <a class="jxr_linenumber" name="69" href="#69">69</a> <strong class="jxr_keyword">private</strong> PreparedStatement pstmt; |
| <a class="jxr_linenumber" name="70" href="#70">70</a> <strong class="jxr_keyword">private</strong> ResultSet rs; |
| <a class="jxr_linenumber" name="71" href="#71">71</a> <strong class="jxr_keyword">private</strong> ResultSetMetaData rsMD; |
| <a class="jxr_linenumber" name="72" href="#72">72</a> <strong class="jxr_keyword">private</strong> SQLMXResultSet sqlrs; |
| <a class="jxr_linenumber" name="73" href="#73">73</a> <strong class="jxr_keyword">private</strong> SQLMXResultSetMetaData strsmd; |
| <a class="jxr_linenumber" name="74" href="#74">74</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverSql/TrafConnection.html">TrafConnection</a> trafConn; |
| <a class="jxr_linenumber" name="75" href="#75">75</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverSql/TrafStatement.html">TrafStatement</a> trafStmt; |
| <a class="jxr_linenumber" name="76" href="#76">76</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverSql/TrafResultSet.html">TrafResultSet</a> trafResultSet; |
| <a class="jxr_linenumber" name="77" href="#77">77</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2List.html">Descriptor2List</a> columnDescList; |
| <a class="jxr_linenumber" name="78" href="#78">78</a> <em class="jxr_comment">//----------------------------------------------</em> |
| <a class="jxr_linenumber" name="79" href="#79">79</a> <strong class="jxr_keyword">private</strong> String stmtLabelBytes; |
| <a class="jxr_linenumber" name="80" href="#80">80</a> <strong class="jxr_keyword">private</strong> String cursorNameBytes; |
| <a class="jxr_linenumber" name="81" href="#81">81</a> <strong class="jxr_keyword">private</strong> String stmtOptionsBytes; |
| <a class="jxr_linenumber" name="82" href="#82">82</a> |
| <a class="jxr_linenumber" name="83" href="#83">83</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> dialogueId; |
| <a class="jxr_linenumber" name="84" href="#84">84</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> sqlAsyncEnable; |
| <a class="jxr_linenumber" name="85" href="#85">85</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> queryTimeout; |
| <a class="jxr_linenumber" name="86" href="#86">86</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> stmtHandle; |
| <a class="jxr_linenumber" name="87" href="#87">87</a> <strong class="jxr_keyword">private</strong> String stmtLabel; |
| <a class="jxr_linenumber" name="88" href="#88">88</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">long</strong> maxRowCnt; |
| <a class="jxr_linenumber" name="89" href="#89">89</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">long</strong> maxRowLen; |
| <a class="jxr_linenumber" name="90" href="#90">90</a> <strong class="jxr_keyword">private</strong> String cursorName; |
| <a class="jxr_linenumber" name="91" href="#91">91</a> <strong class="jxr_keyword">private</strong> String stmtOptions; |
| <a class="jxr_linenumber" name="92" href="#92">92</a> <em class="jxr_comment">//===========================================</em> |
| <a class="jxr_linenumber" name="93" href="#93">93</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> returnCode; |
| <a class="jxr_linenumber" name="94" href="#94">94</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/SQLWarningOrErrorList.html">SQLWarningOrErrorList</a> errorList; |
| <a class="jxr_linenumber" name="95" href="#95">95</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> rowsAffected; |
| <a class="jxr_linenumber" name="96" href="#96">96</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> outValuesFormat; |
| <a class="jxr_linenumber" name="97" href="#97">97</a> <strong class="jxr_keyword">private</strong> byte[] outValues; |
| <a class="jxr_linenumber" name="98" href="#98">98</a> <em class="jxr_comment">//===========================================</em> |
| <a class="jxr_linenumber" name="99" href="#99">99</a> <strong class="jxr_keyword">private</strong> byte[] sqlarray; |
| <a class="jxr_linenumber" name="100" href="#100">100</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">long</strong> totalOutLen; |
| <a class="jxr_linenumber" name="101" href="#101">101</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">long</strong> curOutPos; |
| <a class="jxr_linenumber" name="102" href="#102">102</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">long</strong> curOutNullPos; |
| <a class="jxr_linenumber" name="103" href="#103">103</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">long</strong> rowOffset; |
| <a class="jxr_linenumber" name="104" href="#104">104</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> curRowNumber; |
| <a class="jxr_linenumber" name="105" href="#105">105</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> columnCount; |
| <a class="jxr_linenumber" name="106" href="#106">106</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> columnLength; |
| <a class="jxr_linenumber" name="107" href="#107">107</a> |
| <a class="jxr_linenumber" name="108" href="#108">108</a> <a href="../../../../../org/trafodion/dcs/servermt/serverHandler/ServerApiSqlFetch.html">ServerApiSqlFetch</a>(<strong class="jxr_keyword">int</strong> instance, <strong class="jxr_keyword">int</strong> serverThread) { |
| <a class="jxr_linenumber" name="109" href="#109">109</a> <strong class="jxr_keyword">this</strong>.instance = instance; |
| <a class="jxr_linenumber" name="110" href="#110">110</a> <strong class="jxr_keyword">this</strong>.serverThread = serverThread; |
| <a class="jxr_linenumber" name="111" href="#111">111</a> serverWorkerName = ServerConstants.SERVER_WORKER_NAME + <span class="jxr_string">"_"</span> + instance + <span class="jxr_string">"_"</span> + serverThread; |
| <a class="jxr_linenumber" name="112" href="#112">112</a> } |
| <a class="jxr_linenumber" name="113" href="#113">113</a> <strong class="jxr_keyword">void</strong> init(){ |
| <a class="jxr_linenumber" name="114" href="#114">114</a> reset(); |
| <a class="jxr_linenumber" name="115" href="#115">115</a> } |
| <a class="jxr_linenumber" name="116" href="#116">116</a> <strong class="jxr_keyword">void</strong> reset(){ |
| <a class="jxr_linenumber" name="117" href="#117">117</a> dialogueId = 0; |
| <a class="jxr_linenumber" name="118" href="#118">118</a> sqlAsyncEnable = 0; |
| <a class="jxr_linenumber" name="119" href="#119">119</a> queryTimeout = 0; |
| <a class="jxr_linenumber" name="120" href="#120">120</a> stmtHandle = 0; |
| <a class="jxr_linenumber" name="121" href="#121">121</a> stmtLabel = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="122" href="#122">122</a> maxRowCnt = 0; |
| <a class="jxr_linenumber" name="123" href="#123">123</a> maxRowLen = 0; |
| <a class="jxr_linenumber" name="124" href="#124">124</a> cursorName = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="125" href="#125">125</a> stmtOptions = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="126" href="#126">126</a> |
| <a class="jxr_linenumber" name="127" href="#127">127</a> returnCode = ServerConstants.SQL_SUCCESS; |
| <a class="jxr_linenumber" name="128" href="#128">128</a> errorList = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="129" href="#129">129</a> rowsAffected = 0; |
| <a class="jxr_linenumber" name="130" href="#130">130</a> outValuesFormat = 0; |
| <a class="jxr_linenumber" name="131" href="#131">131</a> outValues = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="132" href="#132">132</a> stmtLabelBytes = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="133" href="#133">133</a> cursorNameBytes = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="134" href="#134">134</a> stmtOptionsBytes = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="135" href="#135">135</a> |
| <a class="jxr_linenumber" name="136" href="#136">136</a> strsmd = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="137" href="#137">137</a> sqlrs = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="138" href="#138">138</a> sqlarray = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="139" href="#139">139</a> totalOutLen = 0; |
| <a class="jxr_linenumber" name="140" href="#140">140</a> curOutPos = 0; |
| <a class="jxr_linenumber" name="141" href="#141">141</a> curOutNullPos = 0; |
| <a class="jxr_linenumber" name="142" href="#142">142</a> curRowNumber = 0; |
| <a class="jxr_linenumber" name="143" href="#143">143</a> columnCount = 0; |
| <a class="jxr_linenumber" name="144" href="#144">144</a> columnDescList = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="145" href="#145">145</a> } |
| <a class="jxr_linenumber" name="146" href="#146">146</a> <a href="../../../../../org/trafodion/dcs/servermt/serverHandler/ClientData.html">ClientData</a> processApi(<a href="../../../../../org/trafodion/dcs/servermt/serverHandler/ClientData.html">ClientData</a> clientData) { |
| <a class="jxr_linenumber" name="147" href="#147">147</a> <strong class="jxr_keyword">this</strong>.clientData = clientData; |
| <a class="jxr_linenumber" name="148" href="#148">148</a> init(); |
| <a class="jxr_linenumber" name="149" href="#149">149</a> <em class="jxr_comment">//</em> |
| <a class="jxr_linenumber" name="150" href="#150">150</a> <em class="jxr_comment">// ==============process input ByteBuffer===========================</em> |
| <a class="jxr_linenumber" name="151" href="#151">151</a> <em class="jxr_comment">//</em> |
| <a class="jxr_linenumber" name="152" href="#152">152</a> ByteBuffer bbHeader = clientData.bbHeader; |
| <a class="jxr_linenumber" name="153" href="#153">153</a> ByteBuffer bbBody = clientData.bbBody; |
| <a class="jxr_linenumber" name="154" href="#154">154</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Header.html">Header</a> hdr = clientData.hdr; |
| <a class="jxr_linenumber" name="155" href="#155">155</a> |
| <a class="jxr_linenumber" name="156" href="#156">156</a> bbHeader.flip(); |
| <a class="jxr_linenumber" name="157" href="#157">157</a> bbBody.flip(); |
| <a class="jxr_linenumber" name="158" href="#158">158</a> |
| <a class="jxr_linenumber" name="159" href="#159">159</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="160" href="#160">160</a> hdr.extractFromByteArray(bbHeader); |
| <a class="jxr_linenumber" name="161" href="#161">161</a> |
| <a class="jxr_linenumber" name="162" href="#162">162</a> dialogueId = bbBody.getInt(); |
| <a class="jxr_linenumber" name="163" href="#163">163</a> sqlAsyncEnable = bbBody.getInt(); |
| <a class="jxr_linenumber" name="164" href="#164">164</a> queryTimeout = bbBody.getInt(); |
| <a class="jxr_linenumber" name="165" href="#165">165</a> stmtHandle = bbBody.getInt(); |
| <a class="jxr_linenumber" name="166" href="#166">166</a> stmtLabel = ByteBufferUtils.extractStringWithCharset(bbBody); |
| <a class="jxr_linenumber" name="167" href="#167">167</a> maxRowCnt = bbBody.getLong(); |
| <a class="jxr_linenumber" name="168" href="#168">168</a> maxRowLen = bbBody.getLong(); |
| <a class="jxr_linenumber" name="169" href="#169">169</a> cursorName = ByteBufferUtils.extractStringWithCharset(bbBody); |
| <a class="jxr_linenumber" name="170" href="#170">170</a> stmtOptions = ByteBufferUtils.extractString(bbBody); |
| <a class="jxr_linenumber" name="171" href="#171">171</a> |
| <a class="jxr_linenumber" name="172" href="#172">172</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()){ |
| <a class="jxr_linenumber" name="173" href="#173">173</a> LOG.debug(serverWorkerName + <span class="jxr_string">". dialogueId :"</span> + dialogueId); |
| <a class="jxr_linenumber" name="174" href="#174">174</a> LOG.debug(serverWorkerName + <span class="jxr_string">". sqlAsyncEnable :"</span> + sqlAsyncEnable); |
| <a class="jxr_linenumber" name="175" href="#175">175</a> LOG.debug(serverWorkerName + <span class="jxr_string">". queryTimeout :"</span> + queryTimeout); |
| <a class="jxr_linenumber" name="176" href="#176">176</a> LOG.debug(serverWorkerName + <span class="jxr_string">". stmtHandle :"</span> + stmtHandle); |
| <a class="jxr_linenumber" name="177" href="#177">177</a> LOG.debug(serverWorkerName + <span class="jxr_string">". stmtLabel :"</span> + stmtLabel); |
| <a class="jxr_linenumber" name="178" href="#178">178</a> LOG.debug(serverWorkerName + <span class="jxr_string">". maxRowCnt :"</span> + maxRowCnt); |
| <a class="jxr_linenumber" name="179" href="#179">179</a> LOG.debug(serverWorkerName + <span class="jxr_string">". maxRowLen :"</span> + maxRowLen); |
| <a class="jxr_linenumber" name="180" href="#180">180</a> LOG.debug(serverWorkerName + <span class="jxr_string">". cursorName :"</span> + cursorName); |
| <a class="jxr_linenumber" name="181" href="#181">181</a> LOG.debug(serverWorkerName + <span class="jxr_string">". stmtOptions :"</span> + stmtOptions); |
| <a class="jxr_linenumber" name="182" href="#182">182</a> } |
| <a class="jxr_linenumber" name="183" href="#183">183</a> <strong class="jxr_keyword">if</strong> (dialogueId < 1 ) { |
| <a class="jxr_linenumber" name="184" href="#184">184</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(serverWorkerName + <span class="jxr_string">". Wrong dialogueId :"</span> + dialogueId); |
| <a class="jxr_linenumber" name="185" href="#185">185</a> } |
| <a class="jxr_linenumber" name="186" href="#186">186</a> <strong class="jxr_keyword">if</strong> (dialogueId != clientData.getDialogueId() ) { |
| <a class="jxr_linenumber" name="187" href="#187">187</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(serverWorkerName + <span class="jxr_string">". Wrong dialogueId sent by the Client [sent/expected] : ["</span> + dialogueId + <span class="jxr_string">"/"</span> + clientData.getDialogueId() + <span class="jxr_string">"]"</span>); |
| <a class="jxr_linenumber" name="188" href="#188">188</a> } |
| <a class="jxr_linenumber" name="189" href="#189">189</a> <em class="jxr_comment">//=========================================================================</em> |
| <a class="jxr_linenumber" name="190" href="#190">190</a> trafConn = clientData.getTrafConnection(); |
| <a class="jxr_linenumber" name="191" href="#191">191</a> trafStmt = trafConn.getTrafStatement(stmtLabel,stmtHandle); |
| <a class="jxr_linenumber" name="192" href="#192">192</a> trafResultSet = trafStmt.getTrafResultSet(); <em class="jxr_comment">// get current result set</em> |
| <a class="jxr_linenumber" name="193" href="#193">193</a> |
| <a class="jxr_linenumber" name="194" href="#194">194</a> rs = trafResultSet.getResultSet(); |
| <a class="jxr_linenumber" name="195" href="#195">195</a> <strong class="jxr_keyword">if</strong> (trafResultSet.isClosed() == <strong class="jxr_keyword">true</strong>){ |
| <a class="jxr_linenumber" name="196" href="#196">196</a> <strong class="jxr_keyword">if</strong>(<strong class="jxr_keyword">true</strong> == trafStmt.getNextTResultSet()){ |
| <a class="jxr_linenumber" name="197" href="#197">197</a> trafResultSet = trafStmt.getTrafResultSet(); |
| <a class="jxr_linenumber" name="198" href="#198">198</a> rs = trafResultSet.getResultSet(); |
| <a class="jxr_linenumber" name="199" href="#199">199</a> } |
| <a class="jxr_linenumber" name="200" href="#200">200</a> } |
| <a class="jxr_linenumber" name="201" href="#201">201</a> <strong class="jxr_keyword">if</strong> (trafResultSet.isClosed() == false){ |
| <a class="jxr_linenumber" name="202" href="#202">202</a> |
| <a class="jxr_linenumber" name="203" href="#203">203</a> columnDescList = trafResultSet.getColumnDescList(); |
| <a class="jxr_linenumber" name="204" href="#204">204</a> maxRowLen = columnDescList.getVarLength(); |
| <a class="jxr_linenumber" name="205" href="#205">205</a> columnCount = columnDescList.getDescCount(); |
| <a class="jxr_linenumber" name="206" href="#206">206</a> |
| <a class="jxr_linenumber" name="207" href="#207">207</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()){ |
| <a class="jxr_linenumber" name="208" href="#208">208</a> LOG.debug(serverWorkerName + <span class="jxr_string">". maxRowLen :"</span> + maxRowLen); |
| <a class="jxr_linenumber" name="209" href="#209">209</a> LOG.debug(serverWorkerName + <span class="jxr_string">". columnCount :"</span> + columnCount); |
| <a class="jxr_linenumber" name="210" href="#210">210</a> } |
| <a class="jxr_linenumber" name="211" href="#211">211</a> returnCode = ServerConstants.SQL_SUCCESS; |
| <a class="jxr_linenumber" name="212" href="#212">212</a> <strong class="jxr_keyword">boolean</strong> closeResultSet = false; |
| <a class="jxr_linenumber" name="213" href="#213">213</a> |
| <a class="jxr_linenumber" name="214" href="#214">214</a> <em class="jxr_comment">//=====================Process ServerApiSqlFetch===========================</em> |
| <a class="jxr_linenumber" name="215" href="#215">215</a> <strong class="jxr_keyword">if</strong> (columnDescList.getOldFormat() == false){ |
| <a class="jxr_linenumber" name="216" href="#216">216</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="217" href="#217">217</a> <strong class="jxr_keyword">while</strong>( rs != <strong class="jxr_keyword">null</strong>){ |
| <a class="jxr_linenumber" name="218" href="#218">218</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a>[] desc = columnDescList.getDescriptors2(); |
| <a class="jxr_linenumber" name="219" href="#219">219</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a> dsc; |
| <a class="jxr_linenumber" name="220" href="#220">220</a> <strong class="jxr_keyword">int</strong> dataType = 0; |
| <a class="jxr_linenumber" name="221" href="#221">221</a> <strong class="jxr_keyword">int</strong> dataMaxLen = 0; |
| <a class="jxr_linenumber" name="222" href="#222">222</a> sqlrs = (SQLMXResultSet)rs; |
| <a class="jxr_linenumber" name="223" href="#223">223</a> <strong class="jxr_keyword">if</strong> (false == rs.next()){ |
| <a class="jxr_linenumber" name="224" href="#224">224</a> closeResultSet = <strong class="jxr_keyword">true</strong>; |
| <a class="jxr_linenumber" name="225" href="#225">225</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="226" href="#226">226</a> LOG.debug(serverWorkerName + <span class="jxr_string">". T2 Fetch.rs.next() false"</span>); |
| <a class="jxr_linenumber" name="227" href="#227">227</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="228" href="#228">228</a> } |
| <a class="jxr_linenumber" name="229" href="#229">229</a> <strong class="jxr_keyword">else</strong>{ |
| <a class="jxr_linenumber" name="230" href="#230">230</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="231" href="#231">231</a> LOG.debug(serverWorkerName + <span class="jxr_string">". T2 Fetch.rs.next() true"</span>); |
| <a class="jxr_linenumber" name="232" href="#232">232</a> } |
| <a class="jxr_linenumber" name="233" href="#233">233</a> <strong class="jxr_keyword">if</strong>(totalOutLen == 0){ |
| <a class="jxr_linenumber" name="234" href="#234">234</a> totalOutLen = maxRowLen * maxRowCnt; |
| <a class="jxr_linenumber" name="235" href="#235">235</a> outValues = <strong class="jxr_keyword">new</strong> byte[(<strong class="jxr_keyword">int</strong>)totalOutLen]; |
| <a class="jxr_linenumber" name="236" href="#236">236</a> } |
| <a class="jxr_linenumber" name="237" href="#237">237</a> rowOffset = maxRowLen * curRowNumber; |
| <a class="jxr_linenumber" name="238" href="#238">238</a> |
| <a class="jxr_linenumber" name="239" href="#239">239</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()){ |
| <a class="jxr_linenumber" name="240" href="#240">240</a> LOG.debug(serverWorkerName + <span class="jxr_string">". curRowNumber :"</span> + curRowNumber + <span class="jxr_string">" maxRowCnt :"</span> + maxRowCnt); |
| <a class="jxr_linenumber" name="241" href="#241">241</a> LOG.debug(serverWorkerName + <span class="jxr_string">". totalOutLen :"</span> + totalOutLen); |
| <a class="jxr_linenumber" name="242" href="#242">242</a> LOG.debug(serverWorkerName + <span class="jxr_string">". rowOffset :"</span> + rowOffset); |
| <a class="jxr_linenumber" name="243" href="#243">243</a> } |
| <a class="jxr_linenumber" name="244" href="#244">244</a> |
| <a class="jxr_linenumber" name="245" href="#245">245</a> <strong class="jxr_keyword">for</strong>(<strong class="jxr_keyword">int</strong> column = 1; column <= columnCount; column++){ |
| <a class="jxr_linenumber" name="246" href="#246">246</a> dsc = desc[column - 1]; |
| <a class="jxr_linenumber" name="247" href="#247">247</a> <strong class="jxr_keyword">int</strong> noNullValueOffset = dsc.getNoNullValue(); |
| <a class="jxr_linenumber" name="248" href="#248">248</a> <strong class="jxr_keyword">int</strong> nullValueOffset = dsc.getNullValue(); |
| <a class="jxr_linenumber" name="249" href="#249">249</a> |
| <a class="jxr_linenumber" name="250" href="#250">250</a> <strong class="jxr_keyword">if</strong> (nullValueOffset != -1) |
| <a class="jxr_linenumber" name="251" href="#251">251</a> nullValueOffset += rowOffset; |
| <a class="jxr_linenumber" name="252" href="#252">252</a> <strong class="jxr_keyword">if</strong> (noNullValueOffset != -1) |
| <a class="jxr_linenumber" name="253" href="#253">253</a> noNullValueOffset += rowOffset; |
| <a class="jxr_linenumber" name="254" href="#254">254</a> |
| <a class="jxr_linenumber" name="255" href="#255">255</a> byte[] sqlarray = sqlrs.getSQLBytes(column); |
| <a class="jxr_linenumber" name="256" href="#256">256</a> <strong class="jxr_keyword">if</strong> (sqlarray == <strong class="jxr_keyword">null</strong>) { |
| <a class="jxr_linenumber" name="257" href="#257">257</a> <strong class="jxr_keyword">short</strong> value = -1; |
| <a class="jxr_linenumber" name="258" href="#258">258</a> outValues[(<strong class="jxr_keyword">int</strong>)nullValueOffset] = (byte) ((value >>> 8) & 0xff); |
| <a class="jxr_linenumber" name="259" href="#259">259</a> outValues[(<strong class="jxr_keyword">int</strong>)(nullValueOffset + 1)] = (byte) ((value) & 0xff); |
| <a class="jxr_linenumber" name="260" href="#260">260</a> } |
| <a class="jxr_linenumber" name="261" href="#261">261</a> <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="262" href="#262">262</a> outValues = SqlUtils.formatSqlT4Output(dsc, sqlarray, noNullValueOffset, outValues, bbBody.order()); |
| <a class="jxr_linenumber" name="263" href="#263">263</a> } |
| <a class="jxr_linenumber" name="264" href="#264">264</a> } |
| <a class="jxr_linenumber" name="265" href="#265">265</a> curRowNumber++; |
| <a class="jxr_linenumber" name="266" href="#266">266</a> <strong class="jxr_keyword">if</strong> (curRowNumber == maxRowCnt) |
| <a class="jxr_linenumber" name="267" href="#267">267</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="268" href="#268">268</a> } |
| <a class="jxr_linenumber" name="269" href="#269">269</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex){ |
| <a class="jxr_linenumber" name="270" href="#270">270</a> LOG.error(serverWorkerName + <span class="jxr_string">". Fetch.SQLException "</span> + ex); |
| <a class="jxr_linenumber" name="271" href="#271">271</a> errorList = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/SQLWarningOrErrorList.html">SQLWarningOrErrorList</a>(ex); |
| <a class="jxr_linenumber" name="272" href="#272">272</a> returnCode = errorList.getReturnCode(); |
| <a class="jxr_linenumber" name="273" href="#273">273</a> } |
| <a class="jxr_linenumber" name="274" href="#274">274</a> rowsAffected = curRowNumber; |
| <a class="jxr_linenumber" name="275" href="#275">275</a> <strong class="jxr_keyword">if</strong> (rowsAffected != maxRowCnt && rowsAffected != 0){ |
| <a class="jxr_linenumber" name="276" href="#276">276</a> <strong class="jxr_keyword">int</strong> len = (<strong class="jxr_keyword">int</strong>)(rowsAffected * maxRowLen); |
| <a class="jxr_linenumber" name="277" href="#277">277</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()){ |
| <a class="jxr_linenumber" name="278" href="#278">278</a> LOG.debug(serverWorkerName + <span class="jxr_string">". len :"</span> + len); |
| <a class="jxr_linenumber" name="279" href="#279">279</a> } |
| <a class="jxr_linenumber" name="280" href="#280">280</a> byte[] dst = <strong class="jxr_keyword">new</strong> byte[len]; |
| <a class="jxr_linenumber" name="281" href="#281">281</a> System.arraycopy(outValues, 0, dst, 0, len); |
| <a class="jxr_linenumber" name="282" href="#282">282</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()){ |
| <a class="jxr_linenumber" name="283" href="#283">283</a> LOG.debug(serverWorkerName + <span class="jxr_string">". dst :"</span> + Arrays.toString(dst)); |
| <a class="jxr_linenumber" name="284" href="#284">284</a> } |
| <a class="jxr_linenumber" name="285" href="#285">285</a> outValues = dst; |
| <a class="jxr_linenumber" name="286" href="#286">286</a> } |
| <a class="jxr_linenumber" name="287" href="#287">287</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="288" href="#288">288</a> LOG.debug(serverWorkerName + <span class="jxr_string">". closeResultSet"</span>); |
| <a class="jxr_linenumber" name="289" href="#289">289</a> <strong class="jxr_keyword">if</strong> (closeResultSet == <strong class="jxr_keyword">true</strong>) |
| <a class="jxr_linenumber" name="290" href="#290">290</a> trafStmt.closeTResultSet(); |
| <a class="jxr_linenumber" name="291" href="#291">291</a> } |
| <a class="jxr_linenumber" name="292" href="#292">292</a> <em class="jxr_comment">//---------------------------------------------------------------------------------------------</em> |
| <a class="jxr_linenumber" name="293" href="#293">293</a> <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="294" href="#294">294</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="295" href="#295">295</a> LOG.debug(serverWorkerName + <span class="jxr_string">". Processing old format result set"</span>); |
| <a class="jxr_linenumber" name="296" href="#296">296</a> <strong class="jxr_keyword">int</strong> byteIndex = 0; |
| <a class="jxr_linenumber" name="297" href="#297">297</a> |
| <a class="jxr_linenumber" name="298" href="#298">298</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="299" href="#299">299</a> <strong class="jxr_keyword">while</strong>( rs != <strong class="jxr_keyword">null</strong>){ |
| <a class="jxr_linenumber" name="300" href="#300">300</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a>[] desc = columnDescList.getDescriptors2(); |
| <a class="jxr_linenumber" name="301" href="#301">301</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a> dsc; |
| <a class="jxr_linenumber" name="302" href="#302">302</a> <strong class="jxr_keyword">int</strong> dataType = 0; |
| <a class="jxr_linenumber" name="303" href="#303">303</a> <strong class="jxr_keyword">int</strong> dataMaxLen = 0; |
| <a class="jxr_linenumber" name="304" href="#304">304</a> sqlrs = (SQLMXResultSet)rs; |
| <a class="jxr_linenumber" name="305" href="#305">305</a> <strong class="jxr_keyword">if</strong> (false == rs.next()){ |
| <a class="jxr_linenumber" name="306" href="#306">306</a> closeResultSet = <strong class="jxr_keyword">true</strong>; |
| <a class="jxr_linenumber" name="307" href="#307">307</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="308" href="#308">308</a> LOG.debug(serverWorkerName + <span class="jxr_string">". T2 Fetch.rs.next() false"</span>); |
| <a class="jxr_linenumber" name="309" href="#309">309</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="310" href="#310">310</a> } |
| <a class="jxr_linenumber" name="311" href="#311">311</a> <strong class="jxr_keyword">else</strong>{ |
| <a class="jxr_linenumber" name="312" href="#312">312</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="313" href="#313">313</a> LOG.debug(serverWorkerName + <span class="jxr_string">". T2 Fetch.rs.next() true"</span>); |
| <a class="jxr_linenumber" name="314" href="#314">314</a> } |
| <a class="jxr_linenumber" name="315" href="#315">315</a> <strong class="jxr_keyword">if</strong>(totalOutLen == 0){ |
| <a class="jxr_linenumber" name="316" href="#316">316</a> byteIndex = 0; |
| <a class="jxr_linenumber" name="317" href="#317">317</a> totalOutLen = maxRowLen * maxRowCnt; |
| <a class="jxr_linenumber" name="318" href="#318">318</a> outValues = <strong class="jxr_keyword">new</strong> byte[(<strong class="jxr_keyword">int</strong>)totalOutLen]; |
| <a class="jxr_linenumber" name="319" href="#319">319</a> } |
| <a class="jxr_linenumber" name="320" href="#320">320</a> byte[] sqlarray = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="321" href="#321">321</a> <strong class="jxr_keyword">short</strong> SQLDataInd = 0; |
| <a class="jxr_linenumber" name="322" href="#322">322</a> |
| <a class="jxr_linenumber" name="323" href="#323">323</a> <strong class="jxr_keyword">for</strong>(<strong class="jxr_keyword">int</strong> column = 1; column <= columnCount; column++){ |
| <a class="jxr_linenumber" name="324" href="#324">324</a> dsc = desc[column - 1]; |
| <a class="jxr_linenumber" name="325" href="#325">325</a> sqlarray = sqlrs.getSQLBytes(column); |
| <a class="jxr_linenumber" name="326" href="#326">326</a> <strong class="jxr_keyword">if</strong> (sqlarray != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="327" href="#327">327</a> SQLDataInd = 0; |
| <a class="jxr_linenumber" name="328" href="#328">328</a> <strong class="jxr_keyword">else</strong> |
| <a class="jxr_linenumber" name="329" href="#329">329</a> SQLDataInd = -1; |
| <a class="jxr_linenumber" name="330" href="#330">330</a> |
| <a class="jxr_linenumber" name="331" href="#331">331</a> outValues[byteIndex++] = (byte) (SQLDataInd); |
| <a class="jxr_linenumber" name="332" href="#332">332</a> <strong class="jxr_keyword">if</strong> (SQLDataInd == 0){ |
| <a class="jxr_linenumber" name="333" href="#333">333</a> ByteBuffer tb = ByteBuffer.wrap(sqlarray).order(bbBody.order()); |
| <a class="jxr_linenumber" name="334" href="#334">334</a> <strong class="jxr_keyword">int</strong> allocLength = sqlarray.length; |
| <a class="jxr_linenumber" name="335" href="#335">335</a> |
| <a class="jxr_linenumber" name="336" href="#336">336</a> <strong class="jxr_keyword">switch</strong> (dsc.getDataType()) { |
| <a class="jxr_linenumber" name="337" href="#337">337</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR_WITH_LENGTH: |
| <a class="jxr_linenumber" name="338" href="#338">338</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR_LONG: |
| <a class="jxr_linenumber" name="339" href="#339">339</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_BITVAR: |
| <a class="jxr_linenumber" name="340" href="#340">340</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR: |
| <a class="jxr_linenumber" name="341" href="#341">341</a> <strong class="jxr_keyword">boolean</strong> shortLength = dsc.getPrecision() < Math.pow(2, 15); |
| <a class="jxr_linenumber" name="342" href="#342">342</a> allocLength = (shortLength) ? tb.getShort() + 2 : tb.getInt() + 4; |
| <a class="jxr_linenumber" name="343" href="#343">343</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="344" href="#344">344</a> } |
| <a class="jxr_linenumber" name="345" href="#345">345</a> System.arraycopy(sqlarray, 0, outValues, (<strong class="jxr_keyword">int</strong>)byteIndex, allocLength); |
| <a class="jxr_linenumber" name="346" href="#346">346</a> |
| <a class="jxr_linenumber" name="347" href="#347">347</a> byteIndex = byteIndex + allocLength; |
| <a class="jxr_linenumber" name="348" href="#348">348</a> |
| <a class="jxr_linenumber" name="349" href="#349">349</a> <strong class="jxr_keyword">switch</strong> (dsc.getDataType()) { |
| <a class="jxr_linenumber" name="350" href="#350">350</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR_WITH_LENGTH: |
| <a class="jxr_linenumber" name="351" href="#351">351</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR_LONG: |
| <a class="jxr_linenumber" name="352" href="#352">352</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_BITVAR: |
| <a class="jxr_linenumber" name="353" href="#353">353</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR: |
| <a class="jxr_linenumber" name="354" href="#354">354</a> byteIndex++; |
| <a class="jxr_linenumber" name="355" href="#355">355</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="356" href="#356">356</a> } |
| <a class="jxr_linenumber" name="357" href="#357">357</a> } |
| <a class="jxr_linenumber" name="358" href="#358">358</a> } |
| <a class="jxr_linenumber" name="359" href="#359">359</a> curRowNumber++; |
| <a class="jxr_linenumber" name="360" href="#360">360</a> <strong class="jxr_keyword">if</strong> (curRowNumber == maxRowCnt) |
| <a class="jxr_linenumber" name="361" href="#361">361</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="362" href="#362">362</a> } |
| <a class="jxr_linenumber" name="363" href="#363">363</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex){ |
| <a class="jxr_linenumber" name="364" href="#364">364</a> LOG.error(serverWorkerName + <span class="jxr_string">". Fetch.SQLException "</span> + ex); |
| <a class="jxr_linenumber" name="365" href="#365">365</a> errorList = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/SQLWarningOrErrorList.html">SQLWarningOrErrorList</a>(ex); |
| <a class="jxr_linenumber" name="366" href="#366">366</a> returnCode = errorList.getReturnCode(); |
| <a class="jxr_linenumber" name="367" href="#367">367</a> } |
| <a class="jxr_linenumber" name="368" href="#368">368</a> rowsAffected = curRowNumber; |
| <a class="jxr_linenumber" name="369" href="#369">369</a> <strong class="jxr_keyword">if</strong> (rowsAffected != maxRowCnt && rowsAffected != 0){ |
| <a class="jxr_linenumber" name="370" href="#370">370</a> <strong class="jxr_keyword">int</strong> len = byteIndex; |
| <a class="jxr_linenumber" name="371" href="#371">371</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()){ |
| <a class="jxr_linenumber" name="372" href="#372">372</a> LOG.debug(serverWorkerName + <span class="jxr_string">". len :"</span> + len); |
| <a class="jxr_linenumber" name="373" href="#373">373</a> } |
| <a class="jxr_linenumber" name="374" href="#374">374</a> byte[] dst = <strong class="jxr_keyword">new</strong> byte[len]; |
| <a class="jxr_linenumber" name="375" href="#375">375</a> System.arraycopy(outValues, 0, dst, 0, len); |
| <a class="jxr_linenumber" name="376" href="#376">376</a> outValues = dst; |
| <a class="jxr_linenumber" name="377" href="#377">377</a> } |
| <a class="jxr_linenumber" name="378" href="#378">378</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="379" href="#379">379</a> LOG.debug(serverWorkerName + <span class="jxr_string">". closeResultSet before"</span>); |
| <a class="jxr_linenumber" name="380" href="#380">380</a> <strong class="jxr_keyword">if</strong> (closeResultSet == <strong class="jxr_keyword">true</strong>) |
| <a class="jxr_linenumber" name="381" href="#381">381</a> trafResultSet.closeTResultSet(); |
| <a class="jxr_linenumber" name="382" href="#382">382</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="383" href="#383">383</a> LOG.debug(serverWorkerName + <span class="jxr_string">". closeResultSet after"</span>); |
| <a class="jxr_linenumber" name="384" href="#384">384</a> } |
| <a class="jxr_linenumber" name="385" href="#385">385</a> } |
| <a class="jxr_linenumber" name="386" href="#386">386</a> <em class="jxr_comment">//</em> |
| <a class="jxr_linenumber" name="387" href="#387">387</a> <em class="jxr_comment">//===================calculate length of output ByteBuffer========================</em> |
| <a class="jxr_linenumber" name="388" href="#388">388</a> <em class="jxr_comment">//</em> |
| <a class="jxr_linenumber" name="389" href="#389">389</a> bbHeader.clear(); |
| <a class="jxr_linenumber" name="390" href="#390">390</a> bbBody.clear(); |
| <a class="jxr_linenumber" name="391" href="#391">391</a> <em class="jxr_comment">//</em> |
| <a class="jxr_linenumber" name="392" href="#392">392</a> <em class="jxr_comment">// check if ByteBuffer is big enough for output</em> |
| <a class="jxr_linenumber" name="393" href="#393">393</a> <em class="jxr_comment">//</em> |
| <a class="jxr_linenumber" name="394" href="#394">394</a> <strong class="jxr_keyword">if</strong>(rowsAffected == 0 && returnCode == ServerConstants.SQL_SUCCESS){ |
| <a class="jxr_linenumber" name="395" href="#395">395</a> returnCode = ServerConstants.SQL_NO_DATA_FOUND; |
| <a class="jxr_linenumber" name="396" href="#396">396</a> } |
| <a class="jxr_linenumber" name="397" href="#397">397</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="398" href="#398">398</a> LOG.debug(serverWorkerName + <span class="jxr_string">". returnCode :"</span> + returnCode); |
| <a class="jxr_linenumber" name="399" href="#399">399</a> |
| <a class="jxr_linenumber" name="400" href="#400">400</a> <strong class="jxr_keyword">int</strong> dataLength = ServerConstants.INT_FIELD_SIZE; <em class="jxr_comment">//returnCode</em> |
| <a class="jxr_linenumber" name="401" href="#401">401</a> |
| <a class="jxr_linenumber" name="402" href="#402">402</a> <strong class="jxr_keyword">if</strong> (returnCode != ServerConstants.SQL_SUCCESS && returnCode != ServerConstants.SQL_NO_DATA_FOUND) { |
| <a class="jxr_linenumber" name="403" href="#403">403</a> dataLength += ServerConstants.INT_FIELD_SIZE; <em class="jxr_comment">//totalErrorLength</em> |
| <a class="jxr_linenumber" name="404" href="#404">404</a> <strong class="jxr_keyword">if</strong> (errorList != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="405" href="#405">405</a> dataLength += errorList.lengthOfData(); |
| <a class="jxr_linenumber" name="406" href="#406">406</a> <strong class="jxr_keyword">else</strong> |
| <a class="jxr_linenumber" name="407" href="#407">407</a> dataLength += ServerConstants.INT_FIELD_SIZE; <em class="jxr_comment">//totalErrorLength = 0</em> |
| <a class="jxr_linenumber" name="408" href="#408">408</a> } |
| <a class="jxr_linenumber" name="409" href="#409">409</a> dataLength += ServerConstants.INT_FIELD_SIZE; <em class="jxr_comment">//rowsAffected</em> |
| <a class="jxr_linenumber" name="410" href="#410">410</a> dataLength += ServerConstants.INT_FIELD_SIZE; <em class="jxr_comment">//outValuesFormat</em> |
| <a class="jxr_linenumber" name="411" href="#411">411</a> <strong class="jxr_keyword">if</strong> (returnCode == ServerConstants.SQL_SUCCESS || returnCode == ServerConstants.SQL_SUCCESS_WITH_INFO) |
| <a class="jxr_linenumber" name="412" href="#412">412</a> dataLength += ByteBufferUtils.lengthOfByteArray(outValues); |
| <a class="jxr_linenumber" name="413" href="#413">413</a> |
| <a class="jxr_linenumber" name="414" href="#414">414</a> <strong class="jxr_keyword">int</strong> availableBuffer = bbBody.capacity() - bbBody.position(); |
| <a class="jxr_linenumber" name="415" href="#415">415</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="416" href="#416">416</a> LOG.debug(serverWorkerName + <span class="jxr_string">". dataLength :"</span> + dataLength + <span class="jxr_string">" availableBuffer :"</span> + availableBuffer); |
| <a class="jxr_linenumber" name="417" href="#417">417</a> <strong class="jxr_keyword">if</strong> (dataLength > availableBuffer ) |
| <a class="jxr_linenumber" name="418" href="#418">418</a> bbBody = ByteBufferUtils.increaseCapacity(bbBody, dataLength > ServerConstants.BODY_SIZE ? dataLength : ServerConstants.BODY_SIZE ); |
| <a class="jxr_linenumber" name="419" href="#419">419</a> |
| <a class="jxr_linenumber" name="420" href="#420">420</a> <em class="jxr_comment">//===================== build output ==============================================</em> |
| <a class="jxr_linenumber" name="421" href="#421">421</a> bbBody.putInt(returnCode); |
| <a class="jxr_linenumber" name="422" href="#422">422</a> |
| <a class="jxr_linenumber" name="423" href="#423">423</a> <strong class="jxr_keyword">if</strong> (returnCode != ServerConstants.SQL_SUCCESS && returnCode != ServerConstants.SQL_NO_DATA_FOUND) { |
| <a class="jxr_linenumber" name="424" href="#424">424</a> <strong class="jxr_keyword">if</strong> (errorList != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="425" href="#425">425</a> errorList.insertIntoByteBuffer(bbBody); |
| <a class="jxr_linenumber" name="426" href="#426">426</a> <strong class="jxr_keyword">else</strong> |
| <a class="jxr_linenumber" name="427" href="#427">427</a> bbBody.putInt(0); |
| <a class="jxr_linenumber" name="428" href="#428">428</a> } |
| <a class="jxr_linenumber" name="429" href="#429">429</a> bbBody.putInt(rowsAffected); |
| <a class="jxr_linenumber" name="430" href="#430">430</a> bbBody.putInt(ServerConstants.ROWWISE_ROWSETS); |
| <a class="jxr_linenumber" name="431" href="#431">431</a> <strong class="jxr_keyword">if</strong> (returnCode == ServerConstants.SQL_SUCCESS || returnCode == ServerConstants.SQL_SUCCESS_WITH_INFO) |
| <a class="jxr_linenumber" name="432" href="#432">432</a> ByteBufferUtils.insertByteArray(outValues, bbBody); |
| <a class="jxr_linenumber" name="433" href="#433">433</a> |
| <a class="jxr_linenumber" name="434" href="#434">434</a> bbBody.flip(); |
| <a class="jxr_linenumber" name="435" href="#435">435</a> <em class="jxr_comment">//=========================Update header================================</em> |
| <a class="jxr_linenumber" name="436" href="#436">436</a> hdr.setTotalLength(bbBody.limit()); |
| <a class="jxr_linenumber" name="437" href="#437">437</a> hdr.insertIntoByteBuffer(bbHeader); |
| <a class="jxr_linenumber" name="438" href="#438">438</a> bbHeader.flip(); |
| <a class="jxr_linenumber" name="439" href="#439">439</a> |
| <a class="jxr_linenumber" name="440" href="#440">440</a> clientData.setByteBufferArray(bbHeader, bbBody); |
| <a class="jxr_linenumber" name="441" href="#441">441</a> clientData.setHdr(hdr); |
| <a class="jxr_linenumber" name="442" href="#442">442</a> clientData.setRequest(ServerConstants.REQUST_WRITE_READ); |
| <a class="jxr_linenumber" name="443" href="#443">443</a> } <strong class="jxr_keyword">catch</strong> (UnsupportedEncodingException ue){ |
| <a class="jxr_linenumber" name="444" href="#444">444</a> LOG.error(serverWorkerName + <span class="jxr_string">". Fetch.UnsupportedEncodingException :"</span> + ue); |
| <a class="jxr_linenumber" name="445" href="#445">445</a> clientData.setRequestAndDisconnect(); |
| <a class="jxr_linenumber" name="446" href="#446">446</a> } <strong class="jxr_keyword">catch</strong> (Exception e){ |
| <a class="jxr_linenumber" name="447" href="#447">447</a> LOG.error(serverWorkerName + <span class="jxr_string">". Fetch.Exception :"</span> + e); |
| <a class="jxr_linenumber" name="448" href="#448">448</a> clientData.setRequestAndDisconnect(); |
| <a class="jxr_linenumber" name="449" href="#449">449</a> } |
| <a class="jxr_linenumber" name="450" href="#450">450</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="451" href="#451">451</a> LOG.debug(serverWorkerName + <span class="jxr_string">". Fetch exit: returnCode :"</span> + returnCode + <span class="jxr_string">" rowsAffected :"</span> + rowsAffected ); |
| <a class="jxr_linenumber" name="452" href="#452">452</a> reset(); |
| <a class="jxr_linenumber" name="453" href="#453">453</a> |
| <a class="jxr_linenumber" name="454" href="#454">454</a> <strong class="jxr_keyword">return</strong> clientData; |
| <a class="jxr_linenumber" name="455" href="#455">455</a> } |
| <a class="jxr_linenumber" name="456" href="#456">456</a> } |
| </pre> |
| <hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body> |
| </html> |
| |
