http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/0cc74b27/docs/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html ---------------------------------------------------------------------- diff --git a/docs/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html b/docs/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html index 63ebff2..34cf438 100644 --- a/docs/dcs_reference/xref/org/trafodion/dcs/util/JdbcT4Util.html +++ b/docs/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<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<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<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<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>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/0cc74b27/docs/jdbct4ref_guide/Trafodion_JDBCT4_Reference_Guide.pdf ---------------------------------------------------------------------- diff --git a/docs/jdbct4ref_guide/Trafodion_JDBCT4_Reference_Guide.pdf b/docs/jdbct4ref_guide/Trafodion_JDBCT4_Reference_Guide.pdf new file mode 100644 index 0000000..45082ff Binary files /dev/null and b/docs/jdbct4ref_guide/Trafodion_JDBCT4_Reference_Guide.pdf differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/0cc74b27/docs/jdbct4ref_guide/css/maven-base.css ---------------------------------------------------------------------- diff --git a/docs/jdbct4ref_guide/css/maven-base.css b/docs/jdbct4ref_guide/css/maven-base.css new file mode 100644 index 0000000..584ba23 --- /dev/null +++ b/docs/jdbct4ref_guide/css/maven-base.css @@ -0,0 +1,151 @@ +body { + margin: 0px; + padding: 0px; +} +img { + border:none; +} +table { + padding:0px; + width: 100%; + margin-left: -2px; + margin-right: -2px; +} +acronym { + cursor: help; + border-bottom: 1px dotted #feb; +} +table.bodyTable th, table.bodyTable td { + padding: 2px 4px 2px 4px; + vertical-align: top; +} +div.clear{ + clear:both; + visibility: hidden; +} +div.clear hr{ + display: none; +} +#bannerLeft, #bannerRight { + font-size: xx-large; + font-weight: bold; +} +#bannerLeft img, #bannerRight img { + margin: 0px; +} +.xleft, #bannerLeft img { + float:left; +} +.xright, #bannerRight { + float:right; +} +#banner { + padding: 0px; +} +#banner img { + border: none; +} +#breadcrumbs { + padding: 3px 10px 3px 10px; +} +#leftColumn { + width: 170px; + float:left; + overflow: auto; +} +#bodyColumn { + margin-right: 1.5em; + margin-left: 197px; +} +#legend { + padding: 8px 0 8px 0; +} +#navcolumn { + padding: 8px 4px 0 8px; +} +#navcolumn h5 { + margin: 0; + padding: 0; + font-size: small; +} +#navcolumn ul { + margin: 0; + padding: 0; + font-size: small; +} +#navcolumn li { + list-style-type: none; + background-image: none; + background-repeat: no-repeat; + background-position: 0 0.4em; + padding-left: 16px; + list-style-position: outside; + line-height: 1.2em; + font-size: smaller; +} +#navcolumn li.expanded { + background-image: url(../images/expanded.gif); +} +#navcolumn li.collapsed { + background-image: url(../images/collapsed.gif); +} +#poweredBy { + text-align: center; +} +#navcolumn img { + margin-top: 10px; + margin-bottom: 3px; +} +#poweredBy img { + display:block; + margin: 20px 0 20px 17px; +} +#search img { + margin: 0px; + display: block; +} +#search #q, #search #btnG { + border: 1px solid #999; + margin-bottom:10px; +} +#search form { + margin: 0px; +} +#lastPublished { + font-size: x-small; +} +.navSection { + margin-bottom: 2px; + padding: 8px; +} +.navSectionHead { + font-weight: bold; + font-size: x-small; +} +.section { + padding: 4px; +} +#footer { + padding: 3px 10px 3px 10px; + font-size: x-small; +} +#breadcrumbs { + font-size: x-small; + margin: 0pt; +} +.source { + padding: 12px; + margin: 1em 7px 1em 7px; +} +.source pre { + margin: 0px; + padding: 0px; +} +#navcolumn img.imageLink, .imageLink { + padding-left: 0px; + padding-bottom: 0px; + padding-top: 0px; + padding-right: 2px; + border: 0px; + margin: 0px; +} http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/0cc74b27/docs/jdbct4ref_guide/css/maven-theme.css ---------------------------------------------------------------------- diff --git a/docs/jdbct4ref_guide/css/maven-theme.css b/docs/jdbct4ref_guide/css/maven-theme.css new file mode 100644 index 0000000..c982168 --- /dev/null +++ b/docs/jdbct4ref_guide/css/maven-theme.css @@ -0,0 +1,141 @@ +body { + padding: 0px 0px 10px 0px; +} +body, td, select, input, li{ + font-family: Verdana, Helvetica, Arial, sans-serif; + font-size: 13px; +} +code{ + font-family: Courier, monospace; + font-size: 13px; +} +a { + text-decoration: none; +} +a:link { + color:#36a; +} +a:visited { + color:#47a; +} +a:active, a:hover { + color:#69c; +} +#legend li.externalLink { + background: url(../images/external.png) left top no-repeat; + padding-left: 18px; +} +a.externalLink, a.externalLink:link, a.externalLink:visited, a.externalLink:active, a.externalLink:hover { + background: url(../images/external.png) right center no-repeat; + padding-right: 18px; +} +#legend li.newWindow { + background: url(../images/newwindow.png) left top no-repeat; + padding-left: 18px; +} +a.newWindow, a.newWindow:link, a.newWindow:visited, a.newWindow:active, a.newWindow:hover { + background: url(../images/newwindow.png) right center no-repeat; + padding-right: 18px; +} +h2 { + padding: 4px 4px 4px 6px; + border: 1px solid #999; + color: #900; + background-color: #ddd; + font-weight:900; + font-size: x-large; +} +h3 { + padding: 4px 4px 4px 6px; + border: 1px solid #aaa; + color: #900; + background-color: #eee; + font-weight: normal; + font-size: large; +} +h4 { + padding: 4px 4px 4px 6px; + border: 1px solid #bbb; + color: #900; + background-color: #fff; + font-weight: normal; + font-size: large; +} +h5 { + padding: 4px 4px 4px 6px; + color: #900; + font-size: normal; +} +p { + line-height: 1.3em; + font-size: small; +} +#breadcrumbs { + border-top: 1px solid #aaa; + border-bottom: 1px solid #aaa; + background-color: #ccc; +} +#leftColumn { + margin: 10px 0 0 5px; + border: 1px solid #999; + background-color: #eee; +} +#navcolumn h5 { + font-size: smaller; + border-bottom: 1px solid #aaaaaa; + padding-top: 2px; + color: #000; +} + +table.bodyTable th { + color: white; + background-color: #bbb; + text-align: left; + font-weight: bold; +} + +table.bodyTable th, table.bodyTable td { + font-size: 1em; +} + +table.bodyTable tr.a { + background-color: #ddd; +} + +table.bodyTable tr.b { + background-color: #eee; +} + +.source { + border: 1px solid #999; +} +dl { + padding: 4px 4px 4px 6px; + border: 1px solid #aaa; + background-color: #ffc; +} +dt { + color: #900; +} +#organizationLogo img, #projectLogo img, #projectLogo span{ + margin: 8px; +} +#banner { + border-bottom: 1px solid #fff; +} +.errormark, .warningmark, .donemark, .infomark { + background: url(../images/icon_error_sml.gif) no-repeat; +} + +.warningmark { + background-image: url(../images/icon_warning_sml.gif); +} + +.donemark { + background-image: url(../images/icon_success_sml.gif); +} + +.infomark { + background-image: url(../images/icon_info_sml.gif); +} + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/0cc74b27/docs/jdbct4ref_guide/css/print.css ---------------------------------------------------------------------- diff --git a/docs/jdbct4ref_guide/css/print.css b/docs/jdbct4ref_guide/css/print.css new file mode 100644 index 0000000..26ad7f0 --- /dev/null +++ b/docs/jdbct4ref_guide/css/print.css @@ -0,0 +1,7 @@ +#banner, #footer, #leftcol, #breadcrumbs, .docs #toc, .docs .courtesylinks, #leftColumn, #navColumn { + display: none !important; +} +#bodyColumn, body.docs div.docs { + margin: 0 !important; + border: none !important +} http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/0cc74b27/docs/jdbct4ref_guide/css/site.css ---------------------------------------------------------------------- diff --git a/docs/jdbct4ref_guide/css/site.css b/docs/jdbct4ref_guide/css/site.css new file mode 100644 index 0000000..055e7e2 --- /dev/null +++ b/docs/jdbct4ref_guide/css/site.css @@ -0,0 +1 @@ +/* You can override this file with your own styles */ \ No newline at end of file