You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/02/02 23:33:39 UTC
[31/42] incubator-trafodion-site git commit: [TRAFODION-1699] PR 294
Web site now points to Contributors Guide on wiki
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/984ef15b/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/servermt/serverHandler/ServerApiSqlExecute.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/servermt/serverHandler/ServerApiSqlExecute.html b/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/servermt/serverHandler/ServerApiSqlExecute.html
index b808480..847e45e 100644
--- a/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/servermt/serverHandler/ServerApiSqlExecute.html
+++ b/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/servermt/serverHandler/ServerApiSqlExecute.html
@@ -315,552 +315,553 @@
<a class="jxr_linenumber" name="305" href="#305">305</a> rs = pstmt.executeQuery();
<a class="jxr_linenumber" name="306" href="#306">306</a> <strong class="jxr_keyword">if</strong> (rs != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="307" href="#307">307</a> outDescList = trafStmt.getOutDescList();
-<a class="jxr_linenumber" name="308" href="#308">308</a> trafStmt.addTResultSet(<strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverSql/TrafResultSet.html">TrafResultSet</a>(rs, 0, stmtLabel, 0, trafStmt.getOutDescList(),<span class="jxr_string">""</span>));
-<a class="jxr_linenumber" name="309" href="#309">309</a> }
-<a class="jxr_linenumber" name="310" href="#310">310</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (isSpj == <strong class="jxr_keyword">true</strong>) {
-<a class="jxr_linenumber" name="311" href="#311">311</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="312" href="#312">312</a> LOG.debug(serverWorkerName + <span class="jxr_string">". SPJ T2 Execute.execute()"</span>);
-<a class="jxr_linenumber" name="313" href="#313">313</a> <strong class="jxr_keyword">boolean</strong> rsAvailable = cstmt.execute();
-<a class="jxr_linenumber" name="314" href="#314">314</a> <strong class="jxr_keyword">if</strong> (regParamCount > 0) { <em class="jxr_comment">//out, inout parameters</em>
-<a class="jxr_linenumber" name="315" href="#315">315</a> rowsAffected = 1;
-<a class="jxr_linenumber" name="316" href="#316">316</a> outValuesLength = (<strong class="jxr_keyword">int</strong>)paramLength;
-<a class="jxr_linenumber" name="317" href="#317">317</a> outValues = <strong class="jxr_keyword">new</strong> byte[outValuesLength];
-<a class="jxr_linenumber" name="318" href="#318">318</a> outValues = buildOutValues(paramDescList, outValues, paramCount, cstmt, bbBody.order());
-<a class="jxr_linenumber" name="319" href="#319">319</a> }
-<a class="jxr_linenumber" name="320" href="#320">320</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="321" href="#321">321</a> LOG.debug(serverWorkerName + <span class="jxr_string">". SPJ T2 Execute.rsAvailable :"</span> + rsAvailable);
-<a class="jxr_linenumber" name="322" href="#322">322</a> <strong class="jxr_keyword">if</strong> (rsAvailable == <strong class="jxr_keyword">true</strong>) {
-<a class="jxr_linenumber" name="323" href="#323">323</a> setMultipleResultSets(cstmt);
-<a class="jxr_linenumber" name="324" href="#324">324</a> }
-<a class="jxr_linenumber" name="325" href="#325">325</a> } <strong class="jxr_keyword">else</strong> {
-<a class="jxr_linenumber" name="326" href="#326">326</a> resultSetCount = 0;
-<a class="jxr_linenumber" name="327" href="#327">327</a> rowsAffected = pstmt.executeUpdate();
-<a class="jxr_linenumber" name="328" href="#328">328</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="329" href="#329">329</a> LOG.debug(serverWorkerName + <span class="jxr_string">". T2 Execute.executeUpdate() rowsAffected :"</span> + rowsAffected);
-<a class="jxr_linenumber" name="330" href="#330">330</a> }
-<a class="jxr_linenumber" name="331" href="#331">331</a> } <strong class="jxr_keyword">catch</strong> (BatchUpdateException bex) {
-<a class="jxr_linenumber" name="332" href="#332">332</a> LOG.error(serverWorkerName + <span class="jxr_string">". Execute.BatchUpdateException "</span> + bex);
-<a class="jxr_linenumber" name="333" href="#333">333</a> errorList = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/SQLWarningOrErrorList.html">SQLWarningOrErrorList</a>(bex, bex.getUpdateCounts());
-<a class="jxr_linenumber" name="334" href="#334">334</a> returnCode = errorList.getReturnCode();
-<a class="jxr_linenumber" name="335" href="#335">335</a>
-<a class="jxr_linenumber" name="336" href="#336">336</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
-<a class="jxr_linenumber" name="337" href="#337">337</a> LOG.error(serverWorkerName + <span class="jxr_string">". Execute.SQLException "</span> + ex);
-<a class="jxr_linenumber" name="338" href="#338">338</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="339" href="#339">339</a> returnCode = errorList.getReturnCode();
-<a class="jxr_linenumber" name="340" href="#340">340</a> }
-<a class="jxr_linenumber" name="341" href="#341">341</a> <strong class="jxr_keyword">if</strong> (sqlString.isEmpty() == false)
-<a class="jxr_linenumber" name="342" href="#342">342</a> sqlQueryType = SqlUtils.getSqlStmtType(sqlString);
-<a class="jxr_linenumber" name="343" href="#343">343</a> <strong class="jxr_keyword">else</strong>
-<a class="jxr_linenumber" name="344" href="#344">344</a> sqlQueryType = SqlUtils.getSqlStmtType(sqlStmtType);
-<a class="jxr_linenumber" name="345" href="#345">345</a> <em class="jxr_comment">//</em>
-<a class="jxr_linenumber" name="346" href="#346">346</a> <em class="jxr_comment">//===================calculate length of output ByteBuffer========================</em>
-<a class="jxr_linenumber" name="347" href="#347">347</a> <em class="jxr_comment">//</em>
-<a class="jxr_linenumber" name="348" href="#348">348</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="349" href="#349">349</a> LOG.debug(serverWorkerName + <span class="jxr_string">". calculate length of output ByteBuffer"</span>);
-<a class="jxr_linenumber" name="350" href="#350">350</a> bbHeader.clear();
-<a class="jxr_linenumber" name="351" href="#351">351</a> bbBody.clear();
-<a class="jxr_linenumber" name="352" href="#352">352</a> <em class="jxr_comment">//</em>
-<a class="jxr_linenumber" name="353" href="#353">353</a> <em class="jxr_comment">// check if ByteBuffer is big enough for output</em>
-<a class="jxr_linenumber" name="354" href="#354">354</a> <em class="jxr_comment">//</em>
-<a class="jxr_linenumber" name="355" href="#355">355</a> <a href="../../../../../org/trafodion/dcs/servermt/serverSql/TrafResultSet.html">TrafResultSet</a> trs = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="356" href="#356">356</a>
-<a class="jxr_linenumber" name="357" href="#357">357</a> <strong class="jxr_keyword">int</strong> dataLength = ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//returnCode</em>
-<a class="jxr_linenumber" name="358" href="#358">358</a> <strong class="jxr_keyword">if</strong> (errorList != <strong class="jxr_keyword">null</strong>)
-<a class="jxr_linenumber" name="359" href="#359">359</a> dataLength += errorList.lengthOfData();
-<a class="jxr_linenumber" name="360" href="#360">360</a> <strong class="jxr_keyword">else</strong>
-<a class="jxr_linenumber" name="361" href="#361">361</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//totalErrorLength = 0</em>
-<a class="jxr_linenumber" name="362" href="#362">362</a>
-<a class="jxr_linenumber" name="363" href="#363">363</a> <strong class="jxr_keyword">if</strong> (outDescList != <strong class="jxr_keyword">null</strong>)
-<a class="jxr_linenumber" name="364" href="#364">364</a> dataLength += outDescList.lengthOfData();
-<a class="jxr_linenumber" name="365" href="#365">365</a> <strong class="jxr_keyword">else</strong>
-<a class="jxr_linenumber" name="366" href="#366">366</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//outDescLength = 0</em>
-<a class="jxr_linenumber" name="367" href="#367">367</a>
-<a class="jxr_linenumber" name="368" href="#368">368</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//rowsAffected</em>
-<a class="jxr_linenumber" name="369" href="#369">369</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//sqlQueryType</em>
-<a class="jxr_linenumber" name="370" href="#370">370</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//estimatedCost</em>
-<a class="jxr_linenumber" name="371" href="#371">371</a> dataLength += ByteBufferUtils.lengthOfByteArray(outValues);<em class="jxr_comment">//outValues</em>
-<a class="jxr_linenumber" name="372" href="#372">372</a>
-<a class="jxr_linenumber" name="373" href="#373">373</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">// SPJ Result Sets</em>
-<a class="jxr_linenumber" name="374" href="#374">374</a> <strong class="jxr_keyword">if</strong> (resultSetCount > 0) {
-<a class="jxr_linenumber" name="375" href="#375">375</a> <strong class="jxr_keyword">boolean</strong> bNextResultSet = <strong class="jxr_keyword">true</strong>;
-<a class="jxr_linenumber" name="376" href="#376">376</a> trafStmt.setFirstTResultSet();
-<a class="jxr_linenumber" name="377" href="#377">377</a> <strong class="jxr_keyword">while</strong> (bNextResultSet) {
-<a class="jxr_linenumber" name="378" href="#378">378</a> trs = trafStmt.getTrafResultSet();
-<a class="jxr_linenumber" name="379" href="#379">379</a> dataLength += trs.lengthOfData();
-<a class="jxr_linenumber" name="380" href="#380">380</a> bNextResultSet = trafStmt.getNextTResultSet();
-<a class="jxr_linenumber" name="381" href="#381">381</a> }
-<a class="jxr_linenumber" name="382" href="#382">382</a> }
-<a class="jxr_linenumber" name="383" href="#383">383</a> dataLength += ByteBufferUtils.lengthOfString(singleSyntax);
-<a class="jxr_linenumber" name="384" href="#384">384</a>
-<a class="jxr_linenumber" name="385" href="#385">385</a> <strong class="jxr_keyword">int</strong> availableBuffer = bbBody.capacity() - bbBody.position();
-<a class="jxr_linenumber" name="386" href="#386">386</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="387" href="#387">387</a> LOG.debug(serverWorkerName + <span class="jxr_string">". dataLength :"</span> + dataLength + <span class="jxr_string">" availableBuffer :"</span> + availableBuffer);
-<a class="jxr_linenumber" name="388" href="#388">388</a> <strong class="jxr_keyword">if</strong> (dataLength > availableBuffer )
-<a class="jxr_linenumber" name="389" href="#389">389</a> bbBody = ByteBufferUtils.increaseCapacity(bbBody, dataLength > ServerConstants.BODY_SIZE ? dataLength : ServerConstants.BODY_SIZE );
-<a class="jxr_linenumber" name="390" href="#390">390</a> <em class="jxr_comment">//</em>
-<a class="jxr_linenumber" name="391" href="#391">391</a> <em class="jxr_comment">//===================== build output ==============================================</em>
-<a class="jxr_linenumber" name="392" href="#392">392</a> <em class="jxr_comment">//</em>
-<a class="jxr_linenumber" name="393" href="#393">393</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) {
-<a class="jxr_linenumber" name="394" href="#394">394</a> LOG.debug(serverWorkerName + <span class="jxr_string">". returnCode :"</span> + returnCode);
-<a class="jxr_linenumber" name="395" href="#395">395</a> LOG.debug(serverWorkerName + <span class="jxr_string">". errorList :"</span> + errorList);
-<a class="jxr_linenumber" name="396" href="#396">396</a> LOG.debug(serverWorkerName + <span class="jxr_string">". outDescList :"</span> + outDescList);
-<a class="jxr_linenumber" name="397" href="#397">397</a> LOG.debug(serverWorkerName + <span class="jxr_string">". rowsAffected :"</span> + rowsAffected);
-<a class="jxr_linenumber" name="398" href="#398">398</a> LOG.debug(serverWorkerName + <span class="jxr_string">". sqlQueryType :"</span> + sqlQueryType);
-<a class="jxr_linenumber" name="399" href="#399">399</a> LOG.debug(serverWorkerName + <span class="jxr_string">". estimatedCost :"</span> + estimatedCost);
-<a class="jxr_linenumber" name="400" href="#400">400</a> LOG.debug(serverWorkerName + <span class="jxr_string">". outValues :"</span> + outValues);
-<a class="jxr_linenumber" name="401" href="#401">401</a> LOG.debug(serverWorkerName + <span class="jxr_string">". SPJ Result Sets :"</span> + resultSetCount);
-<a class="jxr_linenumber" name="402" href="#402">402</a> LOG.debug(serverWorkerName + <span class="jxr_string">". singleSyntax :"</span> + singleSyntax);
-<a class="jxr_linenumber" name="403" href="#403">403</a> }
-<a class="jxr_linenumber" name="404" href="#404">404</a> bbBody.putInt(returnCode);
-<a class="jxr_linenumber" name="405" href="#405">405</a> <strong class="jxr_keyword">if</strong> (errorList != <strong class="jxr_keyword">null</strong>)
-<a class="jxr_linenumber" name="406" href="#406">406</a> errorList.insertIntoByteBuffer(bbBody);
-<a class="jxr_linenumber" name="407" href="#407">407</a> <strong class="jxr_keyword">else</strong>
-<a class="jxr_linenumber" name="408" href="#408">408</a> bbBody.putInt(0);
-<a class="jxr_linenumber" name="409" href="#409">409</a>
-<a class="jxr_linenumber" name="410" href="#410">410</a> <strong class="jxr_keyword">if</strong> (outDescList != <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="411" href="#411">411</a> outDescList.insertIntoByteBuffer(bbBody);
-<a class="jxr_linenumber" name="412" href="#412">412</a> } <strong class="jxr_keyword">else</strong>
-<a class="jxr_linenumber" name="413" href="#413">413</a> bbBody.putInt(0);
-<a class="jxr_linenumber" name="414" href="#414">414</a>
-<a class="jxr_linenumber" name="415" href="#415">415</a> ByteBufferUtils.insertUInt(rowsAffected, bbBody);
-<a class="jxr_linenumber" name="416" href="#416">416</a> bbBody.putInt(sqlQueryType);
-<a class="jxr_linenumber" name="417" href="#417">417</a> bbBody.putInt(estimatedCost);
-<a class="jxr_linenumber" name="418" href="#418">418</a> ByteBufferUtils.insertByteArray(outValues, bbBody); <em class="jxr_comment">//outValues</em>
-<a class="jxr_linenumber" name="419" href="#419">419</a> bbBody.putInt(resultSetCount);
-<a class="jxr_linenumber" name="420" href="#420">420</a>
-<a class="jxr_linenumber" name="421" href="#421">421</a> <strong class="jxr_keyword">if</strong> (resultSetCount > 0) {
-<a class="jxr_linenumber" name="422" href="#422">422</a> <strong class="jxr_keyword">boolean</strong> bNextResultSet = <strong class="jxr_keyword">true</strong>;
-<a class="jxr_linenumber" name="423" href="#423">423</a> trafStmt.setFirstTResultSet();
-<a class="jxr_linenumber" name="424" href="#424">424</a> <strong class="jxr_keyword">while</strong> (bNextResultSet) {
-<a class="jxr_linenumber" name="425" href="#425">425</a> trs = trafStmt.getTrafResultSet();
-<a class="jxr_linenumber" name="426" href="#426">426</a> trs.insertIntoByteBuffer(bbBody);
-<a class="jxr_linenumber" name="427" href="#427">427</a> bNextResultSet = trafStmt.getNextTResultSet();
-<a class="jxr_linenumber" name="428" href="#428">428</a> }
-<a class="jxr_linenumber" name="429" href="#429">429</a> trafStmt.setFirstTResultSet();
-<a class="jxr_linenumber" name="430" href="#430">430</a> }
-<a class="jxr_linenumber" name="431" href="#431">431</a> ByteBufferUtils.insertString(singleSyntax, bbBody);
-<a class="jxr_linenumber" name="432" href="#432">432</a>
-<a class="jxr_linenumber" name="433" href="#433">433</a> bbBody.flip();
-<a class="jxr_linenumber" name="434" href="#434">434</a> <em class="jxr_comment">//=========================Update header================================</em>
-<a class="jxr_linenumber" name="435" href="#435">435</a> hdr.setTotalLength(bbBody.limit());
-<a class="jxr_linenumber" name="436" href="#436">436</a> hdr.insertIntoByteBuffer(bbHeader);
-<a class="jxr_linenumber" name="437" href="#437">437</a> bbHeader.flip();
-<a class="jxr_linenumber" name="438" href="#438">438</a>
-<a class="jxr_linenumber" name="439" href="#439">439</a> clientData.setByteBufferArray(bbHeader, bbBody);
-<a class="jxr_linenumber" name="440" href="#440">440</a> clientData.setHdr(hdr);
-<a class="jxr_linenumber" name="441" href="#441">441</a> clientData.setRequest(ServerConstants.REQUST_WRITE_READ);
-<a class="jxr_linenumber" name="442" href="#442">442</a>
-<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">". Execute.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">". Execute.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> reset();
-<a class="jxr_linenumber" name="451" href="#451">451</a> <strong class="jxr_keyword">return</strong> clientData;
-<a class="jxr_linenumber" name="452" href="#452">452</a> }
-<a class="jxr_linenumber" name="453" href="#453">453</a> <em class="jxr_comment">//===================================================================================</em>
-<a class="jxr_linenumber" name="454" href="#454">454</a> <em class="jxr_comment">//</em>
-<a class="jxr_linenumber" name="455" href="#455">455</a> ByteBuffer setData(<a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a> paramDesc, <strong class="jxr_keyword">int</strong> paramRowCount, <strong class="jxr_keyword">int</strong> param, <strong class="jxr_keyword">int</strong> row, ByteBuffer bbBody, <strong class="jxr_keyword">long</strong> startOffset) <strong class="jxr_keyword">throws</strong> SQLException, ParseException, UnsupportedEncodingException {
-<a class="jxr_linenumber" name="456" href="#456">456</a> <strong class="jxr_keyword">int</strong> paramLength = 0;
-<a class="jxr_linenumber" name="457" href="#457">457</a>
-<a class="jxr_linenumber" name="458" href="#458">458</a> String tmpStr = <span class="jxr_string">""</span>;
-<a class="jxr_linenumber" name="459" href="#459">459</a> Short tmps = 0;
-<a class="jxr_linenumber" name="460" href="#460">460</a> Integer tmpi = 0;
-<a class="jxr_linenumber" name="461" href="#461">461</a> Long tmpl = 0L;
-<a class="jxr_linenumber" name="462" href="#462">462</a> Float tmpf = 0f;
-<a class="jxr_linenumber" name="463" href="#463">463</a> Double tmpd = 0d;
-<a class="jxr_linenumber" name="464" href="#464">464</a> BigInteger tmpbi;
-<a class="jxr_linenumber" name="465" href="#465">465</a> BigDecimal tmpbd;
-<a class="jxr_linenumber" name="466" href="#466">466</a> <strong class="jxr_keyword">boolean</strong> isSigne = <strong class="jxr_keyword">true</strong>;
-<a class="jxr_linenumber" name="467" href="#467">467</a>
-<a class="jxr_linenumber" name="468" href="#468">468</a> Object retObj;
-<a class="jxr_linenumber" name="469" href="#469">469</a> byte[] tbuffer = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="470" href="#470">470</a> <strong class="jxr_keyword">int</strong> year, month, day, hour, minute, second;
-<a class="jxr_linenumber" name="471" href="#471">471</a> <strong class="jxr_keyword">long</strong> nanoSeconds;
-<a class="jxr_linenumber" name="472" href="#472">472</a> String charSet = <span class="jxr_string">""</span>;
-<a class="jxr_linenumber" name="473" href="#473">473</a>
-<a class="jxr_linenumber" name="474" href="#474">474</a> <strong class="jxr_keyword">int</strong> precision = paramDesc.getPrecision();
-<a class="jxr_linenumber" name="475" href="#475">475</a> <strong class="jxr_keyword">int</strong> scale = paramDesc.getScale();
-<a class="jxr_linenumber" name="476" href="#476">476</a> <strong class="jxr_keyword">int</strong> datetimeCode = paramDesc.getDatetimeCode();
-<a class="jxr_linenumber" name="477" href="#477">477</a> <strong class="jxr_keyword">int</strong> FSDataType = paramDesc.getFsDataType();
-<a class="jxr_linenumber" name="478" href="#478">478</a> <strong class="jxr_keyword">int</strong> OdbcDataType = paramDesc.getOdbcDataType();
-<a class="jxr_linenumber" name="479" href="#479">479</a> <strong class="jxr_keyword">int</strong> dataCharSet = paramDesc.getSqlCharset();
-<a class="jxr_linenumber" name="480" href="#480">480</a> <strong class="jxr_keyword">int</strong> dataLength = paramDesc.getMaxLen();
-<a class="jxr_linenumber" name="481" href="#481">481</a> <strong class="jxr_keyword">int</strong> dataType = paramDesc.getDataType();
-<a class="jxr_linenumber" name="482" href="#482">482</a>
-<a class="jxr_linenumber" name="483" href="#483">483</a> <em class="jxr_comment">// setup the offsets</em>
-<a class="jxr_linenumber" name="484" href="#484">484</a> <strong class="jxr_keyword">int</strong> noNullValue = paramDesc.getNoNullValue();
-<a class="jxr_linenumber" name="485" href="#485">485</a> <strong class="jxr_keyword">int</strong> nullValue = paramDesc.getNullValue();
-<a class="jxr_linenumber" name="486" href="#486">486</a> <strong class="jxr_keyword">long</strong> nullOffset = 0L;
-<a class="jxr_linenumber" name="487" href="#487">487</a> <strong class="jxr_keyword">long</strong> noNullOffset = 0L;
-<a class="jxr_linenumber" name="488" href="#488">488</a>
-<a class="jxr_linenumber" name="489" href="#489">489</a> <strong class="jxr_keyword">if</strong> (dataType == ServerConstants.SQLTYPECODE_VARCHAR_WITH_LENGTH) {
-<a class="jxr_linenumber" name="490" href="#490">490</a> dataLength += 2;
-<a class="jxr_linenumber" name="491" href="#491">491</a>
-<a class="jxr_linenumber" name="492" href="#492">492</a> <strong class="jxr_keyword">if</strong> (dataLength % 2 != 0)
-<a class="jxr_linenumber" name="493" href="#493">493</a> dataLength++;
-<a class="jxr_linenumber" name="494" href="#494">494</a> }
-<a class="jxr_linenumber" name="495" href="#495">495</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="496" href="#496">496</a> LOG.debug(<span class="jxr_string">"nullValue :"</span>+ nullValue);
-<a class="jxr_linenumber" name="497" href="#497">497</a> <strong class="jxr_keyword">if</strong> (nullValue != -1) {
-<a class="jxr_linenumber" name="498" href="#498">498</a> nullValue = (nullValue * paramRowCount) + (row * 2);
-<a class="jxr_linenumber" name="499" href="#499">499</a> nullOffset = startOffset + nullValue;
-<a class="jxr_linenumber" name="500" href="#500">500</a> bbBody.position((<strong class="jxr_keyword">int</strong>)nullOffset);
-<a class="jxr_linenumber" name="501" href="#501">501</a> <strong class="jxr_keyword">short</strong> isNull = bbBody.getShort();
-<a class="jxr_linenumber" name="502" href="#502">502</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="503" href="#503">503</a> LOG.debug(<span class="jxr_string">"isNull :"</span>+ isNull);
-<a class="jxr_linenumber" name="504" href="#504">504</a> <strong class="jxr_keyword">if</strong> ( isNull == -1) {
-<a class="jxr_linenumber" name="505" href="#505">505</a> <strong class="jxr_keyword">if</strong> (isSpj == <strong class="jxr_keyword">true</strong>) cstmt.setObject(param,<strong class="jxr_keyword">null</strong>); <strong class="jxr_keyword">else</strong> pstmt.setObject(param,<strong class="jxr_keyword">null</strong>);
-<a class="jxr_linenumber" name="506" href="#506">506</a> <strong class="jxr_keyword">return</strong> bbBody;
-<a class="jxr_linenumber" name="507" href="#507">507</a> }
-<a class="jxr_linenumber" name="508" href="#508">508</a> }
-<a class="jxr_linenumber" name="509" href="#509">509</a> noNullValue = (noNullValue * paramRowCount) + (row * dataLength);
-<a class="jxr_linenumber" name="510" href="#510">510</a> noNullOffset = startOffset + noNullValue;
-<a class="jxr_linenumber" name="511" href="#511">511</a> bbBody.position((<strong class="jxr_keyword">int</strong>)noNullOffset);
-<a class="jxr_linenumber" name="512" href="#512">512</a>
-<a class="jxr_linenumber" name="513" href="#513">513</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="514" href="#514">514</a> LOG.debug(<span class="jxr_string">"["</span> + param + <span class="jxr_string">"] noNullOffset :"</span>+ noNullOffset + <span class="jxr_string">" noNullValue :"</span> + noNullValue);
-<a class="jxr_linenumber" name="515" href="#515">515</a>
-<a class="jxr_linenumber" name="516" href="#516">516</a> <strong class="jxr_keyword">if</strong>(dataCharSet == SqlUtils.SQLCHARSETCODE_UNICODE)
-<a class="jxr_linenumber" name="517" href="#517">517</a> charSet = <span class="jxr_string">"UTF-16LE"</span>;
-<a class="jxr_linenumber" name="518" href="#518">518</a> <strong class="jxr_keyword">else</strong>
-<a class="jxr_linenumber" name="519" href="#519">519</a> charSet = SqlUtils.getCharsetName(dataCharSet);
-<a class="jxr_linenumber" name="520" href="#520">520</a>
-<a class="jxr_linenumber" name="521" href="#521">521</a> <strong class="jxr_keyword">switch</strong> (dataType) {
-<a class="jxr_linenumber" name="522" href="#522">522</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_CHAR:
-<a class="jxr_linenumber" name="523" href="#523">523</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="524" href="#524">524</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_CHAR"</span>);
-<a class="jxr_linenumber" name="525" href="#525">525</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="526" href="#526">526</a> bbBody.get(tbuffer, 0, dataLength);
-<a class="jxr_linenumber" name="527" href="#527">527</a> retObj = <strong class="jxr_keyword">new</strong> String(tbuffer, charSet);
-<a class="jxr_linenumber" name="528" href="#528">528</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="529" href="#529">529</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_CHAR length :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="530" href="#530">530</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="531" href="#531">531</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR:
-<a class="jxr_linenumber" name="532" href="#532">532</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR_LONG:
-<a class="jxr_linenumber" name="533" href="#533">533</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="534" href="#534">534</a> ByteBufferUtils.toHexString(<span class="jxr_string">"VARCHAR/VARCHAR_LONG"</span>, bbBody, (dataLength > 100 ? 100 : dataLength));
-<a class="jxr_linenumber" name="535" href="#535">535</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="536" href="#536">536</a> bbBody.get(tbuffer, 0, dataLength);
-<a class="jxr_linenumber" name="537" href="#537">537</a> retObj = <strong class="jxr_keyword">new</strong> String(tbuffer, charSet);
-<a class="jxr_linenumber" name="538" href="#538">538</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) {
-<a class="jxr_linenumber" name="539" href="#539">539</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_VARCHAR len :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="540" href="#540">540</a> LOG.debug(<span class="jxr_string">" retObj :"</span> + Arrays.toString(((String)retObj).getBytes()));
-<a class="jxr_linenumber" name="541" href="#541">541</a> }
-<a class="jxr_linenumber" name="542" href="#542">542</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="543" href="#543">543</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_VARCHAR_WITH_LENGTH:
-<a class="jxr_linenumber" name="544" href="#544">544</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="545" href="#545">545</a> ByteBufferUtils.toHexString(<span class="jxr_string">"VARCHAR_WITH_LENGTH"</span>, bbBody, (dataLength > 100 ? 100 : dataLength));
-<a class="jxr_linenumber" name="546" href="#546">546</a> <strong class="jxr_keyword">boolean</strong> shortLength = precision < Math.pow(2, 15);
-<a class="jxr_linenumber" name="547" href="#547">547</a> <strong class="jxr_keyword">int</strong> dataOffset = (shortLength) ? 2 : 4;
-<a class="jxr_linenumber" name="548" href="#548">548</a> dataLength = (shortLength) ? bbBody.getShort() : bbBody.getInt();
-<a class="jxr_linenumber" name="549" href="#549">549</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="550" href="#550">550</a> bbBody.get(tbuffer, 0, dataLength);
-<a class="jxr_linenumber" name="551" href="#551">551</a> retObj = <strong class="jxr_keyword">new</strong> String(tbuffer, charSet);
-<a class="jxr_linenumber" name="552" href="#552">552</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) {
-<a class="jxr_linenumber" name="553" href="#553">553</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_VARCHAR len :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="554" href="#554">554</a> LOG.debug(<span class="jxr_string">" retObj :"</span> + Arrays.toString(((String)retObj).getBytes()));
-<a class="jxr_linenumber" name="555" href="#555">555</a> }
-<a class="jxr_linenumber" name="556" href="#556">556</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="557" href="#557">557</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_INTERVAL:
-<a class="jxr_linenumber" name="558" href="#558">558</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="559" href="#559">559</a> bbBody.get(tbuffer);
-<a class="jxr_linenumber" name="560" href="#560">560</a> retObj = <strong class="jxr_keyword">new</strong> String(tbuffer);
-<a class="jxr_linenumber" name="561" href="#561">561</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="562" href="#562">562</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_INTERVAL dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="563" href="#563">563</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="564" href="#564">564</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_DATETIME:
-<a class="jxr_linenumber" name="565" href="#565">565</a> <strong class="jxr_keyword">switch</strong> (datetimeCode) {
-<a class="jxr_linenumber" name="566" href="#566">566</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLDTCODE_DATE:
-<a class="jxr_linenumber" name="567" href="#567">567</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="568" href="#568">568</a> bbBody.get(tbuffer);
-<a class="jxr_linenumber" name="569" href="#569">569</a> retObj = java.sql.Date.valueOf((<strong class="jxr_keyword">new</strong> String(tbuffer)).trim());
-<a class="jxr_linenumber" name="570" href="#570">570</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="571" href="#571">571</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLDTCODE_DATE dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="572" href="#572">572</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="573" href="#573">573</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLDTCODE_TIMESTAMP:
-<a class="jxr_linenumber" name="574" href="#574">574</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="575" href="#575">575</a> bbBody.get(tbuffer);
-<a class="jxr_linenumber" name="576" href="#576">576</a> retObj = Timestamp.valueOf((<strong class="jxr_keyword">new</strong> String(tbuffer)).trim());
-<a class="jxr_linenumber" name="577" href="#577">577</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="578" href="#578">578</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLDTCODE_TIMESTAMP dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="579" href="#579">579</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="580" href="#580">580</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLDTCODE_TIME:
-<a class="jxr_linenumber" name="581" href="#581">581</a> <strong class="jxr_keyword">if</strong> (OdbcDataType == java.sql.Types.OTHER) <em class="jxr_comment">// For Desc.SQLDTCODE_HOUR_TO_FRACTION</em>
-<a class="jxr_linenumber" name="582" href="#582">582</a> {
-<a class="jxr_linenumber" name="583" href="#583">583</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="584" href="#584">584</a> bbBody.get(tbuffer);
-<a class="jxr_linenumber" name="585" href="#585">585</a> retObj = <strong class="jxr_keyword">new</strong> String((<strong class="jxr_keyword">new</strong> String(tbuffer)).trim());
-<a class="jxr_linenumber" name="586" href="#586">586</a> } <strong class="jxr_keyword">else</strong> {
-<a class="jxr_linenumber" name="587" href="#587">587</a> dataLength = ServerConstants.timeLength;
-<a class="jxr_linenumber" name="588" href="#588">588</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="589" href="#589">589</a> bbBody.get(tbuffer);
-<a class="jxr_linenumber" name="590" href="#590">590</a> retObj = Time.valueOf((<strong class="jxr_keyword">new</strong> String(tbuffer)).trim());
-<a class="jxr_linenumber" name="591" href="#591">591</a> }
-<a class="jxr_linenumber" name="592" href="#592">592</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="593" href="#593">593</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLDTCODE_TIME dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="594" href="#594">594</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="595" href="#595">595</a> <strong class="jxr_keyword">default</strong>:
-<a class="jxr_linenumber" name="596" href="#596">596</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="597" href="#597">597</a> bbBody.get(tbuffer);
-<a class="jxr_linenumber" name="598" href="#598">598</a> retObj = <strong class="jxr_keyword">new</strong> String(tbuffer);
-<a class="jxr_linenumber" name="599" href="#599">599</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="600" href="#600">600</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :default dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="601" href="#601">601</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="602" href="#602">602</a> } <em class="jxr_comment">// SQLTYPECODE_DATETIME</em>
-<a class="jxr_linenumber" name="603" href="#603">603</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="604" href="#604">604</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_SMALLINT:
-<a class="jxr_linenumber" name="605" href="#605">605</a> <strong class="jxr_keyword">short</strong> sValue = bbBody.getShort();
-<a class="jxr_linenumber" name="606" href="#606">606</a> retObj = <strong class="jxr_keyword">new</strong> Short(sValue);
-<a class="jxr_linenumber" name="607" href="#607">607</a> <strong class="jxr_keyword">if</strong> (scale > 0) {
-<a class="jxr_linenumber" name="608" href="#608">608</a> retObj = <strong class="jxr_keyword">new</strong> BigDecimal(<strong class="jxr_keyword">new</strong> BigInteger(retObj.toString()), scale);
-<a class="jxr_linenumber" name="609" href="#609">609</a> }
-<a class="jxr_linenumber" name="610" href="#610">610</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="611" href="#611">611</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_SMALLINT dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="612" href="#612">612</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="613" href="#613">613</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_SMALLINT_UNSIGNED:
-<a class="jxr_linenumber" name="614" href="#614">614</a> <strong class="jxr_keyword">int</strong> signedSValue = ByteBufferUtils.extractUShort(bbBody);
-<a class="jxr_linenumber" name="615" href="#615">615</a> <strong class="jxr_keyword">if</strong> (scale > 0) {
-<a class="jxr_linenumber" name="616" href="#616">616</a> tmpbd = <strong class="jxr_keyword">new</strong> BigDecimal(<strong class="jxr_keyword">new</strong> BigInteger(String.valueOf(signedSValue)), (<strong class="jxr_keyword">int</strong>) scale);
-<a class="jxr_linenumber" name="617" href="#617">617</a> } <strong class="jxr_keyword">else</strong> {
-<a class="jxr_linenumber" name="618" href="#618">618</a> tmpbd = <strong class="jxr_keyword">new</strong> BigDecimal(String.valueOf(signedSValue));
-<a class="jxr_linenumber" name="619" href="#619">619</a> }
-<a class="jxr_linenumber" name="620" href="#620">620</a> retObj = tmpbd;
-<a class="jxr_linenumber" name="621" href="#621">621</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="622" href="#622">622</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_SMALLINT_UNSIGNED dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="623" href="#623">623</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="624" href="#624">624</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_INTEGER:
-<a class="jxr_linenumber" name="625" href="#625">625</a> retObj = <strong class="jxr_keyword">new</strong> Integer(bbBody.getInt());
-<a class="jxr_linenumber" name="626" href="#626">626</a> <strong class="jxr_keyword">if</strong> (scale > 0) {
-<a class="jxr_linenumber" name="627" href="#627">627</a> retObj = <strong class="jxr_keyword">new</strong> BigDecimal(<strong class="jxr_keyword">new</strong> BigInteger(retObj.toString()), scale);
-<a class="jxr_linenumber" name="628" href="#628">628</a> }
-<a class="jxr_linenumber" name="629" href="#629">629</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="630" href="#630">630</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_INTEGER dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="631" href="#631">631</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="632" href="#632">632</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_INTEGER_UNSIGNED:
-<a class="jxr_linenumber" name="633" href="#633">633</a> retObj = <strong class="jxr_keyword">new</strong> Long(ByteBufferUtils.extractUInt(bbBody));
-<a class="jxr_linenumber" name="634" href="#634">634</a> <strong class="jxr_keyword">if</strong> (scale > 0) {
-<a class="jxr_linenumber" name="635" href="#635">635</a> retObj = <strong class="jxr_keyword">new</strong> BigDecimal(<strong class="jxr_keyword">new</strong> BigInteger(retObj.toString()), scale);
-<a class="jxr_linenumber" name="636" href="#636">636</a> }
-<a class="jxr_linenumber" name="637" href="#637">637</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="638" href="#638">638</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_INTEGER_UNSIGNED dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="639" href="#639">639</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="640" href="#640">640</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_LARGEINT:
-<a class="jxr_linenumber" name="641" href="#641">641</a> retObj = <strong class="jxr_keyword">new</strong> Long(bbBody.getLong());
-<a class="jxr_linenumber" name="642" href="#642">642</a> <strong class="jxr_keyword">if</strong> (scale > 0) {
-<a class="jxr_linenumber" name="643" href="#643">643</a> retObj = <strong class="jxr_keyword">new</strong> BigDecimal(<strong class="jxr_keyword">new</strong> BigInteger(retObj.toString()), scale);
-<a class="jxr_linenumber" name="644" href="#644">644</a> }
-<a class="jxr_linenumber" name="645" href="#645">645</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="646" href="#646">646</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_LARGEINT + dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="647" href="#647">647</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="648" href="#648">648</a> <em class="jxr_comment">//--------------------------------- SQLTYPECODE_NUMERIC/SQLTYPECODE_NUMERIC_UNSIGNED converted to INTEGER using fsDataType_ (Descriptor2) ---------</em>
-<a class="jxr_linenumber" name="649" href="#649">649</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_NUMERIC:
-<a class="jxr_linenumber" name="650" href="#650">650</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_NUMERIC_UNSIGNED:
-<a class="jxr_linenumber" name="651" href="#651">651</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="652" href="#652">652</a> ByteBufferUtils.toHexString(<span class="jxr_string">"SQLTYPECODE_NUMERIC"</span>, bbBody, (dataLength > 100 ? 100 : dataLength));
-<a class="jxr_linenumber" name="653" href="#653">653</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(<span class="jxr_string">"restricted_data_type"</span>);
-<a class="jxr_linenumber" name="654" href="#654">654</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_DECIMAL:
-<a class="jxr_linenumber" name="655" href="#655">655</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_DECIMAL_LARGE:
-<a class="jxr_linenumber" name="656" href="#656">656</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_DECIMAL_UNSIGNED:
-<a class="jxr_linenumber" name="657" href="#657">657</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_DECIMAL_LARGE_UNSIGNED:
-<a class="jxr_linenumber" name="658" href="#658">658</a> String retStr;
-<a class="jxr_linenumber" name="659" href="#659">659</a> tbuffer = <strong class="jxr_keyword">new</strong> byte[dataLength];
-<a class="jxr_linenumber" name="660" href="#660">660</a> bbBody.get(tbuffer);
-<a class="jxr_linenumber" name="661" href="#661">661</a>
-<a class="jxr_linenumber" name="662" href="#662">662</a> byte firstByte = tbuffer[0];
-<a class="jxr_linenumber" name="663" href="#663">663</a> byte sign = (byte) (firstByte & (byte) (0x80));
-<a class="jxr_linenumber" name="664" href="#664">664</a> <strong class="jxr_keyword">if</strong> (sign == (byte) (0x80)) {
-<a class="jxr_linenumber" name="665" href="#665">665</a> tbuffer[0] = (byte) (tbuffer[0] - (byte) (0x80));
-<a class="jxr_linenumber" name="666" href="#666">666</a> retStr = <span class="jxr_string">"-"</span> + <strong class="jxr_keyword">new</strong> String(tbuffer);
-<a class="jxr_linenumber" name="667" href="#667">667</a> } <strong class="jxr_keyword">else</strong> {
-<a class="jxr_linenumber" name="668" href="#668">668</a> retStr = <strong class="jxr_keyword">new</strong> String(tbuffer);
-<a class="jxr_linenumber" name="669" href="#669">669</a> }
-<a class="jxr_linenumber" name="670" href="#670">670</a> retObj = <strong class="jxr_keyword">new</strong> BigDecimal(<strong class="jxr_keyword">new</strong> BigInteger(retStr), scale);
-<a class="jxr_linenumber" name="671" href="#671">671</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="672" href="#672">672</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_DECIMAL dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="673" href="#673">673</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="674" href="#674">674</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_REAL:
-<a class="jxr_linenumber" name="675" href="#675">675</a> retObj = <strong class="jxr_keyword">new</strong> Float(Float.intBitsToFloat(bbBody.getInt()));
-<a class="jxr_linenumber" name="676" href="#676">676</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="677" href="#677">677</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_REAL dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="678" href="#678">678</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="679" href="#679">679</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_DOUBLE:
-<a class="jxr_linenumber" name="680" href="#680">680</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_FLOAT:
-<a class="jxr_linenumber" name="681" href="#681">681</a> retObj = <strong class="jxr_keyword">new</strong> Double(Double.longBitsToDouble(bbBody.getLong()));
-<a class="jxr_linenumber" name="682" href="#682">682</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="683" href="#683">683</a> LOG.debug(<span class="jxr_string">"["</span>+ param + <span class="jxr_string">"] dataType :SQLTYPECODE_DOUBLE dataLength :"</span> + dataLength + <span class="jxr_string">" scale :"</span> + scale + <span class="jxr_string">" retObj :"</span> + retObj);
-<a class="jxr_linenumber" name="684" href="#684">684</a> <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="685" href="#685">685</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_BIT:
-<a class="jxr_linenumber" name="686" href="#686">686</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_BITVAR:
-<a class="jxr_linenumber" name="687" href="#687">687</a> <strong class="jxr_keyword">case</strong> ServerConstants.SQLTYPECODE_BPINT_UNSIGNED:
-<a class="jxr_linenumber" name="688" href="#688">688</a> <strong class="jxr_keyword">default</strong>:
-<a class="jxr_linenumber" name="689" href="#689">689</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(<span class="jxr_string">"restricted_data_type"</span>);
-<a class="jxr_linenumber" name="690" href="#690">690</a> } <em class="jxr_comment">// dataType</em>
-<a class="jxr_linenumber" name="691" href="#691">691</a> <strong class="jxr_keyword">if</strong> (isSpj == <strong class="jxr_keyword">true</strong>) cstmt.setObject(param,retObj); <strong class="jxr_keyword">else</strong> pstmt.setObject(param,retObj);
-<a class="jxr_linenumber" name="692" href="#692">692</a> <strong class="jxr_keyword">return</strong> bbBody;
-<a class="jxr_linenumber" name="693" href="#693">693</a> }
-<a class="jxr_linenumber" name="694" href="#694">694</a> byte[] buildOutValues(<a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2List.html">Descriptor2List</a> paramDescList, byte[] outValues, <strong class="jxr_keyword">int</strong> paramCount, CallableStatement cstmt, ByteOrder o) <strong class="jxr_keyword">throws</strong> SQLException, UnsupportedEncodingException {
-<a class="jxr_linenumber" name="695" href="#695">695</a>
-<a class="jxr_linenumber" name="696" href="#696">696</a> SQLMXCallableStatement sqlcall = (SQLMXCallableStatement)cstmt;
-<a class="jxr_linenumber" name="697" href="#697">697</a> <strong class="jxr_keyword">int</strong> paramOffset = 0;
-<a class="jxr_linenumber" name="698" href="#698">698</a>
-<a class="jxr_linenumber" name="699" href="#699">699</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="700" href="#700">700</a> LOG.debug(<span class="jxr_string">" buildOutValues paramCount :"</span>+ paramCount);
-<a class="jxr_linenumber" name="701" href="#701">701</a>
-<a class="jxr_linenumber" name="702" href="#702">702</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> param = 1; param <= paramCount; param++) {
-<a class="jxr_linenumber" name="703" href="#703">703</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a> dsc = paramDescList.getDescriptors2()[param - 1];
-<a class="jxr_linenumber" name="704" href="#704">704</a> <strong class="jxr_keyword">if</strong> ( dsc.getParamMode() == java.sql.ParameterMetaData.parameterModeIn) <strong class="jxr_keyword">continue</strong>;
-<a class="jxr_linenumber" name="705" href="#705">705</a>
-<a class="jxr_linenumber" name="706" href="#706">706</a> <strong class="jxr_keyword">int</strong> noNullValueOffset = dsc.getNoNullValue();
-<a class="jxr_linenumber" name="707" href="#707">707</a> <strong class="jxr_keyword">int</strong> nullValueOffset = dsc.getNullValue();
-<a class="jxr_linenumber" name="708" href="#708">708</a>
-<a class="jxr_linenumber" name="709" href="#709">709</a> <strong class="jxr_keyword">if</strong> (nullValueOffset != -1)
-<a class="jxr_linenumber" name="710" href="#710">710</a> nullValueOffset += paramOffset;
-<a class="jxr_linenumber" name="711" href="#711">711</a> <strong class="jxr_keyword">if</strong> (noNullValueOffset != -1)
-<a class="jxr_linenumber" name="712" href="#712">712</a> noNullValueOffset += paramOffset;
-<a class="jxr_linenumber" name="713" href="#713">713</a>
-<a class="jxr_linenumber" name="714" href="#714">714</a> byte[] sqlarray = sqlcall.getSQLBytes(param);
-<a class="jxr_linenumber" name="715" href="#715">715</a> <strong class="jxr_keyword">if</strong> (sqlarray == <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="716" href="#716">716</a> <strong class="jxr_keyword">short</strong> value = -1;
-<a class="jxr_linenumber" name="717" href="#717">717</a> outValues[(<strong class="jxr_keyword">int</strong>)nullValueOffset] = (byte) ((value >>> 8) & 0xff);
-<a class="jxr_linenumber" name="718" href="#718">718</a> outValues[(<strong class="jxr_keyword">int</strong>)(nullValueOffset + 1)] = (byte) ((value) & 0xff);
-<a class="jxr_linenumber" name="719" href="#719">719</a> } <strong class="jxr_keyword">else</strong> {
-<a class="jxr_linenumber" name="720" href="#720">720</a> outValues = SqlUtils.formatSqlT4Output(dsc, sqlarray, noNullValueOffset, outValues, o);
-<a class="jxr_linenumber" name="721" href="#721">721</a> }
-<a class="jxr_linenumber" name="722" href="#722">722</a> }
-<a class="jxr_linenumber" name="723" href="#723">723</a> <strong class="jxr_keyword">return</strong> outValues;
-<a class="jxr_linenumber" name="724" href="#724">724</a> }
-<a class="jxr_linenumber" name="725" href="#725">725</a> <strong class="jxr_keyword">void</strong> setMultipleResultSets(CallableStatement cstmt) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="726" href="#726">726</a> resultSetCount = 0;
-<a class="jxr_linenumber" name="727" href="#727">727</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2List.html">Descriptor2List</a> outDescList = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="728" href="#728">728</a> ResultSet rs = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="729" href="#729">729</a> <strong class="jxr_keyword">boolean</strong> moreResults = <strong class="jxr_keyword">true</strong>;
-<a class="jxr_linenumber" name="730" href="#730">730</a> <strong class="jxr_keyword">while</strong>(moreResults) {
-<a class="jxr_linenumber" name="731" href="#731">731</a> rs = cstmt.getResultSet();
-<a class="jxr_linenumber" name="732" href="#732">732</a> addTResultSet(rs);
-<a class="jxr_linenumber" name="733" href="#733">733</a> resultSetCount++;
-<a class="jxr_linenumber" name="734" href="#734">734</a> moreResults = cstmt.getMoreResults();
-<a class="jxr_linenumber" name="735" href="#735">735</a> }
-<a class="jxr_linenumber" name="736" href="#736">736</a> }
-<a class="jxr_linenumber" name="737" href="#737">737</a> <strong class="jxr_keyword">void</strong> addTResultSet(ResultSet rs) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="738" href="#738">738</a>
-<a class="jxr_linenumber" name="739" href="#739">739</a> ResultSetMetaData rsmd;
-<a class="jxr_linenumber" name="740" href="#740">740</a> TResultSetMetaData trsmd;
-<a class="jxr_linenumber" name="741" href="#741">741</a> SQLMXResultSetMetaData strsmd;
-<a class="jxr_linenumber" name="742" href="#742">742</a>
-<a class="jxr_linenumber" name="743" href="#743">743</a> <em class="jxr_comment">//-------------T2 desc fields-------------------</em>
-<a class="jxr_linenumber" name="744" href="#744">744</a> <strong class="jxr_keyword">int</strong> sqlCharset_;
-<a class="jxr_linenumber" name="745" href="#745">745</a> <strong class="jxr_keyword">int</strong> odbcCharset_;
-<a class="jxr_linenumber" name="746" href="#746">746</a> <strong class="jxr_keyword">int</strong> sqlDataType_;
-<a class="jxr_linenumber" name="747" href="#747">747</a> <strong class="jxr_keyword">int</strong> dataType_;
-<a class="jxr_linenumber" name="748" href="#748">748</a> <strong class="jxr_keyword">short</strong> sqlPrecision_;
-<a class="jxr_linenumber" name="749" href="#749">749</a> <strong class="jxr_keyword">short</strong> sqlDatetimeCode_;
-<a class="jxr_linenumber" name="750" href="#750">750</a> <strong class="jxr_keyword">int</strong> sqlOctetLength_;
-<a class="jxr_linenumber" name="751" href="#751">751</a> <strong class="jxr_keyword">int</strong> isNullable_;
-<a class="jxr_linenumber" name="752" href="#752">752</a> String name_;
-<a class="jxr_linenumber" name="753" href="#753">753</a> <strong class="jxr_keyword">int</strong> scale_;
-<a class="jxr_linenumber" name="754" href="#754">754</a> <strong class="jxr_keyword">int</strong> precision_;
-<a class="jxr_linenumber" name="755" href="#755">755</a> <strong class="jxr_keyword">boolean</strong> isSigned_;
-<a class="jxr_linenumber" name="756" href="#756">756</a> <strong class="jxr_keyword">boolean</strong> isCurrency_;
-<a class="jxr_linenumber" name="757" href="#757">757</a> <strong class="jxr_keyword">boolean</strong> isCaseSensitive_;
-<a class="jxr_linenumber" name="758" href="#758">758</a> String catalogName_;
-<a class="jxr_linenumber" name="759" href="#759">759</a> String schemaName_;
-<a class="jxr_linenumber" name="760" href="#760">760</a> String tableName_;
-<a class="jxr_linenumber" name="761" href="#761">761</a> <strong class="jxr_keyword">int</strong> fsDataType_;
-<a class="jxr_linenumber" name="762" href="#762">762</a> <strong class="jxr_keyword">int</strong> intLeadPrec_;
-<a class="jxr_linenumber" name="763" href="#763">763</a> <strong class="jxr_keyword">int</strong> paramMode_;
-<a class="jxr_linenumber" name="764" href="#764">764</a> <strong class="jxr_keyword">int</strong> paramIndex_;
-<a class="jxr_linenumber" name="765" href="#765">765</a> <strong class="jxr_keyword">int</strong> paramPos_;
-<a class="jxr_linenumber" name="766" href="#766">766</a>
-<a class="jxr_linenumber" name="767" href="#767">767</a> <strong class="jxr_keyword">int</strong> odbcPrecision_;
-<a class="jxr_linenumber" name="768" href="#768">768</a> <strong class="jxr_keyword">int</strong> maxLen_;
-<a class="jxr_linenumber" name="769" href="#769">769</a>
-<a class="jxr_linenumber" name="770" href="#770">770</a> <strong class="jxr_keyword">int</strong> displaySize_;
-<a class="jxr_linenumber" name="771" href="#771">771</a> String label_;
-<a class="jxr_linenumber" name="772" href="#772">772</a>
-<a class="jxr_linenumber" name="773" href="#773">773</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2List.html">Descriptor2List</a> descl = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="774" href="#774">774</a> <strong class="jxr_keyword">int</strong> columnCount;
-<a class="jxr_linenumber" name="775" href="#775">775</a>
-<a class="jxr_linenumber" name="776" href="#776">776</a> rsmd = rs.getMetaData();
-<a class="jxr_linenumber" name="777" href="#777">777</a> columnCount = rsmd.getColumnCount();
-<a class="jxr_linenumber" name="778" href="#778">778</a>
-<a class="jxr_linenumber" name="779" href="#779">779</a> <strong class="jxr_keyword">if</strong> (columnCount > 0) {
-<a class="jxr_linenumber" name="780" href="#780">780</a> strsmd = (SQLMXResultSetMetaData)rsmd;
-<a class="jxr_linenumber" name="781" href="#781">781</a> outDescList = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2List.html">Descriptor2List</a>(columnCount,false);
-<a class="jxr_linenumber" name="782" href="#782">782</a>
-<a class="jxr_linenumber" name="783" href="#783">783</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> column = 1; column <= columnCount; column++) {
-<a class="jxr_linenumber" name="784" href="#784">784</a> sqlCharset_ = strsmd.getSqlCharset(column);
-<a class="jxr_linenumber" name="785" href="#785">785</a> odbcCharset_ = strsmd.getOdbcCharset(column);
-<a class="jxr_linenumber" name="786" href="#786">786</a> sqlDataType_ = strsmd.getSqlDataType(column);
-<a class="jxr_linenumber" name="787" href="#787">787</a> dataType_ = strsmd.getDataType(column);
-<a class="jxr_linenumber" name="788" href="#788">788</a> sqlPrecision_ = strsmd.getSqlPrecision(column);
-<a class="jxr_linenumber" name="789" href="#789">789</a> sqlDatetimeCode_ = strsmd.getSqlDatetimeCode(column);
-<a class="jxr_linenumber" name="790" href="#790">790</a> sqlOctetLength_ = strsmd.getSqlOctetLength(column);
-<a class="jxr_linenumber" name="791" href="#791">791</a> isNullable_ = strsmd.getIsNullable(column);
-<a class="jxr_linenumber" name="792" href="#792">792</a> name_ = strsmd.getName(column);
-<a class="jxr_linenumber" name="793" href="#793">793</a> scale_ = strsmd.getScale(column);
-<a class="jxr_linenumber" name="794" href="#794">794</a> precision_ = strsmd.getPrecision(column);
-<a class="jxr_linenumber" name="795" href="#795">795</a> isSigned_ = strsmd.getIsSigned(column);
-<a class="jxr_linenumber" name="796" href="#796">796</a> isCurrency_ = strsmd.getIsCurrency(column);
-<a class="jxr_linenumber" name="797" href="#797">797</a> isCaseSensitive_ = strsmd.getIsCaseSensitive(column);
-<a class="jxr_linenumber" name="798" href="#798">798</a> catalogName_ = strsmd.getCatalogName(column);
-<a class="jxr_linenumber" name="799" href="#799">799</a> schemaName_ = strsmd.getSchemaName(column);
-<a class="jxr_linenumber" name="800" href="#800">800</a> tableName_ = strsmd.getTableName(column);
-<a class="jxr_linenumber" name="801" href="#801">801</a> fsDataType_ = strsmd.getFsDataType(column);
-<a class="jxr_linenumber" name="802" href="#802">802</a> intLeadPrec_ = strsmd.getIntLeadPrec(column);
-<a class="jxr_linenumber" name="803" href="#803">803</a> paramMode_ = strsmd.getMode(column);
-<a class="jxr_linenumber" name="804" href="#804">804</a> paramIndex_ = strsmd.getIndex(column);
-<a class="jxr_linenumber" name="805" href="#805">805</a> paramPos_ = strsmd.getPos(column);
-<a class="jxr_linenumber" name="806" href="#806">806</a>
-<a class="jxr_linenumber" name="807" href="#807">807</a> odbcPrecision_ = strsmd.getOdbcPrecision(column);
-<a class="jxr_linenumber" name="808" href="#808">808</a> maxLen_ = strsmd.getMaxLen(column);
-<a class="jxr_linenumber" name="809" href="#809">809</a>
-<a class="jxr_linenumber" name="810" href="#810">810</a> displaySize_ = strsmd.getDisplaySize(column);
-<a class="jxr_linenumber" name="811" href="#811">811</a> label_ = strsmd.getLabel(column);
-<a class="jxr_linenumber" name="812" href="#812">812</a>
-<a class="jxr_linenumber" name="813" href="#813">813</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a> outDesc = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a>(sqlCharset_,odbcCharset_,sqlDataType_,dataType_,sqlPrecision_,sqlDatetimeCode_,
-<a class="jxr_linenumber" name="814" href="#814">814</a> sqlOctetLength_,isNullable_,name_,scale_,precision_,isSigned_,
-<a class="jxr_linenumber" name="815" href="#815">815</a> isCurrency_,isCaseSensitive_,catalogName_,schemaName_,tableName_,
-<a class="jxr_linenumber" name="816" href="#816">816</a> fsDataType_,intLeadPrec_,paramMode_,paramIndex_,paramPos_,odbcPrecision_,
-<a class="jxr_linenumber" name="817" href="#817">817</a> maxLen_,displaySize_,label_, false);
-<a class="jxr_linenumber" name="818" href="#818">818</a> outDescList.addDescriptor(column, outDesc);
-<a class="jxr_linenumber" name="819" href="#819">819</a> }
-<a class="jxr_linenumber" name="820" href="#820">820</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) {
-<a class="jxr_linenumber" name="821" href="#821">821</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> column = 1; column <= columnCount; column++) {
-<a class="jxr_linenumber" name="822" href="#822">822</a> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/Descriptor2.html">Descriptor2</a> dsc = outDescList.getDescriptors2()[column-1];
-<a class="jxr_linenumber" name="823" href="#823">823</a> LOG.debug(serverWorkerName + <span class="jxr_string">". ["</span> + column + <span class="jxr_string">"] Column descriptor -------------"</span> );
-<a class="jxr_linenumber" name="824" href="#824">824</a> LOG.debug(serverWorkerName + <span class="jxr_string">". oldFormat "</span> + column + <span class="jxr_string">" :"</span> + dsc.getOldFormat());
-<a class="jxr_linenumber" name="825" href="#825">825</a> LOG.debug(serverWorkerName + <span class="jxr_string">". noNullValue "</span> + column + <span class="jxr_string">" :"</span> + dsc.getNoNullValue());
-<a class="jxr_linenumber" name="826" href="#826">826</a> LOG.debug(serverWorkerName + <span class="jxr_string">". nullValue "</span> + column + <span class="jxr_string">" :"</span> + dsc.getNullValue());
-<a class="jxr_linenumber" name="827" href="#827">827</a> LOG.debug(serverWorkerName + <span class="jxr_string">". version "</span> + column + <span class="jxr_string">" :"</span> + dsc.getVersion());
-<a class="jxr_linenumber" name="828" href="#828">828</a> LOG.debug(serverWorkerName + <span class="jxr_string">". dataType "</span> + column + <span class="jxr_string">" :"</span> + SqlUtils.getDataType(dsc.getDataType()));
-<a class="jxr_linenumber" name="829" href="#829">829</a> LOG.debug(serverWorkerName + <span class="jxr_string">". datetimeCode "</span> + column + <span class="jxr_string">" :"</span> + dsc.getDatetimeCode());
-<a class="jxr_linenumber" name="830" href="#830">830</a> LOG.debug(serverWorkerName + <span class="jxr_string">". maxLen "</span> + column + <span class="jxr_string">" :"</span> + dsc.getMaxLen());
-<a class="jxr_linenumber" name="831" href="#831">831</a> LOG.debug(serverWorkerName + <span class="jxr_string">". precision "</span> + column + <span class="jxr_string">" :"</span> + dsc.getPrecision());
-<a class="jxr_linenumber" name="832" href="#832">832</a> LOG.debug(serverWorkerName + <span class="jxr_string">". scale "</span> + column + <span class="jxr_string">" :"</span> + dsc.getScale());
-<a class="jxr_linenumber" name="833" href="#833">833</a> LOG.debug(serverWorkerName + <span class="jxr_string">". nullInfo "</span> + column + <span class="jxr_string">" :"</span> + dsc.getNullInfo());
-<a class="jxr_linenumber" name="834" href="#834">834</a> LOG.debug(serverWorkerName + <span class="jxr_string">". signed "</span> + column + <span class="jxr_string">" :"</span> + dsc.getSigned());
-<a class="jxr_linenumber" name="835" href="#835">835</a> LOG.debug(serverWorkerName + <span class="jxr_string">". odbcDataType "</span> + column + <span class="jxr_string">" :"</span> + dsc.getOdbcDataType());
-<a class="jxr_linenumber" name="836" href="#836">836</a> LOG.debug(serverWorkerName + <span class="jxr_string">". odbcPrecision "</span> + column + <span class="jxr_string">" :"</span> + dsc.getOdbcPrecision());
-<a class="jxr_linenumber" name="837" href="#837">837</a> LOG.debug(serverWorkerName + <span class="jxr_string">". sqlCharset "</span> + column + <span class="jxr_string">" :"</span> + SqlUtils.getCharsetName(dsc.getSqlCharset()) + <span class="jxr_string">"["</span> + dsc.getSqlCharset() + <span class="jxr_string">"]"</span>);
-<a class="jxr_linenumber" name="838" href="#838">838</a> LOG.debug(serverWorkerName + <span class="jxr_string">". odbcCharset "</span> + column + <span class="jxr_string">" :"</span> + SqlUtils.getCharsetName(dsc.getOdbcCharset()) + <span class="jxr_string">"["</span> + dsc.getOdbcCharset() + <span class="jxr_string">"]"</span>);
-<a class="jxr_linenumber" name="839" href="#839">839</a> LOG.debug(serverWorkerName + <span class="jxr_string">". colHeadingNm "</span> + column + <span class="jxr_string">" :"</span> + dsc.getColHeadingNm());
-<a class="jxr_linenumber" name="840" href="#840">840</a> LOG.debug(serverWorkerName + <span class="jxr_string">". tableName "</span> + column + <span class="jxr_string">" :"</span> + dsc.getTableName());
-<a class="jxr_linenumber" name="841" href="#841">841</a> LOG.debug(serverWorkerName + <span class="jxr_string">". schemaName "</span> + column + <span class="jxr_string">" :"</span> + dsc.getSchemaName());
-<a class="jxr_linenumber" name="842" href="#842">842</a> LOG.debug(serverWorkerName + <span class="jxr_string">". headingName "</span> + column + <span class="jxr_string">" :"</span> + dsc.getHeadingName());
-<a class="jxr_linenumber" name="843" href="#843">843</a> LOG.debug(serverWorkerName + <span class="jxr_string">". intLeadPrec "</span> + column + <span class="jxr_string">" :"</span> + dsc.getParamMode());
-<a class="jxr_linenumber" name="844" href="#844">844</a> LOG.debug(serverWorkerName + <span class="jxr_string">". paramMode "</span> + column + <span class="jxr_string">" :"</span> + dsc.getColHeadingNm());
-<a class="jxr_linenumber" name="845" href="#845">845</a> LOG.debug(serverWorkerName + <span class="jxr_string">". varLength "</span> + column + <span class="jxr_string">" :"</span> + dsc.getVarLength());
-<a class="jxr_linenumber" name="846" href="#846">846</a> LOG.debug(serverWorkerName + <span class="jxr_string">". Column descriptor End-------------"</span>);
-<a class="jxr_linenumber" name="847" href="#847">847</a> }
-<a class="jxr_linenumber" name="848" href="#848">848</a> }
-<a class="jxr_linenumber" name="849" href="#849">849</a> }
-<a class="jxr_linenumber" name="850" href="#850">850</a> <strong class="jxr_keyword">if</strong> (columnCount > 0)
-<a class="jxr_linenumber" name="851" href="#851">851</a> trafStmt.addTResultSet(<strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverSql/TrafResultSet.html">TrafResultSet</a>(rs, 0, stmtLabel, 0, outDescList,<span class="jxr_string">""</span>));
-<a class="jxr_linenumber" name="852" href="#852">852</a> }
-<a class="jxr_linenumber" name="853" href="#853">853</a> }
+<a class="jxr_linenumber" name="308" href="#308">308</a> trafStmt.closeAllTResultSets();
+<a class="jxr_linenumber" name="309" href="#309">309</a> trafStmt.addTResultSet(<strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverSql/TrafResultSet.html">TrafResultSet</a>(rs, 0, stmtLabel, 0, trafStmt.getOutDescList(),<span class="jxr_string">""</span>));
+<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> <strong class="jxr_keyword">if</strong> (isSpj == <strong class="jxr_keyword">true</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">". SPJ T2 Execute.execute()"</span>);
+<a class="jxr_linenumber" name="314" href="#314">314</a> <strong class="jxr_keyword">boolean</strong> rsAvailable = cstmt.execute();
+<a class="jxr_linenumber" name="315" href="#315">315</a> <strong class="jxr_keyword">if</strong> (regParamCount > 0) { <em class="jxr_comment">//out, inout parameters</em>
+<a class="jxr_linenumber" name="316" href="#316">316</a> rowsAffected = 1;
+<a class="jxr_linenumber" name="317" href="#317">317</a> outValuesLength = (<strong class="jxr_keyword">int</strong>)paramLength;
+<a class="jxr_linenumber" name="318" href="#318">318</a> outValues = <strong class="jxr_keyword">new</strong> byte[outValuesLength];
+<a class="jxr_linenumber" name="319" href="#319">319</a> outValues = buildOutValues(paramDescList, outValues, paramCount, cstmt, bbBody.order());
+<a class="jxr_linenumber" name="320" href="#320">320</a> }
+<a class="jxr_linenumber" name="321" href="#321">321</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="322" href="#322">322</a> LOG.debug(serverWorkerName + <span class="jxr_string">". SPJ T2 Execute.rsAvailable :"</span> + rsAvailable);
+<a class="jxr_linenumber" name="323" href="#323">323</a> <strong class="jxr_keyword">if</strong> (rsAvailable == <strong class="jxr_keyword">true</strong>) {
+<a class="jxr_linenumber" name="324" href="#324">324</a> setMultipleResultSets(cstmt);
+<a class="jxr_linenumber" name="325" href="#325">325</a> }
+<a class="jxr_linenumber" name="326" href="#326">326</a> } <strong class="jxr_keyword">else</strong> {
+<a class="jxr_linenumber" name="327" href="#327">327</a> resultSetCount = 0;
+<a class="jxr_linenumber" name="328" href="#328">328</a> rowsAffected = pstmt.executeUpdate();
+<a class="jxr_linenumber" name="329" href="#329">329</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="330" href="#330">330</a> LOG.debug(serverWorkerName + <span class="jxr_string">". T2 Execute.executeUpdate() rowsAffected :"</span> + rowsAffected);
+<a class="jxr_linenumber" name="331" href="#331">331</a> }
+<a class="jxr_linenumber" name="332" href="#332">332</a> } <strong class="jxr_keyword">catch</strong> (BatchUpdateException bex) {
+<a class="jxr_linenumber" name="333" href="#333">333</a> LOG.error(serverWorkerName + <span class="jxr_string">". Execute.BatchUpdateException "</span> + bex);
+<a class="jxr_linenumber" name="334" href="#334">334</a> errorList = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/trafodion/dcs/servermt/serverDriverInputOutput/SQLWarningOrErrorList.html">SQLWarningOrErrorList</a>(bex, bex.getUpdateCounts());
+<a class="jxr_linenumber" name="335" href="#335">335</a> returnCode = errorList.getReturnCode();
+<a class="jxr_linenumber" name="336" href="#336">336</a>
+<a class="jxr_linenumber" name="337" href="#337">337</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
+<a class="jxr_linenumber" name="338" href="#338">338</a> LOG.error(serverWorkerName + <span class="jxr_string">". Execute.SQLException "</span> + ex);
+<a class="jxr_linenumber" name="339" href="#339">339</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="340" href="#340">340</a> returnCode = errorList.getReturnCode();
+<a class="jxr_linenumber" name="341" href="#341">341</a> }
+<a class="jxr_linenumber" name="342" href="#342">342</a> <strong class="jxr_keyword">if</strong> (sqlString.isEmpty() == false)
+<a class="jxr_linenumber" name="343" href="#343">343</a> sqlQueryType = SqlUtils.getSqlStmtType(sqlString);
+<a class="jxr_linenumber" name="344" href="#344">344</a> <strong class="jxr_keyword">else</strong>
+<a class="jxr_linenumber" name="345" href="#345">345</a> sqlQueryType = SqlUtils.getSqlStmtType(sqlStmtType);
+<a class="jxr_linenumber" name="346" href="#346">346</a> <em class="jxr_comment">//</em>
+<a class="jxr_linenumber" name="347" href="#347">347</a> <em class="jxr_comment">//===================calculate length of output ByteBuffer========================</em>
+<a class="jxr_linenumber" name="348" href="#348">348</a> <em class="jxr_comment">//</em>
+<a class="jxr_linenumber" name="349" href="#349">349</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="350" href="#350">350</a> LOG.debug(serverWorkerName + <span class="jxr_string">". calculate length of output ByteBuffer"</span>);
+<a class="jxr_linenumber" name="351" href="#351">351</a> bbHeader.clear();
+<a class="jxr_linenumber" name="352" href="#352">352</a> bbBody.clear();
+<a class="jxr_linenumber" name="353" href="#353">353</a> <em class="jxr_comment">//</em>
+<a class="jxr_linenumber" name="354" href="#354">354</a> <em class="jxr_comment">// check if ByteBuffer is big enough for output</em>
+<a class="jxr_linenumber" name="355" href="#355">355</a> <em class="jxr_comment">//</em>
+<a class="jxr_linenumber" name="356" href="#356">356</a> <a href="../../../../../org/trafodion/dcs/servermt/serverSql/TrafResultSet.html">TrafResultSet</a> trs = <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="357" href="#357">357</a>
+<a class="jxr_linenumber" name="358" href="#358">358</a> <strong class="jxr_keyword">int</strong> dataLength = ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//returnCode</em>
+<a class="jxr_linenumber" name="359" href="#359">359</a> <strong class="jxr_keyword">if</strong> (errorList != <strong class="jxr_keyword">null</strong>)
+<a class="jxr_linenumber" name="360" href="#360">360</a> dataLength += errorList.lengthOfData();
+<a class="jxr_linenumber" name="361" href="#361">361</a> <strong class="jxr_keyword">else</strong>
+<a class="jxr_linenumber" name="362" href="#362">362</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//totalErrorLength = 0</em>
+<a class="jxr_linenumber" name="363" href="#363">363</a>
+<a class="jxr_linenumber" name="364" href="#364">364</a> <strong class="jxr_keyword">if</strong> (outDescList != <strong class="jxr_keyword">null</strong>)
+<a class="jxr_linenumber" name="365" href="#365">365</a> dataLength += outDescList.lengthOfData();
+<a class="jxr_linenumber" name="366" href="#366">366</a> <strong class="jxr_keyword">else</strong>
+<a class="jxr_linenumber" name="367" href="#367">367</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//outDescLength = 0</em>
+<a class="jxr_linenumber" name="368" href="#368">368</a>
+<a class="jxr_linenumber" name="369" href="#369">369</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//rowsAffected</em>
+<a class="jxr_linenumber" name="370" href="#370">370</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//sqlQueryType</em>
+<a class="jxr_linenumber" name="371" href="#371">371</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">//estimatedCost</em>
+<a class="jxr_linenumber" name="372" href="#372">372</a> dataLength += ByteBufferUtils.lengthOfByteArray(outValues);<em class="jxr_comment">//outValues</em>
+<a class="jxr_linenumber" name="373" href="#373">373</a>
+<a class="jxr_linenumber" name="374" href="#374">374</a> dataLength += ServerConstants.INT_FIELD_SIZE;<em class="jxr_comment">// SPJ Result Sets</em>
+<a class="jxr_linenumber" name="375" href="#375">375</a> <strong class="jxr_keyword">if</strong> (resultSetCount > 0) {
+<a class="jxr_linenumber" name="376" href="#376">376</a> <strong class="jxr_keyword">boolean</strong> bNextResultSet = <strong class="jxr_keyword">true</strong>;
+<a class="jxr_linenumber" name="377" href="#377">377</a> trafStmt.setFirstTResultSet();
+<a class="jxr_linenumber" name="378" href="#378">378</a> <strong class="jxr_keyword">while</strong> (bNextResultSet) {
+<a class="jxr_linenumber" name="379" href="#379">379</a> trs = trafStmt.getTrafResultSet();
+<a class="jxr_linenumber" name="380" href="#380">380</a> dataLength += trs.lengthOfData();
+<a class="jxr_linenumber" name="381" href="#381">381</a> bNextResultSet = trafStmt.getNextTResultSet();
+<a class="jxr_linenumber" name="382" href="#382">382</a> }
+<a class="jxr_linenumber" name="383" href="#383">383</a> }
+<a class="jxr_linenumber" name="384" href="#384">384</a> dataLength += ByteBufferUtils.lengthOfString(singleSyntax);
+<a class="jxr_linenumber" name="385" href="#385">385</a>
+<a class="jxr_linenumber" name="386" href="#386">386</a> <strong class="jxr_keyword">int</strong> availableBuffer = bbBody.capacity() - bbBody.position();
+<a class="jxr_linenumber" name="387" href="#387">387</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="388" href="#388">388</a> LOG.debug(serverWorkerName + <span class="jxr_string">". dataLength :"</span> + dataLength + <span class="jxr_string">" availableBuffer :"</span> + availableBuffer);
+<a class="jxr_linenumber" name="389" href="#389">389</a> <strong class="jxr_keyword">if</strong> (dataLength > availableBuffer
<TRUNCATED>