You are viewing a plain text version of this content. The canonical link for it is here.
Posted to site-dev@james.apache.org by rd...@apache.org on 2011/05/08 16:48:13 UTC
svn commit: r1100750 [5/5] - in /james/site/trunk/www/mailet/ai: ./ xref/
xref/org/ xref/org/apache/ xref/org/apache/james/ xref/org/apache/james/ai/
xref/org/apache/james/ai/classic/
Added: james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SqlResources.html
URL: http://svn.apache.org/viewvc/james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SqlResources.html?rev=1100750&view=auto
==============================================================================
--- james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SqlResources.html (added)
+++ james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SqlResources.html Sun May 8 14:48:12 2011
@@ -0,0 +1,403 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SqlResources xref</title>
+<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
+</head>
+<body>
+<div id="overview"><a href="../../../../../../../../../../../../ai-workspace/target/site/apidocs/org/apache/james/ai/classic/SqlResources.html">View Javadoc</a></div><pre>
+
+<a class="jxr_linenumber" name="1" href="#1">1</a> <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment">**************************************************************</em>
+<a class="jxr_linenumber" name="2" href="#2">2</a> <em class="jxr_javadoccomment"> * Licensed to the Apache Software Foundation (ASF) under one *</em>
+<a class="jxr_linenumber" name="3" href="#3">3</a> <em class="jxr_javadoccomment"> * or more contributor license agreements. See the NOTICE file *</em>
+<a class="jxr_linenumber" name="4" href="#4">4</a> <em class="jxr_javadoccomment"> * distributed with this work for additional information *</em>
+<a class="jxr_linenumber" name="5" href="#5">5</a> <em class="jxr_javadoccomment"> * regarding copyright ownership. The ASF licenses this file *</em>
+<a class="jxr_linenumber" name="6" href="#6">6</a> <em class="jxr_javadoccomment"> * to you under the Apache License, Version 2.0 (the *</em>
+<a class="jxr_linenumber" name="7" href="#7">7</a> <em class="jxr_javadoccomment"> * "License"); you may not use this file except in compliance *</em>
+<a class="jxr_linenumber" name="8" href="#8">8</a> <em class="jxr_javadoccomment"> * with the License. You may obtain a copy of the License at *</em>
+<a class="jxr_linenumber" name="9" href="#9">9</a> <em class="jxr_javadoccomment"> * *</em>
+<a class="jxr_linenumber" name="10" href="#10">10</a> <em class="jxr_javadoccomment"> * <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a> *</em>
+<a class="jxr_linenumber" name="11" href="#11">11</a> <em class="jxr_javadoccomment"> * *</em>
+<a class="jxr_linenumber" name="12" href="#12">12</a> <em class="jxr_javadoccomment"> * Unless required by applicable law or agreed to in writing, *</em>
+<a class="jxr_linenumber" name="13" href="#13">13</a> <em class="jxr_javadoccomment"> * software distributed under the License is distributed on an *</em>
+<a class="jxr_linenumber" name="14" href="#14">14</a> <em class="jxr_javadoccomment"> * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY *</em>
+<a class="jxr_linenumber" name="15" href="#15">15</a> <em class="jxr_javadoccomment"> * KIND, either express or implied. See the License for the *</em>
+<a class="jxr_linenumber" name="16" href="#16">16</a> <em class="jxr_javadoccomment"> * specific language governing permissions and limitations *</em>
+<a class="jxr_linenumber" name="17" href="#17">17</a> <em class="jxr_javadoccomment"> * under the License. *</em>
+<a class="jxr_linenumber" name="18" href="#18">18</a> <em class="jxr_javadoccomment"> ****************************************************************/</em>
+<a class="jxr_linenumber" name="19" href="#19">19</a>
+<a class="jxr_linenumber" name="20" href="#20">20</a> <strong class="jxr_keyword">package</strong> org.apache.james.ai.classic;
+<a class="jxr_linenumber" name="21" href="#21">21</a>
+<a class="jxr_linenumber" name="22" href="#22">22</a> <strong class="jxr_keyword">import</strong> java.io.File;
+<a class="jxr_linenumber" name="23" href="#23">23</a> <strong class="jxr_keyword">import</strong> java.io.InputStream;
+<a class="jxr_linenumber" name="24" href="#24">24</a> <strong class="jxr_keyword">import</strong> java.sql.Connection;
+<a class="jxr_linenumber" name="25" href="#25">25</a> <strong class="jxr_keyword">import</strong> java.sql.SQLException;
+<a class="jxr_linenumber" name="26" href="#26">26</a> <strong class="jxr_keyword">import</strong> java.util.HashMap;
+<a class="jxr_linenumber" name="27" href="#27">27</a> <strong class="jxr_keyword">import</strong> java.util.Map;
+<a class="jxr_linenumber" name="28" href="#28">28</a> <strong class="jxr_keyword">import</strong> java.util.regex.Pattern;
+<a class="jxr_linenumber" name="29" href="#29">29</a>
+<a class="jxr_linenumber" name="30" href="#30">30</a> <strong class="jxr_keyword">import</strong> javax.xml.parsers.DocumentBuilder;
+<a class="jxr_linenumber" name="31" href="#31">31</a> <strong class="jxr_keyword">import</strong> javax.xml.parsers.DocumentBuilderFactory;
+<a class="jxr_linenumber" name="32" href="#32">32</a>
+<a class="jxr_linenumber" name="33" href="#33">33</a> <strong class="jxr_keyword">import</strong> org.w3c.dom.Attr;
+<a class="jxr_linenumber" name="34" href="#34">34</a> <strong class="jxr_keyword">import</strong> org.w3c.dom.Document;
+<a class="jxr_linenumber" name="35" href="#35">35</a> <strong class="jxr_keyword">import</strong> org.w3c.dom.Element;
+<a class="jxr_linenumber" name="36" href="#36">36</a> <strong class="jxr_keyword">import</strong> org.w3c.dom.NamedNodeMap;
+<a class="jxr_linenumber" name="37" href="#37">37</a> <strong class="jxr_keyword">import</strong> org.w3c.dom.NodeList;
+<a class="jxr_linenumber" name="38" href="#38">38</a>
+<a class="jxr_linenumber" name="39" href="#39">39</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="40" href="#40">40</a> <em class="jxr_javadoccomment"> * Provides a set of SQL String resources (eg SQL Strings) to use for a database</em>
+<a class="jxr_linenumber" name="41" href="#41">41</a> <em class="jxr_javadoccomment"> * connection.<br></em>
+<a class="jxr_linenumber" name="42" href="#42">42</a> <em class="jxr_javadoccomment"> * This class allows SQL strings to be customised to particular database</em>
+<a class="jxr_linenumber" name="43" href="#43">43</a> <em class="jxr_javadoccomment"> * products, by detecting product information from the jdbc DatabaseMetaData</em>
+<a class="jxr_linenumber" name="44" href="#44">44</a> <em class="jxr_javadoccomment"> * object.</em>
+<a class="jxr_linenumber" name="45" href="#45">45</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="46" href="#46">46</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="47" href="#47">47</a> <strong class="jxr_keyword">class</strong> <a href="../../../../../org/apache/james/ai/classic/SqlResources.html">SqlResources</a> {
+<a class="jxr_linenumber" name="48" href="#48">48</a> <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> A map of statement types to SQL statements */</em>
+<a class="jxr_linenumber" name="49" href="#49">49</a> <strong class="jxr_keyword">private</strong> Map<String, String> m_sql = <strong class="jxr_keyword">new</strong> HashMap<String, String>();
+<a class="jxr_linenumber" name="50" href="#50">50</a>
+<a class="jxr_linenumber" name="51" href="#51">51</a> <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> A map of engine specific options */</em>
+<a class="jxr_linenumber" name="52" href="#52">52</a> <strong class="jxr_keyword">private</strong> Map<String, String> m_dbOptions = <strong class="jxr_keyword">new</strong> HashMap<String, String>();
+<a class="jxr_linenumber" name="53" href="#53">53</a>
+<a class="jxr_linenumber" name="54" href="#54">54</a> <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> A set of all used String values */</em>
+<a class="jxr_linenumber" name="55" href="#55">55</a> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">private</strong> Map<String, String> stringTable = java.util.Collections.synchronizedMap(<strong class="jxr_keyword">new</strong> HashMap<String, String>());
+<a class="jxr_linenumber" name="56" href="#56">56</a>
+<a class="jxr_linenumber" name="57" href="#57">57</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="58" href="#58">58</a> <em class="jxr_javadoccomment"> * <p></em>
+<a class="jxr_linenumber" name="59" href="#59">59</a> <em class="jxr_javadoccomment"> * Configures a DbResources object to provide SQL statements from a file.</em>
+<a class="jxr_linenumber" name="60" href="#60">60</a> <em class="jxr_javadoccomment"> * </p></em>
+<a class="jxr_linenumber" name="61" href="#61">61</a> <em class="jxr_javadoccomment"> * <p></em>
+<a class="jxr_linenumber" name="62" href="#62">62</a> <em class="jxr_javadoccomment"> * SQL statements returned may be specific to the particular type and</em>
+<a class="jxr_linenumber" name="63" href="#63">63</a> <em class="jxr_javadoccomment"> * version of the connected database, as well as the database driver.</em>
+<a class="jxr_linenumber" name="64" href="#64">64</a> <em class="jxr_javadoccomment"> * </p></em>
+<a class="jxr_linenumber" name="65" href="#65">65</a> <em class="jxr_javadoccomment"> * <p></em>
+<a class="jxr_linenumber" name="66" href="#66">66</a> <em class="jxr_javadoccomment"> * Parameters encoded as $(parameter} in the input file are replace by</em>
+<a class="jxr_linenumber" name="67" href="#67">67</a> <em class="jxr_javadoccomment"> * values from the parameters Map, if the named parameter exists. Parameter</em>
+<a class="jxr_linenumber" name="68" href="#68">68</a> <em class="jxr_javadoccomment"> * values may also be specified in the resourceSection element.</em>
+<a class="jxr_linenumber" name="69" href="#69">69</a> <em class="jxr_javadoccomment"> * </p></em>
+<a class="jxr_linenumber" name="70" href="#70">70</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="71" href="#71">71</a> <em class="jxr_javadoccomment"> * @param sqlFile</em>
+<a class="jxr_linenumber" name="72" href="#72">72</a> <em class="jxr_javadoccomment"> * the input file containing the string definitions</em>
+<a class="jxr_linenumber" name="73" href="#73">73</a> <em class="jxr_javadoccomment"> * @param sqlDefsSection</em>
+<a class="jxr_linenumber" name="74" href="#74">74</a> <em class="jxr_javadoccomment"> * the xml element containing the strings to be used</em>
+<a class="jxr_linenumber" name="75" href="#75">75</a> <em class="jxr_javadoccomment"> * @param conn</em>
+<a class="jxr_linenumber" name="76" href="#76">76</a> <em class="jxr_javadoccomment"> * the Jdbc DatabaseMetaData, taken from a database connection</em>
+<a class="jxr_linenumber" name="77" href="#77">77</a> <em class="jxr_javadoccomment"> * @param configParameters</em>
+<a class="jxr_linenumber" name="78" href="#78">78</a> <em class="jxr_javadoccomment"> * a map of parameters (name-value string pairs) which are</em>
+<a class="jxr_linenumber" name="79" href="#79">79</a> <em class="jxr_javadoccomment"> * replaced where found in the input strings</em>
+<a class="jxr_linenumber" name="80" href="#80">80</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="81" href="#81">81</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> init(File sqlFile, String sqlDefsSection, Connection conn, Map<String, String> configParameters) <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="82" href="#82">82</a> <em class="jxr_comment">// Parse the sqlFile as an XML document.</em>
+<a class="jxr_linenumber" name="83" href="#83">83</a> DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
+<a class="jxr_linenumber" name="84" href="#84">84</a> DocumentBuilder builder = factory.newDocumentBuilder();
+<a class="jxr_linenumber" name="85" href="#85">85</a> Document sqlDoc = builder.parse(sqlFile);
+<a class="jxr_linenumber" name="86" href="#86">86</a>
+<a class="jxr_linenumber" name="87" href="#87">87</a> init(sqlDoc, sqlDefsSection, conn, configParameters);
+<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> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="91" href="#91">91</a> <em class="jxr_javadoccomment"> * <p></em>
+<a class="jxr_linenumber" name="92" href="#92">92</a> <em class="jxr_javadoccomment"> * Configures a DbResources object to provide SQL statements from an</em>
+<a class="jxr_linenumber" name="93" href="#93">93</a> <em class="jxr_javadoccomment"> * InputStream.</em>
+<a class="jxr_linenumber" name="94" href="#94">94</a> <em class="jxr_javadoccomment"> * </p></em>
+<a class="jxr_linenumber" name="95" href="#95">95</a> <em class="jxr_javadoccomment"> * <p></em>
+<a class="jxr_linenumber" name="96" href="#96">96</a> <em class="jxr_javadoccomment"> * SQL statements returned may be specific to the particular type and</em>
+<a class="jxr_linenumber" name="97" href="#97">97</a> <em class="jxr_javadoccomment"> * version of the connected database, as well as the database driver.</em>
+<a class="jxr_linenumber" name="98" href="#98">98</a> <em class="jxr_javadoccomment"> * </p></em>
+<a class="jxr_linenumber" name="99" href="#99">99</a> <em class="jxr_javadoccomment"> * <p></em>
+<a class="jxr_linenumber" name="100" href="#100">100</a> <em class="jxr_javadoccomment"> * Parameters encoded as $(parameter} in the input file are replace by</em>
+<a class="jxr_linenumber" name="101" href="#101">101</a> <em class="jxr_javadoccomment"> * values from the parameters Map, if the named parameter exists. Parameter</em>
+<a class="jxr_linenumber" name="102" href="#102">102</a> <em class="jxr_javadoccomment"> * values may also be specified in the resourceSection element.</em>
+<a class="jxr_linenumber" name="103" href="#103">103</a> <em class="jxr_javadoccomment"> * </p></em>
+<a class="jxr_linenumber" name="104" href="#104">104</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="105" href="#105">105</a> <em class="jxr_javadoccomment"> * @param input</em>
+<a class="jxr_linenumber" name="106" href="#106">106</a> <em class="jxr_javadoccomment"> * the input stream containing the xml</em>
+<a class="jxr_linenumber" name="107" href="#107">107</a> <em class="jxr_javadoccomment"> * @param sqlDefsSection</em>
+<a class="jxr_linenumber" name="108" href="#108">108</a> <em class="jxr_javadoccomment"> * the xml element containing the strings to be used</em>
+<a class="jxr_linenumber" name="109" href="#109">109</a> <em class="jxr_javadoccomment"> * @param conn</em>
+<a class="jxr_linenumber" name="110" href="#110">110</a> <em class="jxr_javadoccomment"> * the Jdbc DatabaseMetaData, taken from a database connection</em>
+<a class="jxr_linenumber" name="111" href="#111">111</a> <em class="jxr_javadoccomment"> * @param configParameters</em>
+<a class="jxr_linenumber" name="112" href="#112">112</a> <em class="jxr_javadoccomment"> * a map of parameters (name-value string pairs) which are</em>
+<a class="jxr_linenumber" name="113" href="#113">113</a> <em class="jxr_javadoccomment"> * replaced where found in the input strings</em>
+<a class="jxr_linenumber" name="114" href="#114">114</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="115" href="#115">115</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> init(InputStream input, String sqlDefsSection, Connection conn, Map<String, String> configParameters) <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="116" href="#116">116</a> <em class="jxr_comment">// Parse the InputStream as an XML document.</em>
+<a class="jxr_linenumber" name="117" href="#117">117</a> DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
+<a class="jxr_linenumber" name="118" href="#118">118</a> DocumentBuilder builder = factory.newDocumentBuilder();
+<a class="jxr_linenumber" name="119" href="#119">119</a> Document sqlDoc = builder.parse(input);
+<a class="jxr_linenumber" name="120" href="#120">120</a>
+<a class="jxr_linenumber" name="121" href="#121">121</a> init(sqlDoc, sqlDefsSection, conn, configParameters);
+<a class="jxr_linenumber" name="122" href="#122">122</a> }
+<a class="jxr_linenumber" name="123" href="#123">123</a>
+<a class="jxr_linenumber" name="124" href="#124">124</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="125" href="#125">125</a> <em class="jxr_javadoccomment"> * Configures a SqlResources object from an xml document.</em>
+<a class="jxr_linenumber" name="126" href="#126">126</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="127" href="#127">127</a> <em class="jxr_javadoccomment"> * @param sqlDoc</em>
+<a class="jxr_linenumber" name="128" href="#128">128</a> <em class="jxr_javadoccomment"> * @param sqlDefsSection</em>
+<a class="jxr_linenumber" name="129" href="#129">129</a> <em class="jxr_javadoccomment"> * @param conn</em>
+<a class="jxr_linenumber" name="130" href="#130">130</a> <em class="jxr_javadoccomment"> * @param configParameters</em>
+<a class="jxr_linenumber" name="131" href="#131">131</a> <em class="jxr_javadoccomment"> * @throws SQLException</em>
+<a class="jxr_linenumber" name="132" href="#132">132</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="133" href="#133">133</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> init(Document sqlDoc, String sqlDefsSection, Connection conn, Map<String, String> configParameters) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="134" href="#134">134</a> <em class="jxr_comment">// First process the database matcher, to determine the</em>
+<a class="jxr_linenumber" name="135" href="#135">135</a> <em class="jxr_comment">// sql statements to use.</em>
+<a class="jxr_linenumber" name="136" href="#136">136</a> Element dbMatcherElement = (Element) (sqlDoc.getElementsByTagName(<span class="jxr_string">"dbMatchers"</span>).item(0));
+<a class="jxr_linenumber" name="137" href="#137">137</a> String dbProduct = <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="138" href="#138">138</a> <strong class="jxr_keyword">if</strong> (dbMatcherElement != <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="139" href="#139">139</a> dbProduct = matchDbConnection(conn, dbMatcherElement);
+<a class="jxr_linenumber" name="140" href="#140">140</a> }
+<a class="jxr_linenumber" name="141" href="#141">141</a>
+<a class="jxr_linenumber" name="142" href="#142">142</a> <em class="jxr_comment">// Now get the options valid for the database product used.</em>
+<a class="jxr_linenumber" name="143" href="#143">143</a> Element dbOptionsElement = (Element) (sqlDoc.getElementsByTagName(<span class="jxr_string">"dbOptions"</span>).item(0));
+<a class="jxr_linenumber" name="144" href="#144">144</a> <strong class="jxr_keyword">if</strong> (dbOptionsElement != <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="145" href="#145">145</a> <em class="jxr_comment">// First populate the map with default values</em>
+<a class="jxr_linenumber" name="146" href="#146">146</a> populateDbOptions(<span class="jxr_string">""</span>, dbOptionsElement, m_dbOptions);
+<a class="jxr_linenumber" name="147" href="#147">147</a> <em class="jxr_comment">// Now update the map with specific product values</em>
+<a class="jxr_linenumber" name="148" href="#148">148</a> <strong class="jxr_keyword">if</strong> (dbProduct != <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="149" href="#149">149</a> populateDbOptions(dbProduct, dbOptionsElement, m_dbOptions);
+<a class="jxr_linenumber" name="150" href="#150">150</a> }
+<a class="jxr_linenumber" name="151" href="#151">151</a> }
+<a class="jxr_linenumber" name="152" href="#152">152</a>
+<a class="jxr_linenumber" name="153" href="#153">153</a> <em class="jxr_comment">// Now get the section defining sql for the repository required.</em>
+<a class="jxr_linenumber" name="154" href="#154">154</a> NodeList sections = sqlDoc.getElementsByTagName(<span class="jxr_string">"sqlDefs"</span>);
+<a class="jxr_linenumber" name="155" href="#155">155</a> <strong class="jxr_keyword">int</strong> sectionsCount = sections.getLength();
+<a class="jxr_linenumber" name="156" href="#156">156</a> Element sectionElement = <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="157" href="#157">157</a> <strong class="jxr_keyword">boolean</strong> found = false;
+<a class="jxr_linenumber" name="158" href="#158">158</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < sectionsCount; i++) {
+<a class="jxr_linenumber" name="159" href="#159">159</a> sectionElement = (Element) (sections.item(i));
+<a class="jxr_linenumber" name="160" href="#160">160</a> String sectionName = sectionElement.getAttribute(<span class="jxr_string">"name"</span>);
+<a class="jxr_linenumber" name="161" href="#161">161</a> <strong class="jxr_keyword">if</strong> (sectionName != <strong class="jxr_keyword">null</strong> && sectionName.equals(sqlDefsSection)) {
+<a class="jxr_linenumber" name="162" href="#162">162</a> found = <strong class="jxr_keyword">true</strong>;
+<a class="jxr_linenumber" name="163" href="#163">163</a> <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="164" href="#164">164</a> }
+<a class="jxr_linenumber" name="165" href="#165">165</a>
+<a class="jxr_linenumber" name="166" href="#166">166</a> }
+<a class="jxr_linenumber" name="167" href="#167">167</a> <strong class="jxr_keyword">if</strong> (!found) {
+<a class="jxr_linenumber" name="168" href="#168">168</a> StringBuilder exceptionBuffer = <strong class="jxr_keyword">new</strong> StringBuilder(64).append(<span class="jxr_string">"Error loading sql definition file. "</span>).append(<span class="jxr_string">"The element named \'"</span>).append(sqlDefsSection).append(<span class="jxr_string">"\' does not exist."</span>);
+<a class="jxr_linenumber" name="169" href="#169">169</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(exceptionBuffer.toString());
+<a class="jxr_linenumber" name="170" href="#170">170</a> }
+<a class="jxr_linenumber" name="171" href="#171">171</a>
+<a class="jxr_linenumber" name="172" href="#172">172</a> <em class="jxr_comment">// Get parameters defined within the file as defaults,</em>
+<a class="jxr_linenumber" name="173" href="#173">173</a> <em class="jxr_comment">// and use supplied parameters as overrides.</em>
+<a class="jxr_linenumber" name="174" href="#174">174</a> Map<String, String> parameters = <strong class="jxr_keyword">new</strong> HashMap<String, String>();
+<a class="jxr_linenumber" name="175" href="#175">175</a> <em class="jxr_comment">// First read from the <params> element, if it exists.</em>
+<a class="jxr_linenumber" name="176" href="#176">176</a> Element parametersElement = (Element) (sectionElement.getElementsByTagName(<span class="jxr_string">"parameters"</span>).item(0));
+<a class="jxr_linenumber" name="177" href="#177">177</a> <strong class="jxr_keyword">if</strong> (parametersElement != <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="178" href="#178">178</a> NamedNodeMap params = parametersElement.getAttributes();
+<a class="jxr_linenumber" name="179" href="#179">179</a> <strong class="jxr_keyword">int</strong> paramCount = params.getLength();
+<a class="jxr_linenumber" name="180" href="#180">180</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < paramCount; i++) {
+<a class="jxr_linenumber" name="181" href="#181">181</a> Attr param = (Attr) params.item(i);
+<a class="jxr_linenumber" name="182" href="#182">182</a> String paramName = param.getName();
+<a class="jxr_linenumber" name="183" href="#183">183</a> String paramValue = param.getValue();
+<a class="jxr_linenumber" name="184" href="#184">184</a> parameters.put(paramName, paramValue);
+<a class="jxr_linenumber" name="185" href="#185">185</a> }
+<a class="jxr_linenumber" name="186" href="#186">186</a> }
+<a class="jxr_linenumber" name="187" href="#187">187</a> <em class="jxr_comment">// Then copy in the parameters supplied with the call.</em>
+<a class="jxr_linenumber" name="188" href="#188">188</a> parameters.putAll(configParameters);
+<a class="jxr_linenumber" name="189" href="#189">189</a>
+<a class="jxr_linenumber" name="190" href="#190">190</a> <em class="jxr_comment">// 2 maps - one for storing default statements,</em>
+<a class="jxr_linenumber" name="191" href="#191">191</a> <em class="jxr_comment">// the other for statements with a "db" attribute matching this</em>
+<a class="jxr_linenumber" name="192" href="#192">192</a> <em class="jxr_comment">// connection.</em>
+<a class="jxr_linenumber" name="193" href="#193">193</a> Map<String, String> defaultSqlStatements = <strong class="jxr_keyword">new</strong> HashMap<String, String>();
+<a class="jxr_linenumber" name="194" href="#194">194</a> Map<String, String> dbProductSqlStatements = <strong class="jxr_keyword">new</strong> HashMap<String, String>();
+<a class="jxr_linenumber" name="195" href="#195">195</a>
+<a class="jxr_linenumber" name="196" href="#196">196</a> <em class="jxr_comment">// Process each sql statement, replacing string parameters,</em>
+<a class="jxr_linenumber" name="197" href="#197">197</a> <em class="jxr_comment">// and adding to the appropriate map..</em>
+<a class="jxr_linenumber" name="198" href="#198">198</a> NodeList sqlDefs = sectionElement.getElementsByTagName(<span class="jxr_string">"sql"</span>);
+<a class="jxr_linenumber" name="199" href="#199">199</a> <strong class="jxr_keyword">int</strong> sqlCount = sqlDefs.getLength();
+<a class="jxr_linenumber" name="200" href="#200">200</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < sqlCount; i++) {
+<a class="jxr_linenumber" name="201" href="#201">201</a> <em class="jxr_comment">// See if this needs to be processed (is default or product</em>
+<a class="jxr_linenumber" name="202" href="#202">202</a> <em class="jxr_comment">// specific)</em>
+<a class="jxr_linenumber" name="203" href="#203">203</a> Element sqlElement = (Element) (sqlDefs.item(i));
+<a class="jxr_linenumber" name="204" href="#204">204</a> String sqlDb = sqlElement.getAttribute(<span class="jxr_string">"db"</span>);
+<a class="jxr_linenumber" name="205" href="#205">205</a> Map<String, String> sqlMap;
+<a class="jxr_linenumber" name="206" href="#206">206</a> <strong class="jxr_keyword">if</strong> (sqlDb.equals(<span class="jxr_string">""</span>)) {
+<a class="jxr_linenumber" name="207" href="#207">207</a> <em class="jxr_comment">// default</em>
+<a class="jxr_linenumber" name="208" href="#208">208</a> sqlMap = defaultSqlStatements;
+<a class="jxr_linenumber" name="209" href="#209">209</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (sqlDb.equals(dbProduct)) {
+<a class="jxr_linenumber" name="210" href="#210">210</a> <em class="jxr_comment">// Specific to this product</em>
+<a class="jxr_linenumber" name="211" href="#211">211</a> sqlMap = dbProductSqlStatements;
+<a class="jxr_linenumber" name="212" href="#212">212</a> } <strong class="jxr_keyword">else</strong> {
+<a class="jxr_linenumber" name="213" href="#213">213</a> <em class="jxr_comment">// for a different product</em>
+<a class="jxr_linenumber" name="214" href="#214">214</a> <strong class="jxr_keyword">continue</strong>;
+<a class="jxr_linenumber" name="215" href="#215">215</a> }
+<a class="jxr_linenumber" name="216" href="#216">216</a>
+<a class="jxr_linenumber" name="217" href="#217">217</a> <em class="jxr_comment">// Get the key and value for this SQL statement.</em>
+<a class="jxr_linenumber" name="218" href="#218">218</a> String sqlKey = sqlElement.getAttribute(<span class="jxr_string">"name"</span>);
+<a class="jxr_linenumber" name="219" href="#219">219</a> <strong class="jxr_keyword">if</strong> (sqlKey == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="220" href="#220">220</a> <em class="jxr_comment">// ignore statements without a "name" attribute.</em>
+<a class="jxr_linenumber" name="221" href="#221">221</a> <strong class="jxr_keyword">continue</strong>;
+<a class="jxr_linenumber" name="222" href="#222">222</a> }
+<a class="jxr_linenumber" name="223" href="#223">223</a> String sqlString = sqlElement.getFirstChild().getNodeValue();
+<a class="jxr_linenumber" name="224" href="#224">224</a>
+<a class="jxr_linenumber" name="225" href="#225">225</a> <em class="jxr_comment">// Do parameter replacements for this sql string.</em>
+<a class="jxr_linenumber" name="226" href="#226">226</a> StringBuilder replaceBuffer = <strong class="jxr_keyword">new</strong> StringBuilder(64);
+<a class="jxr_linenumber" name="227" href="#227">227</a> <strong class="jxr_keyword">for</strong> (Map.Entry<String, String> entry : parameters.entrySet()) {
+<a class="jxr_linenumber" name="228" href="#228">228</a> replaceBuffer.setLength(0);
+<a class="jxr_linenumber" name="229" href="#229">229</a> replaceBuffer.append(<span class="jxr_string">"${"</span>).append(entry.getKey()).append(<span class="jxr_string">"}"</span>);
+<a class="jxr_linenumber" name="230" href="#230">230</a> sqlString = substituteSubString(sqlString, replaceBuffer.toString(), entry.getValue());
+<a class="jxr_linenumber" name="231" href="#231">231</a> }
+<a class="jxr_linenumber" name="232" href="#232">232</a>
+<a class="jxr_linenumber" name="233" href="#233">233</a> <em class="jxr_comment">// See if we already have registered a string of this value</em>
+<a class="jxr_linenumber" name="234" href="#234">234</a> String shared = stringTable.get(sqlString);
+<a class="jxr_linenumber" name="235" href="#235">235</a> <em class="jxr_comment">// If not, register it -- we will use it next time</em>
+<a class="jxr_linenumber" name="236" href="#236">236</a> <strong class="jxr_keyword">if</strong> (shared == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="237" href="#237">237</a> stringTable.put(sqlString, sqlString);
+<a class="jxr_linenumber" name="238" href="#238">238</a> } <strong class="jxr_keyword">else</strong> {
+<a class="jxr_linenumber" name="239" href="#239">239</a> sqlString = shared;
+<a class="jxr_linenumber" name="240" href="#240">240</a> }
+<a class="jxr_linenumber" name="241" href="#241">241</a>
+<a class="jxr_linenumber" name="242" href="#242">242</a> <em class="jxr_comment">// Add to the sqlMap - either the "default" or the "product" map</em>
+<a class="jxr_linenumber" name="243" href="#243">243</a> sqlMap.put(sqlKey, sqlString);
+<a class="jxr_linenumber" name="244" href="#244">244</a> }
+<a class="jxr_linenumber" name="245" href="#245">245</a>
+<a class="jxr_linenumber" name="246" href="#246">246</a> <em class="jxr_comment">// Copy in default strings, then overwrite product-specific ones.</em>
+<a class="jxr_linenumber" name="247" href="#247">247</a> m_sql.putAll(defaultSqlStatements);
+<a class="jxr_linenumber" name="248" href="#248">248</a> m_sql.putAll(dbProductSqlStatements);
+<a class="jxr_linenumber" name="249" href="#249">249</a> }
+<a class="jxr_linenumber" name="250" href="#250">250</a>
+<a class="jxr_linenumber" name="251" href="#251">251</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="252" href="#252">252</a> <em class="jxr_javadoccomment"> * Compares the DatabaseProductName value for a jdbc Connection against a</em>
+<a class="jxr_linenumber" name="253" href="#253">253</a> <em class="jxr_javadoccomment"> * set of regular expressions defined in XML.<br></em>
+<a class="jxr_linenumber" name="254" href="#254">254</a> <em class="jxr_javadoccomment"> * The first successful match defines the name of the database product</em>
+<a class="jxr_linenumber" name="255" href="#255">255</a> <em class="jxr_javadoccomment"> * connected to. This value is then used to choose the specific SQL</em>
+<a class="jxr_linenumber" name="256" href="#256">256</a> <em class="jxr_javadoccomment"> * expressions to use.</em>
+<a class="jxr_linenumber" name="257" href="#257">257</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="258" href="#258">258</a> <em class="jxr_javadoccomment"> * @param conn</em>
+<a class="jxr_linenumber" name="259" href="#259">259</a> <em class="jxr_javadoccomment"> * the JDBC connection being tested</em>
+<a class="jxr_linenumber" name="260" href="#260">260</a> <em class="jxr_javadoccomment"> * @param dbMatchersElement</em>
+<a class="jxr_linenumber" name="261" href="#261">261</a> <em class="jxr_javadoccomment"> * the XML element containing the database type information</em>
+<a class="jxr_linenumber" name="262" href="#262">262</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="263" href="#263">263</a> <em class="jxr_javadoccomment"> * @return the type of database to which James is connected</em>
+<a class="jxr_linenumber" name="264" href="#264">264</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="265" href="#265">265</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="266" href="#266">266</a> <strong class="jxr_keyword">private</strong> String matchDbConnection(Connection conn, Element dbMatchersElement) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="267" href="#267">267</a> String dbProductName = conn.getMetaData().getDatabaseProductName();
+<a class="jxr_linenumber" name="268" href="#268">268</a>
+<a class="jxr_linenumber" name="269" href="#269">269</a> NodeList dbMatchers = dbMatchersElement.getElementsByTagName(<span class="jxr_string">"dbMatcher"</span>);
+<a class="jxr_linenumber" name="270" href="#270">270</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < dbMatchers.getLength(); i++) {
+<a class="jxr_linenumber" name="271" href="#271">271</a> <em class="jxr_comment">// Get the values for this matcher element.</em>
+<a class="jxr_linenumber" name="272" href="#272">272</a> Element dbMatcher = (Element) dbMatchers.item(i);
+<a class="jxr_linenumber" name="273" href="#273">273</a> String dbMatchName = dbMatcher.getAttribute(<span class="jxr_string">"db"</span>);
+<a class="jxr_linenumber" name="274" href="#274">274</a> Pattern dbProductPattern = Pattern.compile(dbMatcher.getAttribute(<span class="jxr_string">"databaseProductName"</span>), Pattern.CASE_INSENSITIVE);
+<a class="jxr_linenumber" name="275" href="#275">275</a>
+<a class="jxr_linenumber" name="276" href="#276">276</a> <em class="jxr_comment">// If the connection databaseProcuctName matches the pattern,</em>
+<a class="jxr_linenumber" name="277" href="#277">277</a> <em class="jxr_comment">// use the match name from this matcher.</em>
+<a class="jxr_linenumber" name="278" href="#278">278</a> <strong class="jxr_keyword">if</strong> (dbProductPattern.matcher(dbProductName).find()) {
+<a class="jxr_linenumber" name="279" href="#279">279</a> <strong class="jxr_keyword">return</strong> dbMatchName;
+<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> <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="283" href="#283">283</a> }
+<a class="jxr_linenumber" name="284" href="#284">284</a>
+<a class="jxr_linenumber" name="285" href="#285">285</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="286" href="#286">286</a> <em class="jxr_javadoccomment"> * Gets all the name/value pair db option couples related to the dbProduct,</em>
+<a class="jxr_linenumber" name="287" href="#287">287</a> <em class="jxr_javadoccomment"> * and put them into the dbOptionsMap.</em>
+<a class="jxr_linenumber" name="288" href="#288">288</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="289" href="#289">289</a> <em class="jxr_javadoccomment"> * @param dbProduct</em>
+<a class="jxr_linenumber" name="290" href="#290">290</a> <em class="jxr_javadoccomment"> * the db product used</em>
+<a class="jxr_linenumber" name="291" href="#291">291</a> <em class="jxr_javadoccomment"> * @param dbOptionsElement</em>
+<a class="jxr_linenumber" name="292" href="#292">292</a> <em class="jxr_javadoccomment"> * the XML element containing the options</em>
+<a class="jxr_linenumber" name="293" href="#293">293</a> <em class="jxr_javadoccomment"> * @param dbOptionsMap</em>
+<a class="jxr_linenumber" name="294" href="#294">294</a> <em class="jxr_javadoccomment"> * the <code>Map</code> to populate</em>
+<a class="jxr_linenumber" name="295" href="#295">295</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="296" href="#296">296</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="297" href="#297">297</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> populateDbOptions(String dbProduct, Element dbOptionsElement, Map<String, String> dbOptionsMap) {
+<a class="jxr_linenumber" name="298" href="#298">298</a> NodeList dbOptions = dbOptionsElement.getElementsByTagName(<span class="jxr_string">"dbOption"</span>);
+<a class="jxr_linenumber" name="299" href="#299">299</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < dbOptions.getLength(); i++) {
+<a class="jxr_linenumber" name="300" href="#300">300</a> <em class="jxr_comment">// Get the values for this option element.</em>
+<a class="jxr_linenumber" name="301" href="#301">301</a> Element dbOption = (Element) dbOptions.item(i);
+<a class="jxr_linenumber" name="302" href="#302">302</a> <em class="jxr_comment">// Check is this element is pertinent to the dbProduct</em>
+<a class="jxr_linenumber" name="303" href="#303">303</a> <em class="jxr_comment">// Notice that a missing attribute returns "", good for defaults</em>
+<a class="jxr_linenumber" name="304" href="#304">304</a> <strong class="jxr_keyword">if</strong> (!dbProduct.equalsIgnoreCase(dbOption.getAttribute(<span class="jxr_string">"db"</span>))) {
+<a class="jxr_linenumber" name="305" href="#305">305</a> <strong class="jxr_keyword">continue</strong>;
+<a class="jxr_linenumber" name="306" href="#306">306</a> }
+<a class="jxr_linenumber" name="307" href="#307">307</a> <em class="jxr_comment">// Put into the map</em>
+<a class="jxr_linenumber" name="308" href="#308">308</a> dbOptionsMap.put(dbOption.getAttribute(<span class="jxr_string">"name"</span>), dbOption.getAttribute(<span class="jxr_string">"value"</span>));
+<a class="jxr_linenumber" name="309" href="#309">309</a> }
+<a class="jxr_linenumber" name="310" href="#310">310</a> }
+<a class="jxr_linenumber" name="311" href="#311">311</a>
+<a class="jxr_linenumber" name="312" href="#312">312</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="313" href="#313">313</a> <em class="jxr_javadoccomment"> * Replace substrings of one string with another string and return altered</em>
+<a class="jxr_linenumber" name="314" href="#314">314</a> <em class="jxr_javadoccomment"> * string.</em>
+<a class="jxr_linenumber" name="315" href="#315">315</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="316" href="#316">316</a> <em class="jxr_javadoccomment"> * @param input</em>
+<a class="jxr_linenumber" name="317" href="#317">317</a> <em class="jxr_javadoccomment"> * input string</em>
+<a class="jxr_linenumber" name="318" href="#318">318</a> <em class="jxr_javadoccomment"> * @param find</em>
+<a class="jxr_linenumber" name="319" href="#319">319</a> <em class="jxr_javadoccomment"> * the string to replace</em>
+<a class="jxr_linenumber" name="320" href="#320">320</a> <em class="jxr_javadoccomment"> * @param replace</em>
+<a class="jxr_linenumber" name="321" href="#321">321</a> <em class="jxr_javadoccomment"> * the string to replace with</em>
+<a class="jxr_linenumber" name="322" href="#322">322</a> <em class="jxr_javadoccomment"> * @return the substituted string</em>
+<a class="jxr_linenumber" name="323" href="#323">323</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="324" href="#324">324</a> <strong class="jxr_keyword">private</strong> String substituteSubString(String input, String find, String replace) {
+<a class="jxr_linenumber" name="325" href="#325">325</a> <strong class="jxr_keyword">int</strong> find_length = find.length();
+<a class="jxr_linenumber" name="326" href="#326">326</a> <strong class="jxr_keyword">int</strong> replace_length = replace.length();
+<a class="jxr_linenumber" name="327" href="#327">327</a>
+<a class="jxr_linenumber" name="328" href="#328">328</a> StringBuilder output = <strong class="jxr_keyword">new</strong> StringBuilder(input);
+<a class="jxr_linenumber" name="329" href="#329">329</a> <strong class="jxr_keyword">int</strong> index = input.indexOf(find);
+<a class="jxr_linenumber" name="330" href="#330">330</a> <strong class="jxr_keyword">int</strong> outputOffset = 0;
+<a class="jxr_linenumber" name="331" href="#331">331</a>
+<a class="jxr_linenumber" name="332" href="#332">332</a> <strong class="jxr_keyword">while</strong> (index > -1) {
+<a class="jxr_linenumber" name="333" href="#333">333</a> output.replace(index + outputOffset, index + outputOffset + find_length, replace);
+<a class="jxr_linenumber" name="334" href="#334">334</a> outputOffset = outputOffset + (replace_length - find_length);
+<a class="jxr_linenumber" name="335" href="#335">335</a>
+<a class="jxr_linenumber" name="336" href="#336">336</a> index = input.indexOf(find, index + find_length);
+<a class="jxr_linenumber" name="337" href="#337">337</a> }
+<a class="jxr_linenumber" name="338" href="#338">338</a>
+<a class="jxr_linenumber" name="339" href="#339">339</a> String result = output.toString();
+<a class="jxr_linenumber" name="340" href="#340">340</a> <strong class="jxr_keyword">return</strong> result;
+<a class="jxr_linenumber" name="341" href="#341">341</a> }
+<a class="jxr_linenumber" name="342" href="#342">342</a>
+<a class="jxr_linenumber" name="343" href="#343">343</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="344" href="#344">344</a> <em class="jxr_javadoccomment"> * Returns a named SQL string for the specified connection, replacing</em>
+<a class="jxr_linenumber" name="345" href="#345">345</a> <em class="jxr_javadoccomment"> * parameters with the values set.</em>
+<a class="jxr_linenumber" name="346" href="#346">346</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="347" href="#347">347</a> <em class="jxr_javadoccomment"> * @param name</em>
+<a class="jxr_linenumber" name="348" href="#348">348</a> <em class="jxr_javadoccomment"> * the name of the SQL resource required.</em>
+<a class="jxr_linenumber" name="349" href="#349">349</a> <em class="jxr_javadoccomment"> * @return the requested resource</em>
+<a class="jxr_linenumber" name="350" href="#350">350</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="351" href="#351">351</a> <strong class="jxr_keyword">public</strong> String getSqlString(String name) {
+<a class="jxr_linenumber" name="352" href="#352">352</a> <strong class="jxr_keyword">return</strong> (String) m_sql.get(name);
+<a class="jxr_linenumber" name="353" href="#353">353</a> }
+<a class="jxr_linenumber" name="354" href="#354">354</a>
+<a class="jxr_linenumber" name="355" href="#355">355</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="356" href="#356">356</a> <em class="jxr_javadoccomment"> * Returns a named SQL string for the specified connection, replacing</em>
+<a class="jxr_linenumber" name="357" href="#357">357</a> <em class="jxr_javadoccomment"> * parameters with the values set.</em>
+<a class="jxr_linenumber" name="358" href="#358">358</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="359" href="#359">359</a> <em class="jxr_javadoccomment"> * @throws RuntimeException</em>
+<a class="jxr_linenumber" name="360" href="#360">360</a> <em class="jxr_javadoccomment"> * if a required resource cannot be found.</em>
+<a class="jxr_linenumber" name="361" href="#361">361</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="362" href="#362">362</a> <em class="jxr_javadoccomment"> * @param name</em>
+<a class="jxr_linenumber" name="363" href="#363">363</a> <em class="jxr_javadoccomment"> * the name of the SQL resource required.</em>
+<a class="jxr_linenumber" name="364" href="#364">364</a> <em class="jxr_javadoccomment"> * @param required</em>
+<a class="jxr_linenumber" name="365" href="#365">365</a> <em class="jxr_javadoccomment"> * true if the resource is required</em>
+<a class="jxr_linenumber" name="366" href="#366">366</a> <em class="jxr_javadoccomment"> * @return the requested resource</em>
+<a class="jxr_linenumber" name="367" href="#367">367</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="368" href="#368">368</a> <strong class="jxr_keyword">public</strong> String getSqlString(String name, <strong class="jxr_keyword">boolean</strong> required) {
+<a class="jxr_linenumber" name="369" href="#369">369</a> String sql = getSqlString(name);
+<a class="jxr_linenumber" name="370" href="#370">370</a>
+<a class="jxr_linenumber" name="371" href="#371">371</a> <strong class="jxr_keyword">if</strong> (sql == <strong class="jxr_keyword">null</strong> && required) {
+<a class="jxr_linenumber" name="372" href="#372">372</a> StringBuilder exceptionBuffer = <strong class="jxr_keyword">new</strong> StringBuilder(64).append(<span class="jxr_string">"Required SQL resource: '"</span>).append(name).append(<span class="jxr_string">"' was not found."</span>);
+<a class="jxr_linenumber" name="373" href="#373">373</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(exceptionBuffer.toString());
+<a class="jxr_linenumber" name="374" href="#374">374</a> }
+<a class="jxr_linenumber" name="375" href="#375">375</a> <strong class="jxr_keyword">return</strong> sql;
+<a class="jxr_linenumber" name="376" href="#376">376</a> }
+<a class="jxr_linenumber" name="377" href="#377">377</a>
+<a class="jxr_linenumber" name="378" href="#378">378</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="379" href="#379">379</a> <em class="jxr_javadoccomment"> * Returns the dbOption string value set for the specified dbOption name.</em>
+<a class="jxr_linenumber" name="380" href="#380">380</a> <em class="jxr_javadoccomment"> * </em>
+<a class="jxr_linenumber" name="381" href="#381">381</a> <em class="jxr_javadoccomment"> * @param name</em>
+<a class="jxr_linenumber" name="382" href="#382">382</a> <em class="jxr_javadoccomment"> * the name of the dbOption required.</em>
+<a class="jxr_linenumber" name="383" href="#383">383</a> <em class="jxr_javadoccomment"> * @return the requested dbOption value</em>
+<a class="jxr_linenumber" name="384" href="#384">384</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="385" href="#385">385</a> <strong class="jxr_keyword">public</strong> String getDbOption(String name) {
+<a class="jxr_linenumber" name="386" href="#386">386</a> <strong class="jxr_keyword">return</strong> (String) m_dbOptions.get(name);
+<a class="jxr_linenumber" name="387" href="#387">387</a> }
+<a class="jxr_linenumber" name="388" href="#388">388</a>
+<a class="jxr_linenumber" name="389" href="#389">389</a> }
+</pre>
+<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
+</html>
+
Propchange: james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SqlResources.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SystemContext.html
URL: http://svn.apache.org/viewvc/james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SystemContext.html?rev=1100750&view=auto
==============================================================================
--- james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SystemContext.html (added)
+++ james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SystemContext.html Sun May 8 14:48:12 2011
@@ -0,0 +1,46 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SystemContext xref</title>
+<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
+</head>
+<body>
+<div id="overview"><a href="../../../../../../../../../../../../ai-workspace/target/site/apidocs/org/apache/james/ai/classic/SystemContext.html">View Javadoc</a></div><pre>
+
+<a class="jxr_linenumber" name="1" href="#1">1</a> <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment">**************************************************************</em>
+<a class="jxr_linenumber" name="2" href="#2">2</a> <em class="jxr_javadoccomment"> * Licensed to the Apache Software Foundation (ASF) under one *</em>
+<a class="jxr_linenumber" name="3" href="#3">3</a> <em class="jxr_javadoccomment"> * or more contributor license agreements. See the NOTICE file *</em>
+<a class="jxr_linenumber" name="4" href="#4">4</a> <em class="jxr_javadoccomment"> * distributed with this work for additional information *</em>
+<a class="jxr_linenumber" name="5" href="#5">5</a> <em class="jxr_javadoccomment"> * regarding copyright ownership. The ASF licenses this file *</em>
+<a class="jxr_linenumber" name="6" href="#6">6</a> <em class="jxr_javadoccomment"> * to you under the Apache License, Version 2.0 (the *</em>
+<a class="jxr_linenumber" name="7" href="#7">7</a> <em class="jxr_javadoccomment"> * "License"); you may not use this file except in compliance *</em>
+<a class="jxr_linenumber" name="8" href="#8">8</a> <em class="jxr_javadoccomment"> * with the License. You may obtain a copy of the License at *</em>
+<a class="jxr_linenumber" name="9" href="#9">9</a> <em class="jxr_javadoccomment"> * *</em>
+<a class="jxr_linenumber" name="10" href="#10">10</a> <em class="jxr_javadoccomment"> * <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a> *</em>
+<a class="jxr_linenumber" name="11" href="#11">11</a> <em class="jxr_javadoccomment"> * *</em>
+<a class="jxr_linenumber" name="12" href="#12">12</a> <em class="jxr_javadoccomment"> * Unless required by applicable law or agreed to in writing, *</em>
+<a class="jxr_linenumber" name="13" href="#13">13</a> <em class="jxr_javadoccomment"> * software distributed under the License is distributed on an *</em>
+<a class="jxr_linenumber" name="14" href="#14">14</a> <em class="jxr_javadoccomment"> * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY *</em>
+<a class="jxr_linenumber" name="15" href="#15">15</a> <em class="jxr_javadoccomment"> * KIND, either express or implied. See the License for the *</em>
+<a class="jxr_linenumber" name="16" href="#16">16</a> <em class="jxr_javadoccomment"> * specific language governing permissions and limitations *</em>
+<a class="jxr_linenumber" name="17" href="#17">17</a> <em class="jxr_javadoccomment"> * under the License. *</em>
+<a class="jxr_linenumber" name="18" href="#18">18</a> <em class="jxr_javadoccomment"> ****************************************************************/</em>
+<a class="jxr_linenumber" name="19" href="#19">19</a>
+<a class="jxr_linenumber" name="20" href="#20">20</a> <strong class="jxr_keyword">package</strong> org.apache.james.ai.classic;
+<a class="jxr_linenumber" name="21" href="#21">21</a>
+<a class="jxr_linenumber" name="22" href="#22">22</a> <strong class="jxr_keyword">import</strong> java.io.IOException;
+<a class="jxr_linenumber" name="23" href="#23">23</a>
+<a class="jxr_linenumber" name="24" href="#24">24</a> <strong class="jxr_keyword">import</strong> org.w3c.dom.Document;
+<a class="jxr_linenumber" name="25" href="#25">25</a>
+<a class="jxr_linenumber" name="26" href="#26">26</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="27" href="#27">27</a> <em class="jxr_javadoccomment"> * Lightweight, read only filesystem access.</em>
+<a class="jxr_linenumber" name="28" href="#28">28</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="29" href="#29">29</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">interface</strong> <a href="../../../../../org/apache/james/ai/classic/SystemContext.html">SystemContext</a> {
+<a class="jxr_linenumber" name="30" href="#30">30</a>
+<a class="jxr_linenumber" name="31" href="#31">31</a> <strong class="jxr_keyword">public</strong> Document readXml(<strong class="jxr_keyword">final</strong> String name) <strong class="jxr_keyword">throws</strong> IOException;
+<a class="jxr_linenumber" name="32" href="#32">32</a> }
+</pre>
+<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
+</html>
+
Propchange: james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/SystemContext.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-frame.html
URL: http://svn.apache.org/viewvc/james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-frame.html?rev=1100750&view=auto
==============================================================================
--- james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-frame.html (added)
+++ james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-frame.html Sun May 8 14:48:12 2011
@@ -0,0 +1,48 @@
+
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
+<html xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+ <title>Apache James AI Mailets Project 0.1-SNAPSHOT Reference Package org.apache.james.ai.classic</title>
+ <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="style" />
+ </head>
+ <body>
+
+ <h3>
+ <a href="package-summary.html" target="classFrame">org.apache.james.ai.classic</a>
+ </h3>
+
+ <h3>Classes</h3>
+
+ <ul>
+ <li>
+ <a href="BayesianAnalysis.html" target="classFrame">BayesianAnalysis</a>
+ </li>
+ <li>
+ <a href="BayesianAnalysisFeeder.html" target="classFrame">BayesianAnalysisFeeder</a>
+ </li>
+ <li>
+ <a href="BayesianAnalyzer.html" target="classFrame">BayesianAnalyzer</a>
+ </li>
+ <li>
+ <a href="BayesianAnalysis.html" target="classFrame">CorpusLoader</a>
+ </li>
+ <li>
+ <a href="JDBCBayesianAnalyzer.html" target="classFrame">JDBCBayesianAnalyzer</a>
+ </li>
+ <li>
+ <a href="JDBCUtil.html" target="classFrame">JDBCUtil</a>
+ </li>
+ <li>
+ <a href="SqlResources.html" target="classFrame">SqlResources</a>
+ </li>
+ <li>
+ <a href="SystemContext.html" target="classFrame">SystemContext</a>
+ </li>
+ <li>
+ <a href="BayesianAnalyzer.html" target="classFrame">TokenProbabilityStrength</a>
+ </li>
+ </ul>
+
+ </body>
+</html>
\ No newline at end of file
Propchange: james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-frame.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-summary.html
URL: http://svn.apache.org/viewvc/james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-summary.html?rev=1100750&view=auto
==============================================================================
--- james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-summary.html (added)
+++ james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-summary.html Sun May 8 14:48:12 2011
@@ -0,0 +1,107 @@
+
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
+<html xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+ <title>Apache James AI Mailets Project 0.1-SNAPSHOT Reference Package org.apache.james.ai.classic</title>
+ <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="style" />
+ </head>
+ <body>
+ <div class="overview">
+ <ul>
+ <li>
+ <a href="../../../../../overview-summary.html">Overview</a>
+ </li>
+ <li class="selected">Package</li>
+ </ul>
+ </div>
+ <div class="framenoframe">
+ <ul>
+ <li>
+ <a href="../../../../../index.html" target="_top">FRAMES</a>
+ </li>
+ <li>
+ <a href="package-summary.html" target="_top">NO FRAMES</a>
+ </li>
+ </ul>
+ </div>
+
+ <h2>Package org.apache.james.ai.classic</h2>
+
+ <table class="summary">
+ <thead>
+ <tr>
+ <th>Class Summary</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td>
+ <a href="BayesianAnalysis.html" target="classFrame">BayesianAnalysis</a>
+ </td>
+ </tr>
+ <tr>
+ <td>
+ <a href="BayesianAnalysisFeeder.html" target="classFrame">BayesianAnalysisFeeder</a>
+ </td>
+ </tr>
+ <tr>
+ <td>
+ <a href="BayesianAnalyzer.html" target="classFrame">BayesianAnalyzer</a>
+ </td>
+ </tr>
+ <tr>
+ <td>
+ <a href="BayesianAnalysis.html" target="classFrame">CorpusLoader</a>
+ </td>
+ </tr>
+ <tr>
+ <td>
+ <a href="JDBCBayesianAnalyzer.html" target="classFrame">JDBCBayesianAnalyzer</a>
+ </td>
+ </tr>
+ <tr>
+ <td>
+ <a href="JDBCUtil.html" target="classFrame">JDBCUtil</a>
+ </td>
+ </tr>
+ <tr>
+ <td>
+ <a href="SqlResources.html" target="classFrame">SqlResources</a>
+ </td>
+ </tr>
+ <tr>
+ <td>
+ <a href="SystemContext.html" target="classFrame">SystemContext</a>
+ </td>
+ </tr>
+ <tr>
+ <td>
+ <a href="BayesianAnalyzer.html" target="classFrame">TokenProbabilityStrength</a>
+ </td>
+ </tr>
+ </tbody>
+ </table>
+
+ <div class="overview">
+ <ul>
+ <li>
+ <a href="../../../../../overview-summary.html">Overview</a>
+ </li>
+ <li class="selected">Package</li>
+ </ul>
+ </div>
+ <div class="framenoframe">
+ <ul>
+ <li>
+ <a href="../../../../../index.html" target="_top">FRAMES</a>
+ </li>
+ <li>
+ <a href="package-summary.html" target="_top">NO FRAMES</a>
+ </li>
+ </ul>
+ </div>
+ <hr />
+ Copyright © 2011 The Apache Software Foundation. All Rights Reserved.
+ </body>
+</html>
\ No newline at end of file
Propchange: james/site/trunk/www/mailet/ai/xref/org/apache/james/ai/classic/package-summary.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: james/site/trunk/www/mailet/ai/xref/overview-frame.html
URL: http://svn.apache.org/viewvc/james/site/trunk/www/mailet/ai/xref/overview-frame.html?rev=1100750&view=auto
==============================================================================
--- james/site/trunk/www/mailet/ai/xref/overview-frame.html (added)
+++ james/site/trunk/www/mailet/ai/xref/overview-frame.html Sun May 8 14:48:12 2011
@@ -0,0 +1,25 @@
+
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
+<html xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+ <title>Apache James AI Mailets Project 0.1-SNAPSHOT Reference</title>
+ <link rel="stylesheet" type="text/css" href="stylesheet.css" title="style" />
+ </head>
+ <body>
+
+ <h3>
+ <a href="allclasses-frame.html" target="packageFrame">All Classes</a>
+ </h3>
+
+ <h3>Packages</h3>
+
+ <ul>
+ <li>
+ <a href="org/apache/james/ai/classic/package-frame.html" target="packageFrame">org.apache.james.ai.classic</a>
+ </li>
+ </ul>
+
+ </body>
+</html>
+
Propchange: james/site/trunk/www/mailet/ai/xref/overview-frame.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: james/site/trunk/www/mailet/ai/xref/overview-summary.html
URL: http://svn.apache.org/viewvc/james/site/trunk/www/mailet/ai/xref/overview-summary.html?rev=1100750&view=auto
==============================================================================
--- james/site/trunk/www/mailet/ai/xref/overview-summary.html (added)
+++ james/site/trunk/www/mailet/ai/xref/overview-summary.html Sun May 8 14:48:12 2011
@@ -0,0 +1,64 @@
+
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
+<html xml:lang="en" lang="en">
+ <head>
+ <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+ <title>Apache James AI Mailets Project 0.1-SNAPSHOT Reference</title>
+ <link rel="stylesheet" type="text/css" href="stylesheet.css" title="style" />
+ </head>
+ <body>
+ <div class="overview">
+ <ul>
+ <li class="selected">Overview</li>
+ <li>Package</li>
+ </ul>
+ </div>
+ <div class="framenoframe">
+ <ul>
+ <li>
+ <a href="index.html" target="_top">FRAMES</a>
+ </li>
+ <li>
+ <a href="overview-summary.html" target="_top">NO FRAMES</a>
+ </li>
+ </ul>
+ </div>
+
+ <h2>Apache James AI Mailets Project 0.1-SNAPSHOT Reference</h2>
+
+ <table class="summary">
+ <thead>
+ <tr>
+ <th>Packages</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td>
+ <a href="org/apache/james/ai/classic/package-summary.html">org.apache.james.ai.classic</a>
+ </td>
+ </tr>
+ </tbody>
+ </table>
+
+ <div class="overview">
+ <ul>
+ <li class="selected">Overview</li>
+ <li>Package</li>
+ </ul>
+ </div>
+ <div class="framenoframe">
+ <ul>
+ <li>
+ <a href="index.html" target="_top">FRAMES</a>
+ </li>
+ <li>
+ <a href="overview-summary.html" target="_top">NO FRAMES</a>
+ </li>
+ </ul>
+ </div>
+
+ <hr />
+ Copyright © 2011 The Apache Software Foundation. All Rights Reserved.
+ </body>
+</html>
\ No newline at end of file
Propchange: james/site/trunk/www/mailet/ai/xref/overview-summary.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: james/site/trunk/www/mailet/ai/xref/stylesheet.css
URL: http://svn.apache.org/viewvc/james/site/trunk/www/mailet/ai/xref/stylesheet.css?rev=1100750&view=auto
==============================================================================
--- james/site/trunk/www/mailet/ai/xref/stylesheet.css (added)
+++ james/site/trunk/www/mailet/ai/xref/stylesheet.css Sun May 8 14:48:12 2011
@@ -0,0 +1,116 @@
+/* Javadoc style sheet */
+/* Define colors, fonts and other style attributes here to override the defaults */
+body {
+ background-color: #fff;
+ font-family: Arial, Helvetica, sans-serif;
+}
+
+a:link {
+ color: #00f;
+}
+a:visited {
+ color: #00a;
+}
+
+a:active, a:hover {
+ color: #f30 !important;
+}
+
+ul, li {
+ list-style-type:none;
+ margin:0;
+ padding:0;
+}
+
+table td {
+ padding: 3px;
+ border: 1px solid #000;
+}
+table {
+ width:100%;
+ border: 1px solid #000;
+ border-collapse: collapse;
+}
+
+div.overview {
+ background-color:#ddd;
+ padding: 4px 4px 4px 0;
+}
+div.overview li, div.framenoframe li {
+ display: inline;
+}
+div.framenoframe {
+ text-align: center;
+ font-size: x-small;
+}
+div.framenoframe li {
+ margin: 0 3px 0 3px;
+}
+div.overview li {
+ margin:3px 3px 0 3px;
+ padding: 4px;
+}
+li.selected {
+ background-color:#888;
+ color: #fff;
+ font-weight: bold;
+}
+
+table.summary {
+ margin-bottom: 20px;
+}
+table.summary td, table.summary th {
+ font-weight: bold;
+ text-align: left;
+ padding: 3px;
+}
+table.summary th {
+ background-color:#036;
+ color: #fff;
+}
+table.summary td {
+ background-color:#eee;
+ border: 1px solid black;
+}
+
+em {
+ color: #A00;
+}
+em.comment {
+ color: #390;
+}
+.string {
+ color: #009;
+}
+div#footer {
+ text-align:center;
+}
+#overview {
+ padding:2px;
+}
+
+hr {
+ height: 1px;
+ color: #000;
+}
+
+/* JXR style sheet */
+.jxr_comment
+{
+ color: #390;
+}
+
+.jxr_javadoccomment
+{
+ color: #A00;
+}
+
+.jxr_string
+{
+ color: #009;
+}
+
+.jxr_keyword
+{
+ color: #000;
+}
Propchange: james/site/trunk/www/mailet/ai/xref/stylesheet.css
------------------------------------------------------------------------------
svn:eol-style = native