trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dbirds...@apache.org
Subject [25/31] incubator-trafodion-site git commit: Rebuild Release 2.0.0 manuals for PRs 492 and 500
Date Wed, 25 May 2016 20:15:59 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/7af1709b/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html
----------------------------------------------------------------------
diff --git a/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html b/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html
index 63ebff2..34cf438 100644
--- a/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html
+++ b/docs/2.0.0/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html
@@ -32,264 +32,252 @@
 <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.util;
 <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.io.File;
-<a class="jxr_linenumber" name="26" href="#26">26</a>  <strong class="jxr_keyword">import</strong> java.io.FileInputStream;
-<a class="jxr_linenumber" name="27" href="#27">27</a>  <strong class="jxr_keyword">import</strong> java.io.FileNotFoundException;
-<a class="jxr_linenumber" name="28" href="#28">28</a>  <strong class="jxr_keyword">import</strong> java.io.IOException;
-<a class="jxr_linenumber" name="29" href="#29">29</a>  <strong class="jxr_keyword">import</strong> java.util.*;
-<a class="jxr_linenumber" name="30" href="#30">30</a>  <strong class="jxr_keyword">import</strong> java.sql.DriverManager;
-<a class="jxr_linenumber" name="31" href="#31">31</a>  <strong class="jxr_keyword">import</strong> java.sql.ResultSet;
-<a class="jxr_linenumber" name="32" href="#32">32</a>  <strong class="jxr_keyword">import</strong> java.sql.SQLException;
-<a class="jxr_linenumber" name="33" href="#33">33</a>  <strong class="jxr_keyword">import</strong> java.sql.Statement;
-<a class="jxr_linenumber" name="34" href="#34">34</a>  <strong class="jxr_keyword">import</strong> java.sql.Connection;
-<a class="jxr_linenumber" name="35" href="#35">35</a>  <strong class="jxr_keyword">import</strong> java.sql.PreparedStatement;
-<a class="jxr_linenumber" name="36" href="#36">36</a>  <strong class="jxr_keyword">import</strong> java.math.BigDecimal;
-<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.apache.commons.cli.CommandLine;
-<a class="jxr_linenumber" name="39" href="#39">39</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.cli.GnuParser;
-<a class="jxr_linenumber" name="40" href="#40">40</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.cli.Options;
-<a class="jxr_linenumber" name="41" href="#41">41</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.cli.ParseException;
-<a class="jxr_linenumber" name="42" href="#42">42</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.cli.HelpFormatter;
-<a class="jxr_linenumber" name="43" href="#43">43</a>  <strong class="jxr_keyword">import</strong> org.codehaus.jettison.json.JSONArray;
-<a class="jxr_linenumber" name="44" href="#44">44</a>  <strong class="jxr_keyword">import</strong> org.codehaus.jettison.json.JSONException;
-<a class="jxr_linenumber" name="45" href="#45">45</a>  <strong class="jxr_keyword">import</strong> org.codehaus.jettison.json.JSONObject;
-<a class="jxr_linenumber" name="46" href="#46">46</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.logging.Log;
-<a class="jxr_linenumber" name="47" href="#47">47</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.logging.LogFactory;
-<a class="jxr_linenumber" name="48" href="#48">48</a>  <strong class="jxr_keyword">import</strong> org.apache.hadoop.conf.Configuration;
-<a class="jxr_linenumber" name="49" href="#49">49</a>  <strong class="jxr_keyword">import</strong> org.trafodion.dcs.util.DcsConfiguration;
-<a class="jxr_linenumber" name="50" href="#50">50</a>  <strong class="jxr_keyword">import</strong> org.trafodion.dcs.Constants;
-<a class="jxr_linenumber" name="51" href="#51">51</a>  <strong class="jxr_keyword">import</strong> org.trafodion.jdbc.t4.TrafT4Connection;
-<a class="jxr_linenumber" name="52" href="#52">52</a>  <strong class="jxr_keyword">import</strong> org.trafodion.jdbc.t4.TrafT4PreparedStatement;
-<a class="jxr_linenumber" name="53" href="#53">53</a>  <strong class="jxr_keyword">import</strong> org.trafodion.jdbc.t4.HPT4DataSource;
-<a class="jxr_linenumber" name="54" href="#54">54</a>  
-<a class="jxr_linenumber" name="55" href="#55">55</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a>
-<a class="jxr_linenumber" name="56" href="#56">56</a>  {
-<a class="jxr_linenumber" name="57" href="#57">57</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> Log LOG = LogFactory.getLog(JdbcT4Util.<strong class="jxr_keyword">class</strong>);
-<a class="jxr_linenumber" name="58" href="#58">58</a>      <strong class="jxr_keyword">private</strong> Configuration conf;
-<a class="jxr_linenumber" name="59" href="#59">59</a>      <strong class="jxr_keyword">private</strong> <a href="../../../../org/trafodion/dcs/util/DcsNetworkConfiguration.html">DcsNetworkConfiguration</a> netConf;
-<a class="jxr_linenumber" name="60" href="#60">60</a>      <strong class="jxr_keyword">private</strong> HPT4DataSource cpds = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="61" href="#61">61</a>   
-<a class="jxr_linenumber" name="62" href="#62">62</a>      <strong class="jxr_keyword">static</strong>    {
-<a class="jxr_linenumber" name="63" href="#63">63</a>          <strong class="jxr_keyword">try</strong> {
-<a class="jxr_linenumber" name="64" href="#64">64</a>              Class.forName(Constants.T4_DRIVER_CLASS_NAME);
-<a class="jxr_linenumber" name="65" href="#65">65</a>          } <strong class="jxr_keyword">catch</strong> (ClassNotFoundException e) {
-<a class="jxr_linenumber" name="66" href="#66">66</a>              e.printStackTrace();
-<a class="jxr_linenumber" name="67" href="#67">67</a>              <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled())
-<a class="jxr_linenumber" name="68" href="#68">68</a>                  LOG.error(e.getMessage());
-<a class="jxr_linenumber" name="69" href="#69">69</a>          }
-<a class="jxr_linenumber" name="70" href="#70">70</a>      }
-<a class="jxr_linenumber" name="71" href="#71">71</a>  
-<a class="jxr_linenumber" name="72" href="#72">72</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> init(Configuration conf,DcsNetworkConfiguration netConf) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="73" href="#73">73</a>          <strong class="jxr_keyword">this</strong>.conf = conf;
-<a class="jxr_linenumber" name="74" href="#74">74</a>          <strong class="jxr_keyword">this</strong>.netConf = netConf;
-<a class="jxr_linenumber" name="75" href="#75">75</a>             cpds = <strong class="jxr_keyword">new</strong> HPT4DataSource();
-<a class="jxr_linenumber" name="76" href="#76">76</a>          String url = Constants.T4_DRIVER_URL + <span class="jxr_string">"//"</span> + netConf.getHostName() + <span class="jxr_string">":"</span> + conf.getInt(Constants.DCS_MASTER_PORT,Constants.DEFAULT_DCS_MASTER_PORT) + <span class="jxr_string">"/:"</span>;
-<a class="jxr_linenumber" name="77" href="#77">77</a>          cpds.setURL(url);
-<a class="jxr_linenumber" name="78" href="#78">78</a>          cpds.setMinPoolSize(conf.getInt(Constants.T4_DRIVER_MIN_POOL_SIZE,Constants.DEFAULT_T4_DRIVER_MIN_POOL_SIZE));
-<a class="jxr_linenumber" name="79" href="#79">79</a>          cpds.setMaxPoolSize(conf.getInt(Constants.T4_DRIVER_MAX_POOL_SIZE,Constants.DEFAULT_T4_DRIVER_MAX_POOL_SIZE));   
-<a class="jxr_linenumber" name="80" href="#80">80</a>          String s = conf.get(Constants.T4_DRIVER_USERNAME_PASSWORD,Constants.DEFAULT_T4_DRIVER_USERNAME_PASSWORD);
-<a class="jxr_linenumber" name="81" href="#81">81</a>          String base64UserPassword = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="82" href="#82">82</a>          <strong class="jxr_keyword">if</strong> (s != <strong class="jxr_keyword">null</strong>) 
-<a class="jxr_linenumber" name="83" href="#83">83</a>              base64UserPassword = s.trim();
-<a class="jxr_linenumber" name="84" href="#84">84</a>          <em class="jxr_comment">//LOG.debug("base64UserPassword=" + base64UserPassword);</em>
-<a class="jxr_linenumber" name="85" href="#85">85</a>          String userPassword = <strong class="jxr_keyword">new</strong> String(Base64.decode(base64UserPassword));
-<a class="jxr_linenumber" name="86" href="#86">86</a>          <em class="jxr_comment">//LOG.debug("userPassword=" + userPassword);</em>
-<a class="jxr_linenumber" name="87" href="#87">87</a>          <strong class="jxr_keyword">final</strong> String[] values = userPassword.split(<span class="jxr_string">":"</span>,2);
-<a class="jxr_linenumber" name="88" href="#88">88</a>          cpds.setUser(values[0]);
-<a class="jxr_linenumber" name="89" href="#89">89</a>          cpds.setPassword(values[1]);
-<a class="jxr_linenumber" name="90" href="#90">90</a>      }
-<a class="jxr_linenumber" name="91" href="#91">91</a>      
-<a class="jxr_linenumber" name="92" href="#92">92</a>      <strong class="jxr_keyword">public</strong> <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a>() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="93" href="#93">93</a>          Configuration conf = DcsConfiguration.create();
-<a class="jxr_linenumber" name="94" href="#94">94</a>             <a href="../../../../org/trafodion/dcs/util/DcsNetworkConfiguration.html">DcsNetworkConfiguration</a> netConf = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/util/DcsNetworkConfiguration.html">DcsNetworkConfiguration</a>(conf);
-<a class="jxr_linenumber" name="95" href="#95">95</a>          init(conf,netConf);
-<a class="jxr_linenumber" name="96" href="#96">96</a>      }
-<a class="jxr_linenumber" name="97" href="#97">97</a>      
-<a class="jxr_linenumber" name="98" href="#98">98</a>      <strong class="jxr_keyword">public</strong> <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a>(Configuration conf,DcsNetworkConfiguration netConf) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="99" href="#99">99</a>          init(conf,netConf);
-<a class="jxr_linenumber" name="100" href="#100">100</a>     }
+<a class="jxr_linenumber" name="25" href="#25">25</a>  <strong class="jxr_keyword">import</strong> java.sql.ResultSet;
+<a class="jxr_linenumber" name="26" href="#26">26</a>  <strong class="jxr_keyword">import</strong> java.sql.SQLException;
+<a class="jxr_linenumber" name="27" href="#27">27</a>  <strong class="jxr_keyword">import</strong> java.sql.Statement;
+<a class="jxr_linenumber" name="28" href="#28">28</a>  
+<a class="jxr_linenumber" name="29" href="#29">29</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.cli.CommandLine;
+<a class="jxr_linenumber" name="30" href="#30">30</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.cli.GnuParser;
+<a class="jxr_linenumber" name="31" href="#31">31</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.cli.HelpFormatter;
+<a class="jxr_linenumber" name="32" href="#32">32</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.cli.Options;
+<a class="jxr_linenumber" name="33" href="#33">33</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.logging.Log;
+<a class="jxr_linenumber" name="34" href="#34">34</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.logging.LogFactory;
+<a class="jxr_linenumber" name="35" href="#35">35</a>  <strong class="jxr_keyword">import</strong> org.apache.hadoop.conf.Configuration;
+<a class="jxr_linenumber" name="36" href="#36">36</a>  <strong class="jxr_keyword">import</strong> org.codehaus.jettison.json.JSONArray;
+<a class="jxr_linenumber" name="37" href="#37">37</a>  <strong class="jxr_keyword">import</strong> org.codehaus.jettison.json.JSONObject;
+<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.jdbc.t4.TrafT4Connection;
+<a class="jxr_linenumber" name="40" href="#40">40</a>  <strong class="jxr_keyword">import</strong> org.trafodion.jdbc.t4.TrafT4DataSource;
+<a class="jxr_linenumber" name="41" href="#41">41</a>  <strong class="jxr_keyword">import</strong> org.trafodion.jdbc.t4.TrafT4PreparedStatement;
+<a class="jxr_linenumber" name="42" href="#42">42</a>  
+<a class="jxr_linenumber" name="43" href="#43">43</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a>
+<a class="jxr_linenumber" name="44" href="#44">44</a>  {
+<a class="jxr_linenumber" name="45" href="#45">45</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> Log LOG = LogFactory.getLog(JdbcT4Util.<strong class="jxr_keyword">class</strong>);
+<a class="jxr_linenumber" name="46" href="#46">46</a>      <strong class="jxr_keyword">private</strong> Configuration conf;
+<a class="jxr_linenumber" name="47" href="#47">47</a>      <strong class="jxr_keyword">private</strong> <a href="../../../../org/trafodion/dcs/util/DcsNetworkConfiguration.html">DcsNetworkConfiguration</a> netConf;
+<a class="jxr_linenumber" name="48" href="#48">48</a>      <strong class="jxr_keyword">private</strong> TrafT4DataSource cpds = <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="49" href="#49">49</a>   
+<a class="jxr_linenumber" name="50" href="#50">50</a>      <strong class="jxr_keyword">static</strong>    {
+<a class="jxr_linenumber" name="51" href="#51">51</a>          <strong class="jxr_keyword">try</strong> {
+<a class="jxr_linenumber" name="52" href="#52">52</a>              Class.forName(Constants.T4_DRIVER_CLASS_NAME);
+<a class="jxr_linenumber" name="53" href="#53">53</a>          } <strong class="jxr_keyword">catch</strong> (ClassNotFoundException e) {
+<a class="jxr_linenumber" name="54" href="#54">54</a>              e.printStackTrace();
+<a class="jxr_linenumber" name="55" href="#55">55</a>              <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled())
+<a class="jxr_linenumber" name="56" href="#56">56</a>                  LOG.error(e.getMessage());
+<a class="jxr_linenumber" name="57" href="#57">57</a>          }
+<a class="jxr_linenumber" name="58" href="#58">58</a>      }
+<a class="jxr_linenumber" name="59" href="#59">59</a>  
+<a class="jxr_linenumber" name="60" href="#60">60</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> init(Configuration conf,DcsNetworkConfiguration netConf) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="61" href="#61">61</a>          <strong class="jxr_keyword">this</strong>.conf = conf;
+<a class="jxr_linenumber" name="62" href="#62">62</a>          <strong class="jxr_keyword">this</strong>.netConf = netConf;
+<a class="jxr_linenumber" name="63" href="#63">63</a>             cpds = <strong class="jxr_keyword">new</strong> TrafT4DataSource();
+<a class="jxr_linenumber" name="64" href="#64">64</a>          String url = Constants.T4_DRIVER_URL + <span class="jxr_string">"//"</span> + netConf.getHostName() + <span class="jxr_string">":"</span> + conf.getInt(Constants.DCS_MASTER_PORT,Constants.DEFAULT_DCS_MASTER_PORT) + <span class="jxr_string">"/:"</span>;
+<a class="jxr_linenumber" name="65" href="#65">65</a>          cpds.setURL(url);
+<a class="jxr_linenumber" name="66" href="#66">66</a>          cpds.setMinPoolSize(conf.getInt(Constants.T4_DRIVER_MIN_POOL_SIZE,Constants.DEFAULT_T4_DRIVER_MIN_POOL_SIZE));
+<a class="jxr_linenumber" name="67" href="#67">67</a>          cpds.setMaxPoolSize(conf.getInt(Constants.T4_DRIVER_MAX_POOL_SIZE,Constants.DEFAULT_T4_DRIVER_MAX_POOL_SIZE));   
+<a class="jxr_linenumber" name="68" href="#68">68</a>          String s = conf.get(Constants.T4_DRIVER_USERNAME_PASSWORD,Constants.DEFAULT_T4_DRIVER_USERNAME_PASSWORD);
+<a class="jxr_linenumber" name="69" href="#69">69</a>          String base64UserPassword = <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="70" href="#70">70</a>          <strong class="jxr_keyword">if</strong> (s != <strong class="jxr_keyword">null</strong>) 
+<a class="jxr_linenumber" name="71" href="#71">71</a>              base64UserPassword = s.trim();
+<a class="jxr_linenumber" name="72" href="#72">72</a>          <em class="jxr_comment">//LOG.debug("base64UserPassword=" + base64UserPassword);</em>
+<a class="jxr_linenumber" name="73" href="#73">73</a>          String userPassword = <strong class="jxr_keyword">new</strong> String(Base64.decode(base64UserPassword));
+<a class="jxr_linenumber" name="74" href="#74">74</a>          <em class="jxr_comment">//LOG.debug("userPassword=" + userPassword);</em>
+<a class="jxr_linenumber" name="75" href="#75">75</a>          <strong class="jxr_keyword">final</strong> String[] values = userPassword.split(<span class="jxr_string">":"</span>,2);
+<a class="jxr_linenumber" name="76" href="#76">76</a>          cpds.setUser(values[0]);
+<a class="jxr_linenumber" name="77" href="#77">77</a>          cpds.setPassword(values[1]);
+<a class="jxr_linenumber" name="78" href="#78">78</a>      }
+<a class="jxr_linenumber" name="79" href="#79">79</a>      
+<a class="jxr_linenumber" name="80" href="#80">80</a>      <strong class="jxr_keyword">public</strong> <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a>() <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="81" href="#81">81</a>          Configuration conf = DcsConfiguration.create();
+<a class="jxr_linenumber" name="82" href="#82">82</a>             <a href="../../../../org/trafodion/dcs/util/DcsNetworkConfiguration.html">DcsNetworkConfiguration</a> netConf = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/util/DcsNetworkConfiguration.html">DcsNetworkConfiguration</a>(conf);
+<a class="jxr_linenumber" name="83" href="#83">83</a>          init(conf,netConf);
+<a class="jxr_linenumber" name="84" href="#84">84</a>      }
+<a class="jxr_linenumber" name="85" href="#85">85</a>      
+<a class="jxr_linenumber" name="86" href="#86">86</a>      <strong class="jxr_keyword">public</strong> <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a>(Configuration conf,DcsNetworkConfiguration netConf) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="87" href="#87">87</a>          init(conf,netConf);
+<a class="jxr_linenumber" name="88" href="#88">88</a>      }
+<a class="jxr_linenumber" name="89" href="#89">89</a>  
+<a class="jxr_linenumber" name="90" href="#90">90</a>      <strong class="jxr_keyword">public</strong> java.sql.Connection getConnection() <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="91" href="#91">91</a>          <strong class="jxr_keyword">return</strong> cpds.getConnection();
+<a class="jxr_linenumber" name="92" href="#92">92</a>      }
+<a class="jxr_linenumber" name="93" href="#93">93</a>      
+<a class="jxr_linenumber" name="94" href="#94">94</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> JSONArray convertResultSetToJSON(java.sql.ResultSet rs) <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="95" href="#95">95</a>          <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="96" href="#96">96</a>              LOG.debug(<span class="jxr_string">"Begin convertResultSetToJSON"</span>);
+<a class="jxr_linenumber" name="97" href="#97">97</a>          
+<a class="jxr_linenumber" name="98" href="#98">98</a>          JSONArray json = <strong class="jxr_keyword">new</strong> JSONArray();
+<a class="jxr_linenumber" name="99" href="#99">99</a>  
+<a class="jxr_linenumber" name="100" href="#100">100</a>         <strong class="jxr_keyword">try</strong> { 
 <a class="jxr_linenumber" name="101" href="#101">101</a> 
-<a class="jxr_linenumber" name="102" href="#102">102</a>     <strong class="jxr_keyword">public</strong> java.sql.Connection getConnection() <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="103" href="#103">103</a>         <strong class="jxr_keyword">return</strong> cpds.getConnection();
-<a class="jxr_linenumber" name="104" href="#104">104</a>     }
-<a class="jxr_linenumber" name="105" href="#105">105</a>     
-<a class="jxr_linenumber" name="106" href="#106">106</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> JSONArray convertResultSetToJSON(java.sql.ResultSet rs) <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="107" href="#107">107</a>         <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="108" href="#108">108</a>             LOG.debug(<span class="jxr_string">"Begin convertResultSetToJSON"</span>);
-<a class="jxr_linenumber" name="109" href="#109">109</a>         
-<a class="jxr_linenumber" name="110" href="#110">110</a>         JSONArray json = <strong class="jxr_keyword">new</strong> JSONArray();
+<a class="jxr_linenumber" name="102" href="#102">102</a>             java.sql.ResultSetMetaData rsmd = rs.getMetaData(); 
+<a class="jxr_linenumber" name="103" href="#103">103</a> 
+<a class="jxr_linenumber" name="104" href="#104">104</a>             <strong class="jxr_keyword">while</strong>(rs.next()){ 
+<a class="jxr_linenumber" name="105" href="#105">105</a>                 <strong class="jxr_keyword">int</strong> numColumns = rsmd.getColumnCount(); 
+<a class="jxr_linenumber" name="106" href="#106">106</a>                 JSONObject obj = <strong class="jxr_keyword">new</strong> JSONObject(); 
+<a class="jxr_linenumber" name="107" href="#107">107</a> 
+<a class="jxr_linenumber" name="108" href="#108">108</a>                 <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i=1; i&lt;numColumns+1; i++) { 
+<a class="jxr_linenumber" name="109" href="#109">109</a> 
+<a class="jxr_linenumber" name="110" href="#110">110</a>                     String column_name = rsmd.getColumnName(i); 
 <a class="jxr_linenumber" name="111" href="#111">111</a> 
-<a class="jxr_linenumber" name="112" href="#112">112</a>         <strong class="jxr_keyword">try</strong> { 
-<a class="jxr_linenumber" name="113" href="#113">113</a> 
-<a class="jxr_linenumber" name="114" href="#114">114</a>             java.sql.ResultSetMetaData rsmd = rs.getMetaData(); 
-<a class="jxr_linenumber" name="115" href="#115">115</a> 
-<a class="jxr_linenumber" name="116" href="#116">116</a>             <strong class="jxr_keyword">while</strong>(rs.next()){ 
-<a class="jxr_linenumber" name="117" href="#117">117</a>                 <strong class="jxr_keyword">int</strong> numColumns = rsmd.getColumnCount(); 
-<a class="jxr_linenumber" name="118" href="#118">118</a>                 JSONObject obj = <strong class="jxr_keyword">new</strong> JSONObject(); 
-<a class="jxr_linenumber" name="119" href="#119">119</a> 
-<a class="jxr_linenumber" name="120" href="#120">120</a>                 <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i=1; i&lt;numColumns+1; i++) { 
-<a class="jxr_linenumber" name="121" href="#121">121</a> 
-<a class="jxr_linenumber" name="122" href="#122">122</a>                     String column_name = rsmd.getColumnName(i); 
-<a class="jxr_linenumber" name="123" href="#123">123</a> 
-<a class="jxr_linenumber" name="124" href="#124">124</a>                     <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.ARRAY){ 
-<a class="jxr_linenumber" name="125" href="#125">125</a>                         obj.put(column_name, rs.getArray(column_name)); 
+<a class="jxr_linenumber" name="112" href="#112">112</a>                     <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.ARRAY){ 
+<a class="jxr_linenumber" name="113" href="#113">113</a>                         obj.put(column_name, rs.getArray(column_name)); 
+<a class="jxr_linenumber" name="114" href="#114">114</a>                     } 
+<a class="jxr_linenumber" name="115" href="#115">115</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.BIGINT){ 
+<a class="jxr_linenumber" name="116" href="#116">116</a>                         obj.put(column_name, rs.getLong(column_name)); 
+<a class="jxr_linenumber" name="117" href="#117">117</a>                     } 
+<a class="jxr_linenumber" name="118" href="#118">118</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.BOOLEAN){ 
+<a class="jxr_linenumber" name="119" href="#119">119</a>                         obj.put(column_name, rs.getBoolean(column_name)); 
+<a class="jxr_linenumber" name="120" href="#120">120</a>                     } 
+<a class="jxr_linenumber" name="121" href="#121">121</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.BLOB){ 
+<a class="jxr_linenumber" name="122" href="#122">122</a>                         obj.put(column_name, rs.getBlob(column_name)); 
+<a class="jxr_linenumber" name="123" href="#123">123</a>                     } 
+<a class="jxr_linenumber" name="124" href="#124">124</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.DOUBLE){ 
+<a class="jxr_linenumber" name="125" href="#125">125</a>                         obj.put(column_name, rs.getDouble(column_name));  
 <a class="jxr_linenumber" name="126" href="#126">126</a>                     } 
-<a class="jxr_linenumber" name="127" href="#127">127</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.BIGINT){ 
-<a class="jxr_linenumber" name="128" href="#128">128</a>                         obj.put(column_name, rs.getLong(column_name)); 
+<a class="jxr_linenumber" name="127" href="#127">127</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.FLOAT){ 
+<a class="jxr_linenumber" name="128" href="#128">128</a>                         obj.put(column_name, rs.getFloat(column_name)); 
 <a class="jxr_linenumber" name="129" href="#129">129</a>                     } 
-<a class="jxr_linenumber" name="130" href="#130">130</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.BOOLEAN){ 
-<a class="jxr_linenumber" name="131" href="#131">131</a>                         obj.put(column_name, rs.getBoolean(column_name)); 
+<a class="jxr_linenumber" name="130" href="#130">130</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.INTEGER){ 
+<a class="jxr_linenumber" name="131" href="#131">131</a>                         obj.put(column_name, rs.getInt(column_name)); 
 <a class="jxr_linenumber" name="132" href="#132">132</a>                     } 
-<a class="jxr_linenumber" name="133" href="#133">133</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.BLOB){ 
-<a class="jxr_linenumber" name="134" href="#134">134</a>                         obj.put(column_name, rs.getBlob(column_name)); 
+<a class="jxr_linenumber" name="133" href="#133">133</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.NVARCHAR){ 
+<a class="jxr_linenumber" name="134" href="#134">134</a>                         obj.put(column_name, rs.getNString(column_name)); 
 <a class="jxr_linenumber" name="135" href="#135">135</a>                     } 
-<a class="jxr_linenumber" name="136" href="#136">136</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.DOUBLE){ 
-<a class="jxr_linenumber" name="137" href="#137">137</a>                         obj.put(column_name, rs.getDouble(column_name));  
-<a class="jxr_linenumber" name="138" href="#138">138</a>                     } 
-<a class="jxr_linenumber" name="139" href="#139">139</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.FLOAT){ 
-<a class="jxr_linenumber" name="140" href="#140">140</a>                         obj.put(column_name, rs.getFloat(column_name)); 
-<a class="jxr_linenumber" name="141" href="#141">141</a>                     } 
-<a class="jxr_linenumber" name="142" href="#142">142</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.INTEGER){ 
-<a class="jxr_linenumber" name="143" href="#143">143</a>                         obj.put(column_name, rs.getInt(column_name)); 
-<a class="jxr_linenumber" name="144" href="#144">144</a>                     } 
-<a class="jxr_linenumber" name="145" href="#145">145</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.NVARCHAR){ 
-<a class="jxr_linenumber" name="146" href="#146">146</a>                         obj.put(column_name, rs.getNString(column_name)); 
+<a class="jxr_linenumber" name="136" href="#136">136</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.CHAR || 
+<a class="jxr_linenumber" name="137" href="#137">137</a>                             rsmd.getColumnType(i)==java.sql.Types.VARCHAR){ 
+<a class="jxr_linenumber" name="138" href="#138">138</a>                         <em class="jxr_comment">//prevent obj.put from removing null key value from JSONObject</em>
+<a class="jxr_linenumber" name="139" href="#139">139</a>                         String s = rs.getString(column_name);
+<a class="jxr_linenumber" name="140" href="#140">140</a>                         <strong class="jxr_keyword">if</strong>(s == <strong class="jxr_keyword">null</strong>)
+<a class="jxr_linenumber" name="141" href="#141">141</a>                             obj.put(column_name, <strong class="jxr_keyword">new</strong> String(<span class="jxr_string">""</span>)); 
+<a class="jxr_linenumber" name="142" href="#142">142</a>                         <strong class="jxr_keyword">else</strong>
+<a class="jxr_linenumber" name="143" href="#143">143</a>                             obj.put(column_name, rs.getString(column_name)); 
+<a class="jxr_linenumber" name="144" href="#144">144</a>                     }                     
+<a class="jxr_linenumber" name="145" href="#145">145</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.TINYINT){ 
+<a class="jxr_linenumber" name="146" href="#146">146</a>                         obj.put(column_name, rs.getInt(column_name)); 
 <a class="jxr_linenumber" name="147" href="#147">147</a>                     } 
-<a class="jxr_linenumber" name="148" href="#148">148</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.CHAR || 
-<a class="jxr_linenumber" name="149" href="#149">149</a>                             rsmd.getColumnType(i)==java.sql.Types.VARCHAR){ 
-<a class="jxr_linenumber" name="150" href="#150">150</a>                         <em class="jxr_comment">//prevent obj.put from removing null key value from JSONObject</em>
-<a class="jxr_linenumber" name="151" href="#151">151</a>                         String s = rs.getString(column_name);
-<a class="jxr_linenumber" name="152" href="#152">152</a>                         <strong class="jxr_keyword">if</strong>(s == <strong class="jxr_keyword">null</strong>)
-<a class="jxr_linenumber" name="153" href="#153">153</a>                             obj.put(column_name, <strong class="jxr_keyword">new</strong> String(<span class="jxr_string">""</span>)); 
-<a class="jxr_linenumber" name="154" href="#154">154</a>                         <strong class="jxr_keyword">else</strong>
-<a class="jxr_linenumber" name="155" href="#155">155</a>                             obj.put(column_name, rs.getString(column_name)); 
-<a class="jxr_linenumber" name="156" href="#156">156</a>                     }                     
-<a class="jxr_linenumber" name="157" href="#157">157</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.TINYINT){ 
-<a class="jxr_linenumber" name="158" href="#158">158</a>                         obj.put(column_name, rs.getInt(column_name)); 
-<a class="jxr_linenumber" name="159" href="#159">159</a>                     } 
-<a class="jxr_linenumber" name="160" href="#160">160</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.SMALLINT){ 
-<a class="jxr_linenumber" name="161" href="#161">161</a>                         obj.put(column_name, rs.getInt(column_name)); 
-<a class="jxr_linenumber" name="162" href="#162">162</a>                     } 
-<a class="jxr_linenumber" name="163" href="#163">163</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.DATE){ 
-<a class="jxr_linenumber" name="164" href="#164">164</a>                         obj.put(column_name, rs.getDate(column_name)); 
-<a class="jxr_linenumber" name="165" href="#165">165</a>                     } 
-<a class="jxr_linenumber" name="166" href="#166">166</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.TIMESTAMP){ 
-<a class="jxr_linenumber" name="167" href="#167">167</a>                         obj.put(column_name, rs.getTimestamp(column_name));    
-<a class="jxr_linenumber" name="168" href="#168">168</a>                     } 
-<a class="jxr_linenumber" name="169" href="#169">169</a>                     <strong class="jxr_keyword">else</strong>{ 
-<a class="jxr_linenumber" name="170" href="#170">170</a>                         obj.put(column_name, rs.getObject(column_name)); 
-<a class="jxr_linenumber" name="171" href="#171">171</a>                     }  
+<a class="jxr_linenumber" name="148" href="#148">148</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.SMALLINT){ 
+<a class="jxr_linenumber" name="149" href="#149">149</a>                         obj.put(column_name, rs.getInt(column_name)); 
+<a class="jxr_linenumber" name="150" href="#150">150</a>                     } 
+<a class="jxr_linenumber" name="151" href="#151">151</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.DATE){ 
+<a class="jxr_linenumber" name="152" href="#152">152</a>                         obj.put(column_name, rs.getDate(column_name)); 
+<a class="jxr_linenumber" name="153" href="#153">153</a>                     } 
+<a class="jxr_linenumber" name="154" href="#154">154</a>                     <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong>(rsmd.getColumnType(i)==java.sql.Types.TIMESTAMP){ 
+<a class="jxr_linenumber" name="155" href="#155">155</a>                         obj.put(column_name, rs.getTimestamp(column_name));    
+<a class="jxr_linenumber" name="156" href="#156">156</a>                     } 
+<a class="jxr_linenumber" name="157" href="#157">157</a>                     <strong class="jxr_keyword">else</strong>{ 
+<a class="jxr_linenumber" name="158" href="#158">158</a>                         obj.put(column_name, rs.getObject(column_name)); 
+<a class="jxr_linenumber" name="159" href="#159">159</a>                     }  
+<a class="jxr_linenumber" name="160" href="#160">160</a> 
+<a class="jxr_linenumber" name="161" href="#161">161</a>                 }<em class="jxr_comment">//end foreach </em>
+<a class="jxr_linenumber" name="162" href="#162">162</a>                 json.put(obj); 
+<a class="jxr_linenumber" name="163" href="#163">163</a> 
+<a class="jxr_linenumber" name="164" href="#164">164</a>             }<em class="jxr_comment">//end while </em>
+<a class="jxr_linenumber" name="165" href="#165">165</a>             
+<a class="jxr_linenumber" name="166" href="#166">166</a>             <strong class="jxr_keyword">if</strong>(json.length() == 0){
+<a class="jxr_linenumber" name="167" href="#167">167</a> 
+<a class="jxr_linenumber" name="168" href="#168">168</a>                 <strong class="jxr_keyword">int</strong> numColumns = rsmd.getColumnCount(); 
+<a class="jxr_linenumber" name="169" href="#169">169</a>                 JSONObject obj = <strong class="jxr_keyword">new</strong> JSONObject(); 
+<a class="jxr_linenumber" name="170" href="#170">170</a> 
+<a class="jxr_linenumber" name="171" href="#171">171</a>                 <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i=1; i&lt;numColumns+1; i++) { 
 <a class="jxr_linenumber" name="172" href="#172">172</a> 
-<a class="jxr_linenumber" name="173" href="#173">173</a>                 }<em class="jxr_comment">//end foreach </em>
-<a class="jxr_linenumber" name="174" href="#174">174</a>                 json.put(obj); 
-<a class="jxr_linenumber" name="175" href="#175">175</a> 
-<a class="jxr_linenumber" name="176" href="#176">176</a>             }<em class="jxr_comment">//end while </em>
-<a class="jxr_linenumber" name="177" href="#177">177</a>             
-<a class="jxr_linenumber" name="178" href="#178">178</a>             <strong class="jxr_keyword">if</strong>(json.length() == 0){
-<a class="jxr_linenumber" name="179" href="#179">179</a> 
-<a class="jxr_linenumber" name="180" href="#180">180</a>                 <strong class="jxr_keyword">int</strong> numColumns = rsmd.getColumnCount(); 
-<a class="jxr_linenumber" name="181" href="#181">181</a>                 JSONObject obj = <strong class="jxr_keyword">new</strong> JSONObject(); 
-<a class="jxr_linenumber" name="182" href="#182">182</a> 
-<a class="jxr_linenumber" name="183" href="#183">183</a>                 <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i=1; i&lt;numColumns+1; i++) { 
-<a class="jxr_linenumber" name="184" href="#184">184</a> 
-<a class="jxr_linenumber" name="185" href="#185">185</a>                     String column_name = rsmd.getColumnName(i);
-<a class="jxr_linenumber" name="186" href="#186">186</a>                     obj.put(column_name, <span class="jxr_string">""</span>);
-<a class="jxr_linenumber" name="187" href="#187">187</a>                 }
-<a class="jxr_linenumber" name="188" href="#188">188</a>                 json.put(obj);
-<a class="jxr_linenumber" name="189" href="#189">189</a>             }
-<a class="jxr_linenumber" name="190" href="#190">190</a> 
-<a class="jxr_linenumber" name="191" href="#191">191</a>         } <strong class="jxr_keyword">catch</strong> (SQLException e) { 
-<a class="jxr_linenumber" name="192" href="#192">192</a>             e.printStackTrace(); 
-<a class="jxr_linenumber" name="193" href="#193">193</a>             <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="194" href="#194">194</a>                 LOG.error(e.getMessage());
-<a class="jxr_linenumber" name="195" href="#195">195</a>             <strong class="jxr_keyword">throw</strong> e;
-<a class="jxr_linenumber" name="196" href="#196">196</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) { 
-<a class="jxr_linenumber" name="197" href="#197">197</a>             e.printStackTrace(); 
-<a class="jxr_linenumber" name="198" href="#198">198</a>             <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="199" href="#199">199</a>                 LOG.error(e.getMessage());
-<a class="jxr_linenumber" name="200" href="#200">200</a>             <strong class="jxr_keyword">throw</strong> e;
-<a class="jxr_linenumber" name="201" href="#201">201</a>         }
-<a class="jxr_linenumber" name="202" href="#202">202</a>         
-<a class="jxr_linenumber" name="203" href="#203">203</a>         <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="204" href="#204">204</a>             LOG.debug(<span class="jxr_string">"End convertResultSetToJSON"</span>);
-<a class="jxr_linenumber" name="205" href="#205">205</a> 
-<a class="jxr_linenumber" name="206" href="#206">206</a>         <strong class="jxr_keyword">return</strong> json; 
-<a class="jxr_linenumber" name="207" href="#207">207</a>     }
-<a class="jxr_linenumber" name="208" href="#208">208</a> 
-<a class="jxr_linenumber" name="209" href="#209">209</a>     
-<a class="jxr_linenumber" name="210" href="#210">210</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">void</strong> main(String args[]) {
-<a class="jxr_linenumber" name="211" href="#211">211</a>         Options options = <strong class="jxr_keyword">new</strong> Options();
-<a class="jxr_linenumber" name="212" href="#212">212</a>         options.addOption(<span class="jxr_string">"h"</span>,<span class="jxr_string">"help"</span>,false,<span class="jxr_string">"print this message"</span>);
-<a class="jxr_linenumber" name="213" href="#213">213</a>         options.addOption(<span class="jxr_string">"q"</span>,<span class="jxr_string">"queryText"</span>,<strong class="jxr_keyword">true</strong>,<span class="jxr_string">"SQL query text to execute"</span>);
-<a class="jxr_linenumber" name="214" href="#214">214</a>         HelpFormatter formatter = <strong class="jxr_keyword">new</strong> HelpFormatter();
-<a class="jxr_linenumber" name="215" href="#215">215</a>               
-<a class="jxr_linenumber" name="216" href="#216">216</a>         CommandLine commandLine;
-<a class="jxr_linenumber" name="217" href="#217">217</a>         String queryText = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="218" href="#218">218</a>         StringBuilder sb = <strong class="jxr_keyword">new</strong> StringBuilder();
-<a class="jxr_linenumber" name="219" href="#219">219</a>         
-<a class="jxr_linenumber" name="220" href="#220">220</a>         <strong class="jxr_keyword">try</strong> {
-<a class="jxr_linenumber" name="221" href="#221">221</a>             commandLine = <strong class="jxr_keyword">new</strong> GnuParser().parse(options, args);
-<a class="jxr_linenumber" name="222" href="#222">222</a>             <strong class="jxr_keyword">if</strong> (commandLine.hasOption(<span class="jxr_string">"help"</span>)) {
-<a class="jxr_linenumber" name="223" href="#223">223</a>                 formatter.printHelp(<span class="jxr_string">"JdbcT4Util"</span>,options);
-<a class="jxr_linenumber" name="224" href="#224">224</a>                 System.exit(0);
-<a class="jxr_linenumber" name="225" href="#225">225</a>             }
-<a class="jxr_linenumber" name="226" href="#226">226</a>             <strong class="jxr_keyword">if</strong> (commandLine.hasOption(<span class="jxr_string">"queryText"</span>)) {
-<a class="jxr_linenumber" name="227" href="#227">227</a>                 queryText = commandLine.getOptionValue(<span class="jxr_string">"q"</span>);
-<a class="jxr_linenumber" name="228" href="#228">228</a>             }
-<a class="jxr_linenumber" name="229" href="#229">229</a>             <strong class="jxr_keyword">if</strong> (queryText == <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="230" href="#230">230</a>                 formatter.printHelp(<span class="jxr_string">"JdbcT4Util"</span>,options);
-<a class="jxr_linenumber" name="231" href="#231">231</a>                 System.exit(-1);
-<a class="jxr_linenumber" name="232" href="#232">232</a>             }
-<a class="jxr_linenumber" name="233" href="#233">233</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) {
-<a class="jxr_linenumber" name="234" href="#234">234</a>             formatter.printHelp(<span class="jxr_string">"JdbcT4Util"</span>,options);
-<a class="jxr_linenumber" name="235" href="#235">235</a>             System.exit(-1);
-<a class="jxr_linenumber" name="236" href="#236">236</a>         }
-<a class="jxr_linenumber" name="237" href="#237">237</a> 
-<a class="jxr_linenumber" name="238" href="#238">238</a>         <strong class="jxr_keyword">try</strong>    {
-<a class="jxr_linenumber" name="239" href="#239">239</a>             <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a> jdbcT4Util = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a>();
-<a class="jxr_linenumber" name="240" href="#240">240</a>             TrafT4Connection connection = (TrafT4Connection) jdbcT4Util.getConnection();
-<a class="jxr_linenumber" name="241" href="#241">241</a>             
-<a class="jxr_linenumber" name="242" href="#242">242</a>             <em class="jxr_comment">//Regular Statement</em>
-<a class="jxr_linenumber" name="243" href="#243">243</a>             Statement stmt = connection.createStatement();
-<a class="jxr_linenumber" name="244" href="#244">244</a>             ResultSet rs = stmt.executeQuery(queryText);
-<a class="jxr_linenumber" name="245" href="#245">245</a>             JSONArray js = <strong class="jxr_keyword">new</strong> JSONArray();
-<a class="jxr_linenumber" name="246" href="#246">246</a>             js = convertResultSetToJSON(rs);
-<a class="jxr_linenumber" name="247" href="#247">247</a>             <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled()) 
-<a class="jxr_linenumber" name="248" href="#248">248</a>                 LOG.error(js.toString());
-<a class="jxr_linenumber" name="249" href="#249">249</a>             rs.close();
-<a class="jxr_linenumber" name="250" href="#250">250</a>             stmt.close();
-<a class="jxr_linenumber" name="251" href="#251">251</a>             
-<a class="jxr_linenumber" name="252" href="#252">252</a>             <em class="jxr_comment">//PreparedStatement with explain</em>
-<a class="jxr_linenumber" name="253" href="#253">253</a>             TrafT4PreparedStatement pStmt = (TrafT4PreparedStatement) connection.prepareStatement(queryText, <span class="jxr_string">"SQL_CURSOR_DEMO"</span>);
-<a class="jxr_linenumber" name="254" href="#254">254</a>             rs = pStmt.executeQuery(<span class="jxr_string">"SELECT * FROM TABLE(explain(null, 'SQL_CURSOR_DEMO'))"</span>);
-<a class="jxr_linenumber" name="255" href="#255">255</a>             js = <strong class="jxr_keyword">new</strong> JSONArray();
-<a class="jxr_linenumber" name="256" href="#256">256</a>             js = convertResultSetToJSON(rs);
-<a class="jxr_linenumber" name="257" href="#257">257</a>             <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled()) 
-<a class="jxr_linenumber" name="258" href="#258">258</a>                 LOG.error(js.toString());
-<a class="jxr_linenumber" name="259" href="#259">259</a>             rs.close();
-<a class="jxr_linenumber" name="260" href="#260">260</a>             stmt.close();
-<a class="jxr_linenumber" name="261" href="#261">261</a> 
-<a class="jxr_linenumber" name="262" href="#262">262</a>             System.exit(0);
-<a class="jxr_linenumber" name="263" href="#263">263</a>         } <strong class="jxr_keyword">catch</strong> (SQLException e) {
-<a class="jxr_linenumber" name="264" href="#264">264</a>             SQLException nextException = e;
-<a class="jxr_linenumber" name="265" href="#265">265</a>             <strong class="jxr_keyword">do</strong> {
-<a class="jxr_linenumber" name="266" href="#266">266</a>                 sb.append(nextException.getMessage());
-<a class="jxr_linenumber" name="267" href="#267">267</a>                 sb.append(<span class="jxr_string">"\nSQLState   "</span> + nextException.getSQLState());
-<a class="jxr_linenumber" name="268" href="#268">268</a>                 sb.append(<span class="jxr_string">"\nError Code "</span> + nextException.getErrorCode());
-<a class="jxr_linenumber" name="269" href="#269">269</a>             } <strong class="jxr_keyword">while</strong> ((nextException = nextException.getNextException()) != <strong class="jxr_keyword">null</strong>);
-<a class="jxr_linenumber" name="270" href="#270">270</a>             <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled()) 
-<a class="jxr_linenumber" name="271" href="#271">271</a>                 LOG.error(<span class="jxr_string">"SQLException ["</span> + sb.toString() + <span class="jxr_string">"]"</span>);    
-<a class="jxr_linenumber" name="272" href="#272">272</a>             System.exit(1);
-<a class="jxr_linenumber" name="273" href="#273">273</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) {
-<a class="jxr_linenumber" name="274" href="#274">274</a>             e.printStackTrace();
-<a class="jxr_linenumber" name="275" href="#275">275</a>             sb.append(e.getMessage());
-<a class="jxr_linenumber" name="276" href="#276">276</a>             <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
-<a class="jxr_linenumber" name="277" href="#277">277</a>                 LOG.debug(<span class="jxr_string">"Exception ["</span> + sb.toString() + <span class="jxr_string">"]"</span>);
-<a class="jxr_linenumber" name="278" href="#278">278</a>             System.exit(1);
-<a class="jxr_linenumber" name="279" href="#279">279</a>         } 
-<a class="jxr_linenumber" name="280" href="#280">280</a>     }
-<a class="jxr_linenumber" name="281" href="#281">281</a>     
-<a class="jxr_linenumber" name="282" href="#282">282</a> }
+<a class="jxr_linenumber" name="173" href="#173">173</a>                     String column_name = rsmd.getColumnName(i);
+<a class="jxr_linenumber" name="174" href="#174">174</a>                     obj.put(column_name, <span class="jxr_string">""</span>);
+<a class="jxr_linenumber" name="175" href="#175">175</a>                 }
+<a class="jxr_linenumber" name="176" href="#176">176</a>                 json.put(obj);
+<a class="jxr_linenumber" name="177" href="#177">177</a>             }
+<a class="jxr_linenumber" name="178" href="#178">178</a> 
+<a class="jxr_linenumber" name="179" href="#179">179</a>         } <strong class="jxr_keyword">catch</strong> (SQLException e) { 
+<a class="jxr_linenumber" name="180" href="#180">180</a>             e.printStackTrace(); 
+<a class="jxr_linenumber" name="181" href="#181">181</a>             <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="182" href="#182">182</a>                 LOG.error(e.getMessage());
+<a class="jxr_linenumber" name="183" href="#183">183</a>             <strong class="jxr_keyword">throw</strong> e;
+<a class="jxr_linenumber" name="184" href="#184">184</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) { 
+<a class="jxr_linenumber" name="185" href="#185">185</a>             e.printStackTrace(); 
+<a class="jxr_linenumber" name="186" href="#186">186</a>             <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="187" href="#187">187</a>                 LOG.error(e.getMessage());
+<a class="jxr_linenumber" name="188" href="#188">188</a>             <strong class="jxr_keyword">throw</strong> e;
+<a class="jxr_linenumber" name="189" href="#189">189</a>         }
+<a class="jxr_linenumber" name="190" href="#190">190</a>         
+<a class="jxr_linenumber" name="191" href="#191">191</a>         <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="192" href="#192">192</a>             LOG.debug(<span class="jxr_string">"End convertResultSetToJSON"</span>);
+<a class="jxr_linenumber" name="193" href="#193">193</a> 
+<a class="jxr_linenumber" name="194" href="#194">194</a>         <strong class="jxr_keyword">return</strong> json; 
+<a class="jxr_linenumber" name="195" href="#195">195</a>     }
+<a class="jxr_linenumber" name="196" href="#196">196</a> 
+<a class="jxr_linenumber" name="197" href="#197">197</a>     
+<a class="jxr_linenumber" name="198" href="#198">198</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">void</strong> main(String args[]) {
+<a class="jxr_linenumber" name="199" href="#199">199</a>         Options options = <strong class="jxr_keyword">new</strong> Options();
+<a class="jxr_linenumber" name="200" href="#200">200</a>         options.addOption(<span class="jxr_string">"h"</span>,<span class="jxr_string">"help"</span>,false,<span class="jxr_string">"print this message"</span>);
+<a class="jxr_linenumber" name="201" href="#201">201</a>         options.addOption(<span class="jxr_string">"q"</span>,<span class="jxr_string">"queryText"</span>,<strong class="jxr_keyword">true</strong>,<span class="jxr_string">"SQL query text to execute"</span>);
+<a class="jxr_linenumber" name="202" href="#202">202</a>         HelpFormatter formatter = <strong class="jxr_keyword">new</strong> HelpFormatter();
+<a class="jxr_linenumber" name="203" href="#203">203</a>               
+<a class="jxr_linenumber" name="204" href="#204">204</a>         CommandLine commandLine;
+<a class="jxr_linenumber" name="205" href="#205">205</a>         String queryText = <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="206" href="#206">206</a>         StringBuilder sb = <strong class="jxr_keyword">new</strong> StringBuilder();
+<a class="jxr_linenumber" name="207" href="#207">207</a>         
+<a class="jxr_linenumber" name="208" href="#208">208</a>         <strong class="jxr_keyword">try</strong> {
+<a class="jxr_linenumber" name="209" href="#209">209</a>             commandLine = <strong class="jxr_keyword">new</strong> GnuParser().parse(options, args);
+<a class="jxr_linenumber" name="210" href="#210">210</a>             <strong class="jxr_keyword">if</strong> (commandLine.hasOption(<span class="jxr_string">"help"</span>)) {
+<a class="jxr_linenumber" name="211" href="#211">211</a>                 formatter.printHelp(<span class="jxr_string">"JdbcT4Util"</span>,options);
+<a class="jxr_linenumber" name="212" href="#212">212</a>                 System.exit(0);
+<a class="jxr_linenumber" name="213" href="#213">213</a>             }
+<a class="jxr_linenumber" name="214" href="#214">214</a>             <strong class="jxr_keyword">if</strong> (commandLine.hasOption(<span class="jxr_string">"queryText"</span>)) {
+<a class="jxr_linenumber" name="215" href="#215">215</a>                 queryText = commandLine.getOptionValue(<span class="jxr_string">"q"</span>);
+<a class="jxr_linenumber" name="216" href="#216">216</a>             }
+<a class="jxr_linenumber" name="217" href="#217">217</a>             <strong class="jxr_keyword">if</strong> (queryText == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="218" href="#218">218</a>                 formatter.printHelp(<span class="jxr_string">"JdbcT4Util"</span>,options);
+<a class="jxr_linenumber" name="219" href="#219">219</a>                 System.exit(-1);
+<a class="jxr_linenumber" name="220" href="#220">220</a>             }
+<a class="jxr_linenumber" name="221" href="#221">221</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) {
+<a class="jxr_linenumber" name="222" href="#222">222</a>             formatter.printHelp(<span class="jxr_string">"JdbcT4Util"</span>,options);
+<a class="jxr_linenumber" name="223" href="#223">223</a>             System.exit(-1);
+<a class="jxr_linenumber" name="224" href="#224">224</a>         }
+<a class="jxr_linenumber" name="225" href="#225">225</a> 
+<a class="jxr_linenumber" name="226" href="#226">226</a>         <strong class="jxr_keyword">try</strong>    {
+<a class="jxr_linenumber" name="227" href="#227">227</a>             <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a> jdbcT4Util = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a>();
+<a class="jxr_linenumber" name="228" href="#228">228</a>             TrafT4Connection connection = (TrafT4Connection) jdbcT4Util.getConnection();
+<a class="jxr_linenumber" name="229" href="#229">229</a>             
+<a class="jxr_linenumber" name="230" href="#230">230</a>             <em class="jxr_comment">//Regular Statement</em>
+<a class="jxr_linenumber" name="231" href="#231">231</a>             Statement stmt = connection.createStatement();
+<a class="jxr_linenumber" name="232" href="#232">232</a>             ResultSet rs = stmt.executeQuery(queryText);
+<a class="jxr_linenumber" name="233" href="#233">233</a>             JSONArray js = <strong class="jxr_keyword">new</strong> JSONArray();
+<a class="jxr_linenumber" name="234" href="#234">234</a>             js = convertResultSetToJSON(rs);
+<a class="jxr_linenumber" name="235" href="#235">235</a>             <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled()) 
+<a class="jxr_linenumber" name="236" href="#236">236</a>                 LOG.error(js.toString());
+<a class="jxr_linenumber" name="237" href="#237">237</a>             rs.close();
+<a class="jxr_linenumber" name="238" href="#238">238</a>             stmt.close();
+<a class="jxr_linenumber" name="239" href="#239">239</a>             
+<a class="jxr_linenumber" name="240" href="#240">240</a>             <em class="jxr_comment">//PreparedStatement with explain</em>
+<a class="jxr_linenumber" name="241" href="#241">241</a>             TrafT4PreparedStatement pStmt = (TrafT4PreparedStatement) connection.prepareStatement(queryText, <span class="jxr_string">"SQL_CURSOR_DEMO"</span>);
+<a class="jxr_linenumber" name="242" href="#242">242</a>             rs = pStmt.executeQuery(<span class="jxr_string">"SELECT * FROM TABLE(explain(null, 'SQL_CURSOR_DEMO'))"</span>);
+<a class="jxr_linenumber" name="243" href="#243">243</a>             js = <strong class="jxr_keyword">new</strong> JSONArray();
+<a class="jxr_linenumber" name="244" href="#244">244</a>             js = convertResultSetToJSON(rs);
+<a class="jxr_linenumber" name="245" href="#245">245</a>             <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled()) 
+<a class="jxr_linenumber" name="246" href="#246">246</a>                 LOG.error(js.toString());
+<a class="jxr_linenumber" name="247" href="#247">247</a>             rs.close();
+<a class="jxr_linenumber" name="248" href="#248">248</a>             stmt.close();
+<a class="jxr_linenumber" name="249" href="#249">249</a> 
+<a class="jxr_linenumber" name="250" href="#250">250</a>             System.exit(0);
+<a class="jxr_linenumber" name="251" href="#251">251</a>         } <strong class="jxr_keyword">catch</strong> (SQLException e) {
+<a class="jxr_linenumber" name="252" href="#252">252</a>             SQLException nextException = e;
+<a class="jxr_linenumber" name="253" href="#253">253</a>             <strong class="jxr_keyword">do</strong> {
+<a class="jxr_linenumber" name="254" href="#254">254</a>                 sb.append(nextException.getMessage());
+<a class="jxr_linenumber" name="255" href="#255">255</a>                 sb.append(<span class="jxr_string">"\nSQLState   "</span> + nextException.getSQLState());
+<a class="jxr_linenumber" name="256" href="#256">256</a>                 sb.append(<span class="jxr_string">"\nError Code "</span> + nextException.getErrorCode());
+<a class="jxr_linenumber" name="257" href="#257">257</a>             } <strong class="jxr_keyword">while</strong> ((nextException = nextException.getNextException()) != <strong class="jxr_keyword">null</strong>);
+<a class="jxr_linenumber" name="258" href="#258">258</a>             <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled()) 
+<a class="jxr_linenumber" name="259" href="#259">259</a>                 LOG.error(<span class="jxr_string">"SQLException ["</span> + sb.toString() + <span class="jxr_string">"]"</span>);    
+<a class="jxr_linenumber" name="260" href="#260">260</a>             System.exit(1);
+<a class="jxr_linenumber" name="261" href="#261">261</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) {
+<a class="jxr_linenumber" name="262" href="#262">262</a>             e.printStackTrace();
+<a class="jxr_linenumber" name="263" href="#263">263</a>             sb.append(e.getMessage());
+<a class="jxr_linenumber" name="264" href="#264">264</a>             <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled())
+<a class="jxr_linenumber" name="265" href="#265">265</a>                 LOG.debug(<span class="jxr_string">"Exception ["</span> + sb.toString() + <span class="jxr_string">"]"</span>);
+<a class="jxr_linenumber" name="266" href="#266">266</a>             System.exit(1);
+<a class="jxr_linenumber" name="267" href="#267">267</a>         } 
+<a class="jxr_linenumber" name="268" href="#268">268</a>     }
+<a class="jxr_linenumber" name="269" href="#269">269</a>     
+<a class="jxr_linenumber" name="270" href="#270">270</a> }
 </pre>
 <hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
 </html>


Mime
View raw message