blob: 3f1ba7e85fe62ce3c934616a0d81149169b17c29 [file] [log] [blame]
<!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>JdbcDatabaseManager xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../../../../apidocs/org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">View Javadoc</a></div><pre>
<a class="jxr_linenumber" name="L1" href="#L1">1</a> <em class="jxr_comment">/*</em>
<a class="jxr_linenumber" name="L2" href="#L2">2</a> <em class="jxr_comment"> * Licensed to the Apache Software Foundation (ASF) under one or more</em>
<a class="jxr_linenumber" name="L3" href="#L3">3</a> <em class="jxr_comment"> * contributor license agreements. See the NOTICE file distributed with</em>
<a class="jxr_linenumber" name="L4" href="#L4">4</a> <em class="jxr_comment"> * this work for additional information regarding copyright ownership.</em>
<a class="jxr_linenumber" name="L5" href="#L5">5</a> <em class="jxr_comment"> * The ASF licenses this file to You under the Apache license, Version 2.0</em>
<a class="jxr_linenumber" name="L6" href="#L6">6</a> <em class="jxr_comment"> * (the "License"); you may not use this file except in compliance with</em>
<a class="jxr_linenumber" name="L7" href="#L7">7</a> <em class="jxr_comment"> * the License. You may obtain a copy of the License at</em>
<a class="jxr_linenumber" name="L8" href="#L8">8</a> <em class="jxr_comment"> *</em>
<a class="jxr_linenumber" name="L9" href="#L9">9</a> <em class="jxr_comment"> * <a href="http://www.apache.org/licenses/LICENSE-2." target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.</a>0</em>
<a class="jxr_linenumber" name="L10" href="#L10">10</a> <em class="jxr_comment"> *</em>
<a class="jxr_linenumber" name="L11" href="#L11">11</a> <em class="jxr_comment"> * Unless required by applicable law or agreed to in writing, software</em>
<a class="jxr_linenumber" name="L12" href="#L12">12</a> <em class="jxr_comment"> * distributed under the License is distributed on an "AS IS" BASIS,</em>
<a class="jxr_linenumber" name="L13" href="#L13">13</a> <em class="jxr_comment"> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</em>
<a class="jxr_linenumber" name="L14" href="#L14">14</a> <em class="jxr_comment"> * See the license for the specific language governing permissions and</em>
<a class="jxr_linenumber" name="L15" href="#L15">15</a> <em class="jxr_comment"> * limitations under the license.</em>
<a class="jxr_linenumber" name="L16" href="#L16">16</a> <em class="jxr_comment"> */</em>
<a class="jxr_linenumber" name="L17" href="#L17">17</a> <strong class="jxr_keyword">package</strong> org.apache.logging.log4j.core.appender.db.jdbc;
<a class="jxr_linenumber" name="L18" href="#L18">18</a>
<a class="jxr_linenumber" name="L19" href="#L19">19</a> <strong class="jxr_keyword">import</strong> java.io.Serializable;
<a class="jxr_linenumber" name="L20" href="#L20">20</a> <strong class="jxr_keyword">import</strong> java.io.StringReader;
<a class="jxr_linenumber" name="L21" href="#L21">21</a> <strong class="jxr_keyword">import</strong> java.sql.Clob;
<a class="jxr_linenumber" name="L22" href="#L22">22</a> <strong class="jxr_keyword">import</strong> java.sql.Connection;
<a class="jxr_linenumber" name="L23" href="#L23">23</a> <strong class="jxr_keyword">import</strong> java.sql.DatabaseMetaData;
<a class="jxr_linenumber" name="L24" href="#L24">24</a> <strong class="jxr_keyword">import</strong> java.sql.NClob;
<a class="jxr_linenumber" name="L25" href="#L25">25</a> <strong class="jxr_keyword">import</strong> java.sql.PreparedStatement;
<a class="jxr_linenumber" name="L26" href="#L26">26</a> <strong class="jxr_keyword">import</strong> java.sql.ResultSetMetaData;
<a class="jxr_linenumber" name="L27" href="#L27">27</a> <strong class="jxr_keyword">import</strong> java.sql.SQLException;
<a class="jxr_linenumber" name="L28" href="#L28">28</a> <strong class="jxr_keyword">import</strong> java.sql.SQLTransactionRollbackException;
<a class="jxr_linenumber" name="L29" href="#L29">29</a> <strong class="jxr_keyword">import</strong> java.sql.Statement;
<a class="jxr_linenumber" name="L30" href="#L30">30</a> <strong class="jxr_keyword">import</strong> java.sql.Timestamp;
<a class="jxr_linenumber" name="L31" href="#L31">31</a> <strong class="jxr_keyword">import</strong> java.sql.Types;
<a class="jxr_linenumber" name="L32" href="#L32">32</a> <strong class="jxr_keyword">import</strong> java.util.ArrayList;
<a class="jxr_linenumber" name="L33" href="#L33">33</a> <strong class="jxr_keyword">import</strong> java.util.Arrays;
<a class="jxr_linenumber" name="L34" href="#L34">34</a> <strong class="jxr_keyword">import</strong> java.util.Date;
<a class="jxr_linenumber" name="L35" href="#L35">35</a> <strong class="jxr_keyword">import</strong> java.util.HashMap;
<a class="jxr_linenumber" name="L36" href="#L36">36</a> <strong class="jxr_keyword">import</strong> java.util.List;
<a class="jxr_linenumber" name="L37" href="#L37">37</a> <strong class="jxr_keyword">import</strong> java.util.Map;
<a class="jxr_linenumber" name="L38" href="#L38">38</a> <strong class="jxr_keyword">import</strong> java.util.Objects;
<a class="jxr_linenumber" name="L39" href="#L39">39</a> <strong class="jxr_keyword">import</strong> java.util.concurrent.CountDownLatch;
<a class="jxr_linenumber" name="L40" href="#L40">40</a>
<a class="jxr_linenumber" name="L41" href="#L41">41</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.Layout;
<a class="jxr_linenumber" name="L42" href="#L42">42</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.LogEvent;
<a class="jxr_linenumber" name="L43" href="#L43">43</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.StringLayout;
<a class="jxr_linenumber" name="L44" href="#L44">44</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.appender.AppenderLoggingException;
<a class="jxr_linenumber" name="L45" href="#L45">45</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.appender.ManagerFactory;
<a class="jxr_linenumber" name="L46" href="#L46">46</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.appender.db.AbstractDatabaseAppender;
<a class="jxr_linenumber" name="L47" href="#L47">47</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.appender.db.AbstractDatabaseManager;
<a class="jxr_linenumber" name="L48" href="#L48">48</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.appender.db.ColumnMapping;
<a class="jxr_linenumber" name="L49" href="#L49">49</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.appender.db.DbAppenderLoggingException;
<a class="jxr_linenumber" name="L50" href="#L50">50</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.config.plugins.convert.DateTypeConverter;
<a class="jxr_linenumber" name="L51" href="#L51">51</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.config.plugins.convert.TypeConverters;
<a class="jxr_linenumber" name="L52" href="#L52">52</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.util.Closer;
<a class="jxr_linenumber" name="L53" href="#L53">53</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.core.util.Log4jThread;
<a class="jxr_linenumber" name="L54" href="#L54">54</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.message.MapMessage;
<a class="jxr_linenumber" name="L55" href="#L55">55</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.spi.ThreadContextMap;
<a class="jxr_linenumber" name="L56" href="#L56">56</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.spi.ThreadContextStack;
<a class="jxr_linenumber" name="L57" href="#L57">57</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.util.IndexedReadOnlyStringMap;
<a class="jxr_linenumber" name="L58" href="#L58">58</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.util.ReadOnlyStringMap;
<a class="jxr_linenumber" name="L59" href="#L59">59</a> <strong class="jxr_keyword">import</strong> org.apache.logging.log4j.util.Strings;
<a class="jxr_linenumber" name="L60" href="#L60">60</a>
<a class="jxr_linenumber" name="L61" href="#L61">61</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L62" href="#L62">62</a> <em class="jxr_javadoccomment"> * An {@link AbstractDatabaseManager} implementation for relational databases accessed via JDBC.</em>
<a class="jxr_linenumber" name="L63" href="#L63">63</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L64" href="#L64">64</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManager</a> <strong class="jxr_keyword">extends</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/AbstractDatabaseManager.html">AbstractDatabaseManager</a> {
<a class="jxr_linenumber" name="L65" href="#L65">65</a>
<a class="jxr_linenumber" name="L66" href="#L66">66</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L67" href="#L67">67</a> <em class="jxr_javadoccomment"> * Encapsulates data that {@link JdbcDatabaseManagerFactory} uses to create managers.</em>
<a class="jxr_linenumber" name="L68" href="#L68">68</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L69" href="#L69">69</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a> <strong class="jxr_keyword">extends</strong> AbstractDatabaseManager.AbstractFactoryData {
<a class="jxr_linenumber" name="L70" href="#L70">70</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ConnectionSource.html">ConnectionSource</a> connectionSource;
<a class="jxr_linenumber" name="L71" href="#L71">71</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String tableName;
<a class="jxr_linenumber" name="L72" href="#L72">72</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ColumnConfig.html">ColumnConfig</a>[] columnConfigs;
<a class="jxr_linenumber" name="L73" href="#L73">73</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/ColumnMapping.html">ColumnMapping</a>[] columnMappings;
<a class="jxr_linenumber" name="L74" href="#L74">74</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> immediateFail;
<a class="jxr_linenumber" name="L75" href="#L75">75</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> retry;
<a class="jxr_linenumber" name="L76" href="#L76">76</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">long</strong> reconnectIntervalMillis;
<a class="jxr_linenumber" name="L77" href="#L77">77</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> truncateStrings;
<a class="jxr_linenumber" name="L78" href="#L78">78</a>
<a class="jxr_linenumber" name="L79" href="#L79">79</a> <strong class="jxr_keyword">protected</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a>(<strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> bufferSize, <strong class="jxr_keyword">final</strong> Layout&lt;? <strong class="jxr_keyword">extends</strong> Serializable&gt; layout,
<a class="jxr_linenumber" name="L80" href="#L80">80</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ConnectionSource.html">ConnectionSource</a> connectionSource, <strong class="jxr_keyword">final</strong> String tableName, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ColumnConfig.html">ColumnConfig</a>[] columnConfigs,
<a class="jxr_linenumber" name="L81" href="#L81">81</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/ColumnMapping.html">ColumnMapping</a>[] columnMappings, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> immediateFail, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">long</strong> reconnectIntervalMillis,
<a class="jxr_linenumber" name="L82" href="#L82">82</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> truncateStrings) {
<a class="jxr_linenumber" name="L83" href="#L83">83</a> <strong class="jxr_keyword">super</strong>(bufferSize, layout);
<a class="jxr_linenumber" name="L84" href="#L84">84</a> <strong class="jxr_keyword">this</strong>.connectionSource = connectionSource;
<a class="jxr_linenumber" name="L85" href="#L85">85</a> <strong class="jxr_keyword">this</strong>.tableName = tableName;
<a class="jxr_linenumber" name="L86" href="#L86">86</a> <strong class="jxr_keyword">this</strong>.columnConfigs = columnConfigs;
<a class="jxr_linenumber" name="L87" href="#L87">87</a> <strong class="jxr_keyword">this</strong>.columnMappings = columnMappings;
<a class="jxr_linenumber" name="L88" href="#L88">88</a> <strong class="jxr_keyword">this</strong>.immediateFail = immediateFail;
<a class="jxr_linenumber" name="L89" href="#L89">89</a> <strong class="jxr_keyword">this</strong>.retry = reconnectIntervalMillis &gt; 0;
<a class="jxr_linenumber" name="L90" href="#L90">90</a> <strong class="jxr_keyword">this</strong>.reconnectIntervalMillis = reconnectIntervalMillis;
<a class="jxr_linenumber" name="L91" href="#L91">91</a> <strong class="jxr_keyword">this</strong>.truncateStrings = truncateStrings;
<a class="jxr_linenumber" name="L92" href="#L92">92</a> }
<a class="jxr_linenumber" name="L93" href="#L93">93</a>
<a class="jxr_linenumber" name="L94" href="#L94">94</a> @Override
<a class="jxr_linenumber" name="L95" href="#L95">95</a> <strong class="jxr_keyword">public</strong> String toString() {
<a class="jxr_linenumber" name="L96" href="#L96">96</a> <strong class="jxr_keyword">return</strong> String.format(
<a class="jxr_linenumber" name="L97" href="#L97">97</a> <span class="jxr_string">"FactoryData [connectionSource=%s, tableName=%s, columnConfigs=%s, columnMappings=%s, immediateFail=%s, retry=%s, reconnectIntervalMillis=%s, truncateStrings=%s]"</span>,
<a class="jxr_linenumber" name="L98" href="#L98">98</a> connectionSource, tableName, Arrays.toString(columnConfigs), Arrays.toString(columnMappings),
<a class="jxr_linenumber" name="L99" href="#L99">99</a> immediateFail, retry, reconnectIntervalMillis, truncateStrings);
<a class="jxr_linenumber" name="L100" href="#L100">100</a> }
<a class="jxr_linenumber" name="L101" href="#L101">101</a> }
<a class="jxr_linenumber" name="L102" href="#L102">102</a>
<a class="jxr_linenumber" name="L103" href="#L103">103</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L104" href="#L104">104</a> <em class="jxr_javadoccomment"> * Creates managers.</em>
<a class="jxr_linenumber" name="L105" href="#L105">105</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L106" href="#L106">106</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManagerFactory</a> <strong class="jxr_keyword">implements</strong> ManagerFactory&lt;JdbcDatabaseManager, FactoryData&gt; {
<a class="jxr_linenumber" name="L107" href="#L107">107</a>
<a class="jxr_linenumber" name="L108" href="#L108">108</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">char</strong> PARAMETER_MARKER = '?';
<a class="jxr_linenumber" name="L109" href="#L109">109</a>
<a class="jxr_linenumber" name="L110" href="#L110">110</a> @Override
<a class="jxr_linenumber" name="L111" href="#L111">111</a> <strong class="jxr_keyword">public</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManager</a> createManager(<strong class="jxr_keyword">final</strong> String name, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a> data) {
<a class="jxr_linenumber" name="L112" href="#L112">112</a> <strong class="jxr_keyword">final</strong> StringBuilder sb = <strong class="jxr_keyword">new</strong> StringBuilder(<span class="jxr_string">"insert into "</span>).append(data.tableName).append(<span class="jxr_string">" ("</span>);
<a class="jxr_linenumber" name="L113" href="#L113">113</a> <em class="jxr_comment">// so this gets a little more complicated now that there are two ways to configure column mappings, but</em>
<a class="jxr_linenumber" name="L114" href="#L114">114</a> <em class="jxr_comment">// both mappings follow the same exact pattern for the prepared statement</em>
<a class="jxr_linenumber" name="L115" href="#L115">115</a> appendColumnNames(<span class="jxr_string">"INSERT"</span>, data, sb);
<a class="jxr_linenumber" name="L116" href="#L116">116</a> sb.append(<span class="jxr_string">") values ("</span>);
<a class="jxr_linenumber" name="L117" href="#L117">117</a> <strong class="jxr_keyword">int</strong> i = 1;
<a class="jxr_linenumber" name="L118" href="#L118">118</a> <strong class="jxr_keyword">if</strong> (data.columnMappings != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L119" href="#L119">119</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> ColumnMapping mapping : data.columnMappings) {
<a class="jxr_linenumber" name="L120" href="#L120">120</a> <strong class="jxr_keyword">final</strong> String mappingName = mapping.getName();
<a class="jxr_linenumber" name="L121" href="#L121">121</a> <strong class="jxr_keyword">if</strong> (Strings.isNotEmpty(mapping.getLiteralValue())) {
<a class="jxr_linenumber" name="L122" href="#L122">122</a> logger().trace(<span class="jxr_string">"Adding INSERT VALUES literal for ColumnMapping[{}]: {}={} "</span>, i, mappingName,
<a class="jxr_linenumber" name="L123" href="#L123">123</a> mapping.getLiteralValue());
<a class="jxr_linenumber" name="L124" href="#L124">124</a> sb.append(mapping.getLiteralValue());
<a class="jxr_linenumber" name="L125" href="#L125">125</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (Strings.isNotEmpty(mapping.getParameter())) {
<a class="jxr_linenumber" name="L126" href="#L126">126</a> logger().trace(<span class="jxr_string">"Adding INSERT VALUES parameter for ColumnMapping[{}]: {}={} "</span>, i, mappingName,
<a class="jxr_linenumber" name="L127" href="#L127">127</a> mapping.getParameter());
<a class="jxr_linenumber" name="L128" href="#L128">128</a> sb.append(mapping.getParameter());
<a class="jxr_linenumber" name="L129" href="#L129">129</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L130" href="#L130">130</a> logger().trace(<span class="jxr_string">"Adding INSERT VALUES parameter marker for ColumnMapping[{}]: {}={} "</span>, i,
<a class="jxr_linenumber" name="L131" href="#L131">131</a> mappingName, PARAMETER_MARKER);
<a class="jxr_linenumber" name="L132" href="#L132">132</a> sb.append(PARAMETER_MARKER);
<a class="jxr_linenumber" name="L133" href="#L133">133</a> }
<a class="jxr_linenumber" name="L134" href="#L134">134</a> sb.append(',');
<a class="jxr_linenumber" name="L135" href="#L135">135</a> i++;
<a class="jxr_linenumber" name="L136" href="#L136">136</a> }
<a class="jxr_linenumber" name="L137" href="#L137">137</a> }
<a class="jxr_linenumber" name="L138" href="#L138">138</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> columnConfigsLen = data.columnConfigs == <strong class="jxr_keyword">null</strong> ? 0 : data.columnConfigs.length;
<a class="jxr_linenumber" name="L139" href="#L139">139</a> <strong class="jxr_keyword">final</strong> List&lt;ColumnConfig&gt; columnConfigs = <strong class="jxr_keyword">new</strong> ArrayList&lt;&gt;(columnConfigsLen);
<a class="jxr_linenumber" name="L140" href="#L140">140</a> <strong class="jxr_keyword">if</strong> (data.columnConfigs != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L141" href="#L141">141</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> ColumnConfig config : data.columnConfigs) {
<a class="jxr_linenumber" name="L142" href="#L142">142</a> <strong class="jxr_keyword">if</strong> (Strings.isNotEmpty(config.getLiteralValue())) {
<a class="jxr_linenumber" name="L143" href="#L143">143</a> sb.append(config.getLiteralValue());
<a class="jxr_linenumber" name="L144" href="#L144">144</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L145" href="#L145">145</a> sb.append(PARAMETER_MARKER);
<a class="jxr_linenumber" name="L146" href="#L146">146</a> columnConfigs.add(config);
<a class="jxr_linenumber" name="L147" href="#L147">147</a> }
<a class="jxr_linenumber" name="L148" href="#L148">148</a> sb.append(',');
<a class="jxr_linenumber" name="L149" href="#L149">149</a> }
<a class="jxr_linenumber" name="L150" href="#L150">150</a> }
<a class="jxr_linenumber" name="L151" href="#L151">151</a> <em class="jxr_comment">// at least one of those arrays is guaranteed to be non-empty</em>
<a class="jxr_linenumber" name="L152" href="#L152">152</a> sb.setCharAt(sb.length() - 1, ')');
<a class="jxr_linenumber" name="L153" href="#L153">153</a> <strong class="jxr_keyword">final</strong> String sqlStatement = sb.toString();
<a class="jxr_linenumber" name="L154" href="#L154">154</a>
<a class="jxr_linenumber" name="L155" href="#L155">155</a> <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManager</a>(name, sqlStatement, columnConfigs, data);
<a class="jxr_linenumber" name="L156" href="#L156">156</a> }
<a class="jxr_linenumber" name="L157" href="#L157">157</a> }
<a class="jxr_linenumber" name="L158" href="#L158">158</a>
<a class="jxr_linenumber" name="L159" href="#L159">159</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L160" href="#L160">160</a> <em class="jxr_javadoccomment"> * Handles reconnecting to JDBC once on a Thread.</em>
<a class="jxr_linenumber" name="L161" href="#L161">161</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L162" href="#L162">162</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">Reconnector</a> <strong class="jxr_keyword">extends</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/util/Log4jThread.html">Log4jThread</a> {
<a class="jxr_linenumber" name="L163" href="#L163">163</a>
<a class="jxr_linenumber" name="L164" href="#L164">164</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> CountDownLatch latch = <strong class="jxr_keyword">new</strong> CountDownLatch(1);
<a class="jxr_linenumber" name="L165" href="#L165">165</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">volatile</strong> <strong class="jxr_keyword">boolean</strong> shutdown = false;
<a class="jxr_linenumber" name="L166" href="#L166">166</a>
<a class="jxr_linenumber" name="L167" href="#L167">167</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">Reconnector</a>() {
<a class="jxr_linenumber" name="L168" href="#L168">168</a> <strong class="jxr_keyword">super</strong>(<span class="jxr_string">"JdbcDatabaseManager-Reconnector"</span>);
<a class="jxr_linenumber" name="L169" href="#L169">169</a> }
<a class="jxr_linenumber" name="L170" href="#L170">170</a>
<a class="jxr_linenumber" name="L171" href="#L171">171</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> latch() {
<a class="jxr_linenumber" name="L172" href="#L172">172</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L173" href="#L173">173</a> latch.await();
<a class="jxr_linenumber" name="L174" href="#L174">174</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> InterruptedException ex) {
<a class="jxr_linenumber" name="L175" href="#L175">175</a> <em class="jxr_comment">// Ignore the exception.</em>
<a class="jxr_linenumber" name="L176" href="#L176">176</a> }
<a class="jxr_linenumber" name="L177" href="#L177">177</a> }
<a class="jxr_linenumber" name="L178" href="#L178">178</a>
<a class="jxr_linenumber" name="L179" href="#L179">179</a> <strong class="jxr_keyword">void</strong> reconnect() <strong class="jxr_keyword">throws</strong> SQLException {
<a class="jxr_linenumber" name="L180" href="#L180">180</a> closeResources(false);
<a class="jxr_linenumber" name="L181" href="#L181">181</a> connectAndPrepare();
<a class="jxr_linenumber" name="L182" href="#L182">182</a> reconnector = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="L183" href="#L183">183</a> shutdown = <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="L184" href="#L184">184</a> logger().debug(<span class="jxr_string">"Connection reestablished to {}"</span>, factoryData);
<a class="jxr_linenumber" name="L185" href="#L185">185</a> }
<a class="jxr_linenumber" name="L186" href="#L186">186</a>
<a class="jxr_linenumber" name="L187" href="#L187">187</a> @Override
<a class="jxr_linenumber" name="L188" href="#L188">188</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> run() {
<a class="jxr_linenumber" name="L189" href="#L189">189</a> <strong class="jxr_keyword">while</strong> (!shutdown) {
<a class="jxr_linenumber" name="L190" href="#L190">190</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L191" href="#L191">191</a> sleep(factoryData.reconnectIntervalMillis);
<a class="jxr_linenumber" name="L192" href="#L192">192</a> reconnect();
<a class="jxr_linenumber" name="L193" href="#L193">193</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> InterruptedException | SQLException e) {
<a class="jxr_linenumber" name="L194" href="#L194">194</a> logger().debug(<span class="jxr_string">"Cannot reestablish JDBC connection to {}: {}"</span>, factoryData, e.getLocalizedMessage(),
<a class="jxr_linenumber" name="L195" href="#L195">195</a> e);
<a class="jxr_linenumber" name="L196" href="#L196">196</a> } <strong class="jxr_keyword">finally</strong> {
<a class="jxr_linenumber" name="L197" href="#L197">197</a> latch.countDown();
<a class="jxr_linenumber" name="L198" href="#L198">198</a> }
<a class="jxr_linenumber" name="L199" href="#L199">199</a> }
<a class="jxr_linenumber" name="L200" href="#L200">200</a> }
<a class="jxr_linenumber" name="L201" href="#L201">201</a>
<a class="jxr_linenumber" name="L202" href="#L202">202</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> shutdown() {
<a class="jxr_linenumber" name="L203" href="#L203">203</a> shutdown = <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="L204" href="#L204">204</a> }
<a class="jxr_linenumber" name="L205" href="#L205">205</a>
<a class="jxr_linenumber" name="L206" href="#L206">206</a> @Override
<a class="jxr_linenumber" name="L207" href="#L207">207</a> <strong class="jxr_keyword">public</strong> String toString() {
<a class="jxr_linenumber" name="L208" href="#L208">208</a> <strong class="jxr_keyword">return</strong> String.format(<span class="jxr_string">"Reconnector [latch=%s, shutdown=%s]"</span>, latch, shutdown);
<a class="jxr_linenumber" name="L209" href="#L209">209</a> }
<a class="jxr_linenumber" name="L210" href="#L210">210</a>
<a class="jxr_linenumber" name="L211" href="#L211">211</a> }
<a class="jxr_linenumber" name="L212" href="#L212">212</a>
<a class="jxr_linenumber" name="L213" href="#L213">213</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">ResultSetColumnMetaData</a> {
<a class="jxr_linenumber" name="L214" href="#L214">214</a>
<a class="jxr_linenumber" name="L215" href="#L215">215</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String schemaName;
<a class="jxr_linenumber" name="L216" href="#L216">216</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String catalogName;
<a class="jxr_linenumber" name="L217" href="#L217">217</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String tableName;
<a class="jxr_linenumber" name="L218" href="#L218">218</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String name;
<a class="jxr_linenumber" name="L219" href="#L219">219</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String nameKey;
<a class="jxr_linenumber" name="L220" href="#L220">220</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String label;
<a class="jxr_linenumber" name="L221" href="#L221">221</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> displaySize;
<a class="jxr_linenumber" name="L222" href="#L222">222</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> type;
<a class="jxr_linenumber" name="L223" href="#L223">223</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String typeName;
<a class="jxr_linenumber" name="L224" href="#L224">224</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String className;
<a class="jxr_linenumber" name="L225" href="#L225">225</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> precision;
<a class="jxr_linenumber" name="L226" href="#L226">226</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> scale;
<a class="jxr_linenumber" name="L227" href="#L227">227</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> isStringType;
<a class="jxr_linenumber" name="L228" href="#L228">228</a>
<a class="jxr_linenumber" name="L229" href="#L229">229</a> <strong class="jxr_keyword">public</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">ResultSetColumnMetaData</a>(<strong class="jxr_keyword">final</strong> ResultSetMetaData rsMetaData, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> j) <strong class="jxr_keyword">throws</strong> SQLException {
<a class="jxr_linenumber" name="L230" href="#L230">230</a> <em class="jxr_comment">// @formatter:off</em>
<a class="jxr_linenumber" name="L231" href="#L231">231</a> <strong class="jxr_keyword">this</strong>(rsMetaData.getSchemaName(j),
<a class="jxr_linenumber" name="L232" href="#L232">232</a> rsMetaData.getCatalogName(j),
<a class="jxr_linenumber" name="L233" href="#L233">233</a> rsMetaData.getTableName(j),
<a class="jxr_linenumber" name="L234" href="#L234">234</a> rsMetaData.getColumnName(j),
<a class="jxr_linenumber" name="L235" href="#L235">235</a> rsMetaData.getColumnLabel(j),
<a class="jxr_linenumber" name="L236" href="#L236">236</a> rsMetaData.getColumnDisplaySize(j),
<a class="jxr_linenumber" name="L237" href="#L237">237</a> rsMetaData.getColumnType(j),
<a class="jxr_linenumber" name="L238" href="#L238">238</a> rsMetaData.getColumnTypeName(j),
<a class="jxr_linenumber" name="L239" href="#L239">239</a> rsMetaData.getColumnClassName(j),
<a class="jxr_linenumber" name="L240" href="#L240">240</a> rsMetaData.getPrecision(j),
<a class="jxr_linenumber" name="L241" href="#L241">241</a> rsMetaData.getScale(j));
<a class="jxr_linenumber" name="L242" href="#L242">242</a> <em class="jxr_comment">// @formatter:on</em>
<a class="jxr_linenumber" name="L243" href="#L243">243</a> }
<a class="jxr_linenumber" name="L244" href="#L244">244</a>
<a class="jxr_linenumber" name="L245" href="#L245">245</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">ResultSetColumnMetaData</a>(<strong class="jxr_keyword">final</strong> String schemaName, <strong class="jxr_keyword">final</strong> String catalogName, <strong class="jxr_keyword">final</strong> String tableName,
<a class="jxr_linenumber" name="L246" href="#L246">246</a> <strong class="jxr_keyword">final</strong> String name, <strong class="jxr_keyword">final</strong> String label, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> displaySize, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> type, <strong class="jxr_keyword">final</strong> String typeName,
<a class="jxr_linenumber" name="L247" href="#L247">247</a> <strong class="jxr_keyword">final</strong> String className, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> precision, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> scale) {
<a class="jxr_linenumber" name="L248" href="#L248">248</a> <strong class="jxr_keyword">super</strong>();
<a class="jxr_linenumber" name="L249" href="#L249">249</a> <strong class="jxr_keyword">this</strong>.schemaName = schemaName;
<a class="jxr_linenumber" name="L250" href="#L250">250</a> <strong class="jxr_keyword">this</strong>.catalogName = catalogName;
<a class="jxr_linenumber" name="L251" href="#L251">251</a> <strong class="jxr_keyword">this</strong>.tableName = tableName;
<a class="jxr_linenumber" name="L252" href="#L252">252</a> <strong class="jxr_keyword">this</strong>.name = name;
<a class="jxr_linenumber" name="L253" href="#L253">253</a> <strong class="jxr_keyword">this</strong>.nameKey = ColumnMapping.toKey(name);
<a class="jxr_linenumber" name="L254" href="#L254">254</a> <strong class="jxr_keyword">this</strong>.label = label;
<a class="jxr_linenumber" name="L255" href="#L255">255</a> <strong class="jxr_keyword">this</strong>.displaySize = displaySize;
<a class="jxr_linenumber" name="L256" href="#L256">256</a> <strong class="jxr_keyword">this</strong>.type = type;
<a class="jxr_linenumber" name="L257" href="#L257">257</a> <strong class="jxr_keyword">this</strong>.typeName = typeName;
<a class="jxr_linenumber" name="L258" href="#L258">258</a> <strong class="jxr_keyword">this</strong>.className = className;
<a class="jxr_linenumber" name="L259" href="#L259">259</a> <strong class="jxr_keyword">this</strong>.precision = precision;
<a class="jxr_linenumber" name="L260" href="#L260">260</a> <strong class="jxr_keyword">this</strong>.scale = scale;
<a class="jxr_linenumber" name="L261" href="#L261">261</a> <em class="jxr_comment">// TODO How about also using the className?</em>
<a class="jxr_linenumber" name="L262" href="#L262">262</a> <em class="jxr_comment">// @formatter:off</em>
<a class="jxr_linenumber" name="L263" href="#L263">263</a> <strong class="jxr_keyword">this</strong>.isStringType =
<a class="jxr_linenumber" name="L264" href="#L264">264</a> type == Types.CHAR ||
<a class="jxr_linenumber" name="L265" href="#L265">265</a> type == Types.LONGNVARCHAR ||
<a class="jxr_linenumber" name="L266" href="#L266">266</a> type == Types.LONGVARCHAR ||
<a class="jxr_linenumber" name="L267" href="#L267">267</a> type == Types.NVARCHAR ||
<a class="jxr_linenumber" name="L268" href="#L268">268</a> type == Types.VARCHAR;
<a class="jxr_linenumber" name="L269" href="#L269">269</a> <em class="jxr_comment">// @formatter:on</em>
<a class="jxr_linenumber" name="L270" href="#L270">270</a> }
<a class="jxr_linenumber" name="L271" href="#L271">271</a>
<a class="jxr_linenumber" name="L272" href="#L272">272</a> <strong class="jxr_keyword">public</strong> String getCatalogName() {
<a class="jxr_linenumber" name="L273" href="#L273">273</a> <strong class="jxr_keyword">return</strong> catalogName;
<a class="jxr_linenumber" name="L274" href="#L274">274</a> }
<a class="jxr_linenumber" name="L275" href="#L275">275</a>
<a class="jxr_linenumber" name="L276" href="#L276">276</a> <strong class="jxr_keyword">public</strong> String getClassName() {
<a class="jxr_linenumber" name="L277" href="#L277">277</a> <strong class="jxr_keyword">return</strong> className;
<a class="jxr_linenumber" name="L278" href="#L278">278</a> }
<a class="jxr_linenumber" name="L279" href="#L279">279</a>
<a class="jxr_linenumber" name="L280" href="#L280">280</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> getDisplaySize() {
<a class="jxr_linenumber" name="L281" href="#L281">281</a> <strong class="jxr_keyword">return</strong> displaySize;
<a class="jxr_linenumber" name="L282" href="#L282">282</a> }
<a class="jxr_linenumber" name="L283" href="#L283">283</a>
<a class="jxr_linenumber" name="L284" href="#L284">284</a> <strong class="jxr_keyword">public</strong> String getLabel() {
<a class="jxr_linenumber" name="L285" href="#L285">285</a> <strong class="jxr_keyword">return</strong> label;
<a class="jxr_linenumber" name="L286" href="#L286">286</a> }
<a class="jxr_linenumber" name="L287" href="#L287">287</a>
<a class="jxr_linenumber" name="L288" href="#L288">288</a> <strong class="jxr_keyword">public</strong> String getName() {
<a class="jxr_linenumber" name="L289" href="#L289">289</a> <strong class="jxr_keyword">return</strong> name;
<a class="jxr_linenumber" name="L290" href="#L290">290</a> }
<a class="jxr_linenumber" name="L291" href="#L291">291</a>
<a class="jxr_linenumber" name="L292" href="#L292">292</a> <strong class="jxr_keyword">public</strong> String getNameKey() {
<a class="jxr_linenumber" name="L293" href="#L293">293</a> <strong class="jxr_keyword">return</strong> nameKey;
<a class="jxr_linenumber" name="L294" href="#L294">294</a> }
<a class="jxr_linenumber" name="L295" href="#L295">295</a>
<a class="jxr_linenumber" name="L296" href="#L296">296</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> getPrecision() {
<a class="jxr_linenumber" name="L297" href="#L297">297</a> <strong class="jxr_keyword">return</strong> precision;
<a class="jxr_linenumber" name="L298" href="#L298">298</a> }
<a class="jxr_linenumber" name="L299" href="#L299">299</a>
<a class="jxr_linenumber" name="L300" href="#L300">300</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> getScale() {
<a class="jxr_linenumber" name="L301" href="#L301">301</a> <strong class="jxr_keyword">return</strong> scale;
<a class="jxr_linenumber" name="L302" href="#L302">302</a> }
<a class="jxr_linenumber" name="L303" href="#L303">303</a>
<a class="jxr_linenumber" name="L304" href="#L304">304</a> <strong class="jxr_keyword">public</strong> String getSchemaName() {
<a class="jxr_linenumber" name="L305" href="#L305">305</a> <strong class="jxr_keyword">return</strong> schemaName;
<a class="jxr_linenumber" name="L306" href="#L306">306</a> }
<a class="jxr_linenumber" name="L307" href="#L307">307</a>
<a class="jxr_linenumber" name="L308" href="#L308">308</a> <strong class="jxr_keyword">public</strong> String getTableName() {
<a class="jxr_linenumber" name="L309" href="#L309">309</a> <strong class="jxr_keyword">return</strong> tableName;
<a class="jxr_linenumber" name="L310" href="#L310">310</a> }
<a class="jxr_linenumber" name="L311" href="#L311">311</a>
<a class="jxr_linenumber" name="L312" href="#L312">312</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> getType() {
<a class="jxr_linenumber" name="L313" href="#L313">313</a> <strong class="jxr_keyword">return</strong> type;
<a class="jxr_linenumber" name="L314" href="#L314">314</a> }
<a class="jxr_linenumber" name="L315" href="#L315">315</a>
<a class="jxr_linenumber" name="L316" href="#L316">316</a> <strong class="jxr_keyword">public</strong> String getTypeName() {
<a class="jxr_linenumber" name="L317" href="#L317">317</a> <strong class="jxr_keyword">return</strong> typeName;
<a class="jxr_linenumber" name="L318" href="#L318">318</a> }
<a class="jxr_linenumber" name="L319" href="#L319">319</a>
<a class="jxr_linenumber" name="L320" href="#L320">320</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">boolean</strong> isStringType() {
<a class="jxr_linenumber" name="L321" href="#L321">321</a> <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">this</strong>.isStringType;
<a class="jxr_linenumber" name="L322" href="#L322">322</a> }
<a class="jxr_linenumber" name="L323" href="#L323">323</a>
<a class="jxr_linenumber" name="L324" href="#L324">324</a> @Override
<a class="jxr_linenumber" name="L325" href="#L325">325</a> <strong class="jxr_keyword">public</strong> String toString() {
<a class="jxr_linenumber" name="L326" href="#L326">326</a> <strong class="jxr_keyword">return</strong> String.format(
<a class="jxr_linenumber" name="L327" href="#L327">327</a> <span class="jxr_string">"ColumnMetaData [schemaName=%s, catalogName=%s, tableName=%s, name=%s, nameKey=%s, label=%s, displaySize=%s, type=%s, typeName=%s, className=%s, precision=%s, scale=%s, isStringType=%s]"</span>,
<a class="jxr_linenumber" name="L328" href="#L328">328</a> schemaName, catalogName, tableName, name, nameKey, label, displaySize, type, typeName, className,
<a class="jxr_linenumber" name="L329" href="#L329">329</a> precision, scale, isStringType);
<a class="jxr_linenumber" name="L330" href="#L330">330</a> }
<a class="jxr_linenumber" name="L331" href="#L331">331</a>
<a class="jxr_linenumber" name="L332" href="#L332">332</a> <strong class="jxr_keyword">public</strong> String truncate(<strong class="jxr_keyword">final</strong> String string) {
<a class="jxr_linenumber" name="L333" href="#L333">333</a> <strong class="jxr_keyword">return</strong> precision &gt; 0 ? Strings.left(string, precision) : string;
<a class="jxr_linenumber" name="L334" href="#L334">334</a> }
<a class="jxr_linenumber" name="L335" href="#L335">335</a> }
<a class="jxr_linenumber" name="L336" href="#L336">336</a>
<a class="jxr_linenumber" name="L337" href="#L337">337</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManagerFactory</a> INSTANCE = <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManagerFactory</a>();
<a class="jxr_linenumber" name="L338" href="#L338">338</a>
<a class="jxr_linenumber" name="L339" href="#L339">339</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">void</strong> appendColumnName(<strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> i, <strong class="jxr_keyword">final</strong> String columnName, <strong class="jxr_keyword">final</strong> StringBuilder sb) {
<a class="jxr_linenumber" name="L340" href="#L340">340</a> <strong class="jxr_keyword">if</strong> (i &gt; 1) {
<a class="jxr_linenumber" name="L341" href="#L341">341</a> sb.append(',');
<a class="jxr_linenumber" name="L342" href="#L342">342</a> }
<a class="jxr_linenumber" name="L343" href="#L343">343</a> sb.append(columnName);
<a class="jxr_linenumber" name="L344" href="#L344">344</a> }
<a class="jxr_linenumber" name="L345" href="#L345">345</a>
<a class="jxr_linenumber" name="L346" href="#L346">346</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L347" href="#L347">347</a> <em class="jxr_javadoccomment"> * Appends column names to the given buffer in the format {@code "A,B,C"}.</em>
<a class="jxr_linenumber" name="L348" href="#L348">348</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L349" href="#L349">349</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">void</strong> appendColumnNames(<strong class="jxr_keyword">final</strong> String sqlVerb, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a> data, <strong class="jxr_keyword">final</strong> StringBuilder sb) {
<a class="jxr_linenumber" name="L350" href="#L350">350</a> <em class="jxr_comment">// so this gets a little more complicated now that there are two ways to</em>
<a class="jxr_linenumber" name="L351" href="#L351">351</a> <em class="jxr_comment">// configure column mappings, but</em>
<a class="jxr_linenumber" name="L352" href="#L352">352</a> <em class="jxr_comment">// both mappings follow the same exact pattern for the prepared statement</em>
<a class="jxr_linenumber" name="L353" href="#L353">353</a> <strong class="jxr_keyword">int</strong> i = 1;
<a class="jxr_linenumber" name="L354" href="#L354">354</a> <strong class="jxr_keyword">final</strong> String messagePattern = <span class="jxr_string">"Appending {} {}[{}]: {}={} "</span>;
<a class="jxr_linenumber" name="L355" href="#L355">355</a> <strong class="jxr_keyword">if</strong> (data.columnMappings != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L356" href="#L356">356</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> ColumnMapping colMapping : data.columnMappings) {
<a class="jxr_linenumber" name="L357" href="#L357">357</a> <strong class="jxr_keyword">final</strong> String columnName = colMapping.getName();
<a class="jxr_linenumber" name="L358" href="#L358">358</a> appendColumnName(i, columnName, sb);
<a class="jxr_linenumber" name="L359" href="#L359">359</a> logger().trace(messagePattern, sqlVerb, colMapping.getClass().getSimpleName(), i, columnName,
<a class="jxr_linenumber" name="L360" href="#L360">360</a> colMapping);
<a class="jxr_linenumber" name="L361" href="#L361">361</a> i++;
<a class="jxr_linenumber" name="L362" href="#L362">362</a> }
<a class="jxr_linenumber" name="L363" href="#L363">363</a> <strong class="jxr_keyword">if</strong> (data.columnConfigs != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L364" href="#L364">364</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> ColumnConfig colConfig : data.columnConfigs) {
<a class="jxr_linenumber" name="L365" href="#L365">365</a> <strong class="jxr_keyword">final</strong> String columnName = colConfig.getColumnName();
<a class="jxr_linenumber" name="L366" href="#L366">366</a> appendColumnName(i, columnName, sb);
<a class="jxr_linenumber" name="L367" href="#L367">367</a> logger().trace(messagePattern, sqlVerb, colConfig.getClass().getSimpleName(), i, columnName,
<a class="jxr_linenumber" name="L368" href="#L368">368</a> colConfig);
<a class="jxr_linenumber" name="L369" href="#L369">369</a> i++;
<a class="jxr_linenumber" name="L370" href="#L370">370</a> }
<a class="jxr_linenumber" name="L371" href="#L371">371</a> }
<a class="jxr_linenumber" name="L372" href="#L372">372</a> }
<a class="jxr_linenumber" name="L373" href="#L373">373</a> }
<a class="jxr_linenumber" name="L374" href="#L374">374</a>
<a class="jxr_linenumber" name="L375" href="#L375">375</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManagerFactory</a> getFactory() {
<a class="jxr_linenumber" name="L376" href="#L376">376</a> <strong class="jxr_keyword">return</strong> INSTANCE;
<a class="jxr_linenumber" name="L377" href="#L377">377</a> }
<a class="jxr_linenumber" name="L378" href="#L378">378</a>
<a class="jxr_linenumber" name="L379" href="#L379">379</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L380" href="#L380">380</a> <em class="jxr_javadoccomment"> * Creates a JDBC manager for use within the {@link JdbcAppender}, or returns a suitable one if it already exists.</em>
<a class="jxr_linenumber" name="L381" href="#L381">381</a> <em class="jxr_javadoccomment"> *</em>
<a class="jxr_linenumber" name="L382" href="#L382">382</a> <em class="jxr_javadoccomment"> * @param name The name of the manager, which should include connection details and hashed passwords where possible.</em>
<a class="jxr_linenumber" name="L383" href="#L383">383</a> <em class="jxr_javadoccomment"> * @param bufferSize The size of the log event buffer.</em>
<a class="jxr_linenumber" name="L384" href="#L384">384</a> <em class="jxr_javadoccomment"> * @param connectionSource The source for connections to the database.</em>
<a class="jxr_linenumber" name="L385" href="#L385">385</a> <em class="jxr_javadoccomment"> * @param tableName The name of the database table to insert log events into.</em>
<a class="jxr_linenumber" name="L386" href="#L386">386</a> <em class="jxr_javadoccomment"> * @param columnConfigs Configuration information about the log table columns.</em>
<a class="jxr_linenumber" name="L387" href="#L387">387</a> <em class="jxr_javadoccomment"> * @return a new or existing JDBC manager as applicable.</em>
<a class="jxr_linenumber" name="L388" href="#L388">388</a> <em class="jxr_javadoccomment"> * @deprecated use</em>
<a class="jxr_linenumber" name="L389" href="#L389">389</a> <em class="jxr_javadoccomment"> * {@link #getManager(String, int, Layout, ConnectionSource, String, ColumnConfig[], ColumnMapping[], boolean, long)}</em>
<a class="jxr_linenumber" name="L390" href="#L390">390</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L391" href="#L391">391</a> @Deprecated
<a class="jxr_linenumber" name="L392" href="#L392">392</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManager</a> getJDBCDatabaseManager(<strong class="jxr_keyword">final</strong> String name, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> bufferSize,
<a class="jxr_linenumber" name="L393" href="#L393">393</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ConnectionSource.html">ConnectionSource</a> connectionSource, <strong class="jxr_keyword">final</strong> String tableName, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ColumnConfig.html">ColumnConfig</a>[] columnConfigs) {
<a class="jxr_linenumber" name="L394" href="#L394">394</a> <strong class="jxr_keyword">return</strong> getManager(
<a class="jxr_linenumber" name="L395" href="#L395">395</a> name, <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a>(bufferSize, <strong class="jxr_keyword">null</strong>, connectionSource, tableName, columnConfigs,
<a class="jxr_linenumber" name="L396" href="#L396">396</a> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/ColumnMapping.html">ColumnMapping</a>[0], false, AbstractDatabaseAppender.DEFAULT_RECONNECT_INTERVAL_MILLIS, <strong class="jxr_keyword">true</strong>),
<a class="jxr_linenumber" name="L397" href="#L397">397</a> getFactory());
<a class="jxr_linenumber" name="L398" href="#L398">398</a> }
<a class="jxr_linenumber" name="L399" href="#L399">399</a>
<a class="jxr_linenumber" name="L400" href="#L400">400</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L401" href="#L401">401</a> <em class="jxr_javadoccomment"> * Creates a JDBC manager for use within the {@link JdbcAppender}, or returns a suitable one if it already exists.</em>
<a class="jxr_linenumber" name="L402" href="#L402">402</a> <em class="jxr_javadoccomment"> *</em>
<a class="jxr_linenumber" name="L403" href="#L403">403</a> <em class="jxr_javadoccomment"> * @param name The name of the manager, which should include connection details and hashed passwords where possible.</em>
<a class="jxr_linenumber" name="L404" href="#L404">404</a> <em class="jxr_javadoccomment"> * @param bufferSize The size of the log event buffer.</em>
<a class="jxr_linenumber" name="L405" href="#L405">405</a> <em class="jxr_javadoccomment"> * @param layout The Appender-level layout</em>
<a class="jxr_linenumber" name="L406" href="#L406">406</a> <em class="jxr_javadoccomment"> * @param connectionSource The source for connections to the database.</em>
<a class="jxr_linenumber" name="L407" href="#L407">407</a> <em class="jxr_javadoccomment"> * @param tableName The name of the database table to insert log events into.</em>
<a class="jxr_linenumber" name="L408" href="#L408">408</a> <em class="jxr_javadoccomment"> * @param columnConfigs Configuration information about the log table columns.</em>
<a class="jxr_linenumber" name="L409" href="#L409">409</a> <em class="jxr_javadoccomment"> * @param columnMappings column mapping configuration (including type conversion).</em>
<a class="jxr_linenumber" name="L410" href="#L410">410</a> <em class="jxr_javadoccomment"> * @return a new or existing JDBC manager as applicable.</em>
<a class="jxr_linenumber" name="L411" href="#L411">411</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L412" href="#L412">412</a> @Deprecated
<a class="jxr_linenumber" name="L413" href="#L413">413</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManager</a> getManager(<strong class="jxr_keyword">final</strong> String name, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> bufferSize,
<a class="jxr_linenumber" name="L414" href="#L414">414</a> <strong class="jxr_keyword">final</strong> Layout&lt;? <strong class="jxr_keyword">extends</strong> Serializable&gt; layout, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ConnectionSource.html">ConnectionSource</a> connectionSource,
<a class="jxr_linenumber" name="L415" href="#L415">415</a> <strong class="jxr_keyword">final</strong> String tableName, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ColumnConfig.html">ColumnConfig</a>[] columnConfigs, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/ColumnMapping.html">ColumnMapping</a>[] columnMappings) {
<a class="jxr_linenumber" name="L416" href="#L416">416</a> <strong class="jxr_keyword">return</strong> getManager(name, <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a>(bufferSize, layout, connectionSource, tableName, columnConfigs,
<a class="jxr_linenumber" name="L417" href="#L417">417</a> columnMappings, false, AbstractDatabaseAppender.DEFAULT_RECONNECT_INTERVAL_MILLIS, <strong class="jxr_keyword">true</strong>), getFactory());
<a class="jxr_linenumber" name="L418" href="#L418">418</a> }
<a class="jxr_linenumber" name="L419" href="#L419">419</a>
<a class="jxr_linenumber" name="L420" href="#L420">420</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L421" href="#L421">421</a> <em class="jxr_javadoccomment"> * Creates a JDBC manager for use within the {@link JdbcAppender}, or returns a suitable one if it already exists.</em>
<a class="jxr_linenumber" name="L422" href="#L422">422</a> <em class="jxr_javadoccomment"> *</em>
<a class="jxr_linenumber" name="L423" href="#L423">423</a> <em class="jxr_javadoccomment"> * @param name The name of the manager, which should include connection details and hashed passwords where possible.</em>
<a class="jxr_linenumber" name="L424" href="#L424">424</a> <em class="jxr_javadoccomment"> * @param bufferSize The size of the log event buffer.</em>
<a class="jxr_linenumber" name="L425" href="#L425">425</a> <em class="jxr_javadoccomment"> * @param layout</em>
<a class="jxr_linenumber" name="L426" href="#L426">426</a> <em class="jxr_javadoccomment"> * @param connectionSource The source for connections to the database.</em>
<a class="jxr_linenumber" name="L427" href="#L427">427</a> <em class="jxr_javadoccomment"> * @param tableName The name of the database table to insert log events into.</em>
<a class="jxr_linenumber" name="L428" href="#L428">428</a> <em class="jxr_javadoccomment"> * @param columnConfigs Configuration information about the log table columns.</em>
<a class="jxr_linenumber" name="L429" href="#L429">429</a> <em class="jxr_javadoccomment"> * @param columnMappings column mapping configuration (including type conversion).</em>
<a class="jxr_linenumber" name="L430" href="#L430">430</a> <em class="jxr_javadoccomment"> * @param reconnectIntervalMillis</em>
<a class="jxr_linenumber" name="L431" href="#L431">431</a> <em class="jxr_javadoccomment"> * @param immediateFail</em>
<a class="jxr_linenumber" name="L432" href="#L432">432</a> <em class="jxr_javadoccomment"> * @return a new or existing JDBC manager as applicable.</em>
<a class="jxr_linenumber" name="L433" href="#L433">433</a> <em class="jxr_javadoccomment"> * @deprecated use</em>
<a class="jxr_linenumber" name="L434" href="#L434">434</a> <em class="jxr_javadoccomment"> * {@link #getManager(String, int, Layout, ConnectionSource, String, ColumnConfig[], ColumnMapping[], boolean, long)}</em>
<a class="jxr_linenumber" name="L435" href="#L435">435</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L436" href="#L436">436</a> @Deprecated
<a class="jxr_linenumber" name="L437" href="#L437">437</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManager</a> getManager(<strong class="jxr_keyword">final</strong> String name, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> bufferSize,
<a class="jxr_linenumber" name="L438" href="#L438">438</a> <strong class="jxr_keyword">final</strong> Layout&lt;? <strong class="jxr_keyword">extends</strong> Serializable&gt; layout, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ConnectionSource.html">ConnectionSource</a> connectionSource,
<a class="jxr_linenumber" name="L439" href="#L439">439</a> <strong class="jxr_keyword">final</strong> String tableName, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ColumnConfig.html">ColumnConfig</a>[] columnConfigs, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/ColumnMapping.html">ColumnMapping</a>[] columnMappings,
<a class="jxr_linenumber" name="L440" href="#L440">440</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> immediateFail, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">long</strong> reconnectIntervalMillis) {
<a class="jxr_linenumber" name="L441" href="#L441">441</a> <strong class="jxr_keyword">return</strong> getManager(name, <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a>(bufferSize, <strong class="jxr_keyword">null</strong>, connectionSource, tableName, columnConfigs,
<a class="jxr_linenumber" name="L442" href="#L442">442</a> columnMappings, false, AbstractDatabaseAppender.DEFAULT_RECONNECT_INTERVAL_MILLIS, <strong class="jxr_keyword">true</strong>), getFactory());
<a class="jxr_linenumber" name="L443" href="#L443">443</a> }
<a class="jxr_linenumber" name="L444" href="#L444">444</a>
<a class="jxr_linenumber" name="L445" href="#L445">445</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L446" href="#L446">446</a> <em class="jxr_javadoccomment"> * Creates a JDBC manager for use within the {@link JdbcAppender}, or returns a suitable one if it already exists.</em>
<a class="jxr_linenumber" name="L447" href="#L447">447</a> <em class="jxr_javadoccomment"> *</em>
<a class="jxr_linenumber" name="L448" href="#L448">448</a> <em class="jxr_javadoccomment"> * @param name The name of the manager, which should include connection details and hashed passwords where possible.</em>
<a class="jxr_linenumber" name="L449" href="#L449">449</a> <em class="jxr_javadoccomment"> * @param bufferSize The size of the log event buffer.</em>
<a class="jxr_linenumber" name="L450" href="#L450">450</a> <em class="jxr_javadoccomment"> * @param layout The Appender-level layout</em>
<a class="jxr_linenumber" name="L451" href="#L451">451</a> <em class="jxr_javadoccomment"> * @param connectionSource The source for connections to the database.</em>
<a class="jxr_linenumber" name="L452" href="#L452">452</a> <em class="jxr_javadoccomment"> * @param tableName The name of the database table to insert log events into.</em>
<a class="jxr_linenumber" name="L453" href="#L453">453</a> <em class="jxr_javadoccomment"> * @param columnConfigs Configuration information about the log table columns.</em>
<a class="jxr_linenumber" name="L454" href="#L454">454</a> <em class="jxr_javadoccomment"> * @param columnMappings column mapping configuration (including type conversion).</em>
<a class="jxr_linenumber" name="L455" href="#L455">455</a> <em class="jxr_javadoccomment"> * @param immediateFail Whether or not to fail immediately with a {@link AppenderLoggingException} when connecting</em>
<a class="jxr_linenumber" name="L456" href="#L456">456</a> <em class="jxr_javadoccomment"> * to JDBC fails.</em>
<a class="jxr_linenumber" name="L457" href="#L457">457</a> <em class="jxr_javadoccomment"> * @param reconnectIntervalMillis How often to reconnect to the database when a SQL exception is detected.</em>
<a class="jxr_linenumber" name="L458" href="#L458">458</a> <em class="jxr_javadoccomment"> * @param truncateStrings Whether or not to truncate strings to match column metadata.</em>
<a class="jxr_linenumber" name="L459" href="#L459">459</a> <em class="jxr_javadoccomment"> * @return a new or existing JDBC manager as applicable.</em>
<a class="jxr_linenumber" name="L460" href="#L460">460</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L461" href="#L461">461</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManager</a> getManager(<strong class="jxr_keyword">final</strong> String name, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> bufferSize,
<a class="jxr_linenumber" name="L462" href="#L462">462</a> <strong class="jxr_keyword">final</strong> Layout&lt;? <strong class="jxr_keyword">extends</strong> Serializable&gt; layout, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ConnectionSource.html">ConnectionSource</a> connectionSource,
<a class="jxr_linenumber" name="L463" href="#L463">463</a> <strong class="jxr_keyword">final</strong> String tableName, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ColumnConfig.html">ColumnConfig</a>[] columnConfigs, <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/ColumnMapping.html">ColumnMapping</a>[] columnMappings,
<a class="jxr_linenumber" name="L464" href="#L464">464</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> immediateFail, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">long</strong> reconnectIntervalMillis, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> truncateStrings) {
<a class="jxr_linenumber" name="L465" href="#L465">465</a> <strong class="jxr_keyword">return</strong> getManager(name, <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a>(bufferSize, layout, connectionSource, tableName, columnConfigs,
<a class="jxr_linenumber" name="L466" href="#L466">466</a> columnMappings, immediateFail, reconnectIntervalMillis, truncateStrings), getFactory());
<a class="jxr_linenumber" name="L467" href="#L467">467</a> }
<a class="jxr_linenumber" name="L468" href="#L468">468</a>
<a class="jxr_linenumber" name="L469" href="#L469">469</a> <em class="jxr_comment">// NOTE: prepared statements are prepared in this order: column mappings, then column configs</em>
<a class="jxr_linenumber" name="L470" href="#L470">470</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> List&lt;ColumnConfig&gt; columnConfigs;
<a class="jxr_linenumber" name="L471" href="#L471">471</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String sqlStatement;
<a class="jxr_linenumber" name="L472" href="#L472">472</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a> factoryData;
<a class="jxr_linenumber" name="L473" href="#L473">473</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">volatile</strong> Connection connection;
<a class="jxr_linenumber" name="L474" href="#L474">474</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">volatile</strong> PreparedStatement statement;
<a class="jxr_linenumber" name="L475" href="#L475">475</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">volatile</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">Reconnector</a> reconnector;
<a class="jxr_linenumber" name="L476" href="#L476">476</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">volatile</strong> <strong class="jxr_keyword">boolean</strong> isBatchSupported;
<a class="jxr_linenumber" name="L477" href="#L477">477</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">volatile</strong> Map&lt;String, ResultSetColumnMetaData&gt; columnMetaData;
<a class="jxr_linenumber" name="L478" href="#L478">478</a>
<a class="jxr_linenumber" name="L479" href="#L479">479</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">JdbcDatabaseManager</a>(<strong class="jxr_keyword">final</strong> String name, <strong class="jxr_keyword">final</strong> String sqlStatement, <strong class="jxr_keyword">final</strong> List&lt;ColumnConfig&gt; columnConfigs,
<a class="jxr_linenumber" name="L480" href="#L480">480</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/RandomAccessFileManager.html">FactoryData</a> factoryData) {
<a class="jxr_linenumber" name="L481" href="#L481">481</a> <strong class="jxr_keyword">super</strong>(name, factoryData.getBufferSize());
<a class="jxr_linenumber" name="L482" href="#L482">482</a> <strong class="jxr_keyword">this</strong>.sqlStatement = sqlStatement;
<a class="jxr_linenumber" name="L483" href="#L483">483</a> <strong class="jxr_keyword">this</strong>.columnConfigs = columnConfigs;
<a class="jxr_linenumber" name="L484" href="#L484">484</a> <strong class="jxr_keyword">this</strong>.factoryData = factoryData;
<a class="jxr_linenumber" name="L485" href="#L485">485</a> }
<a class="jxr_linenumber" name="L486" href="#L486">486</a>
<a class="jxr_linenumber" name="L487" href="#L487">487</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> checkConnection() {
<a class="jxr_linenumber" name="L488" href="#L488">488</a> <strong class="jxr_keyword">boolean</strong> connClosed = <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="L489" href="#L489">489</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L490" href="#L490">490</a> connClosed = isClosed(<strong class="jxr_keyword">this</strong>.connection);
<a class="jxr_linenumber" name="L491" href="#L491">491</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> SQLException e) {
<a class="jxr_linenumber" name="L492" href="#L492">492</a> <em class="jxr_comment">// Be quiet</em>
<a class="jxr_linenumber" name="L493" href="#L493">493</a> }
<a class="jxr_linenumber" name="L494" href="#L494">494</a> <strong class="jxr_keyword">boolean</strong> stmtClosed = <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="L495" href="#L495">495</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L496" href="#L496">496</a> stmtClosed = isClosed(<strong class="jxr_keyword">this</strong>.statement);
<a class="jxr_linenumber" name="L497" href="#L497">497</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> SQLException e) {
<a class="jxr_linenumber" name="L498" href="#L498">498</a> <em class="jxr_comment">// Be quiet</em>
<a class="jxr_linenumber" name="L499" href="#L499">499</a> }
<a class="jxr_linenumber" name="L500" href="#L500">500</a> <strong class="jxr_keyword">if</strong> (!<strong class="jxr_keyword">this</strong>.isRunning() || connClosed || stmtClosed) {
<a class="jxr_linenumber" name="L501" href="#L501">501</a> <em class="jxr_comment">// If anything is closed, close it all down before we reconnect</em>
<a class="jxr_linenumber" name="L502" href="#L502">502</a> closeResources(false);
<a class="jxr_linenumber" name="L503" href="#L503">503</a> <em class="jxr_comment">// Reconnect</em>
<a class="jxr_linenumber" name="L504" href="#L504">504</a> <strong class="jxr_keyword">if</strong> (reconnector != <strong class="jxr_keyword">null</strong> &amp;&amp; !factoryData.immediateFail) {
<a class="jxr_linenumber" name="L505" href="#L505">505</a> reconnector.latch();
<a class="jxr_linenumber" name="L506" href="#L506">506</a> <strong class="jxr_keyword">if</strong> (connection == <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L507" href="#L507">507</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/AppenderLoggingException.html">AppenderLoggingException</a>(
<a class="jxr_linenumber" name="L508" href="#L508">508</a> <span class="jxr_string">"Error writing to JDBC Manager '%s': JDBC connection not available [%s]"</span>, getName(), fieldsToString());
<a class="jxr_linenumber" name="L509" href="#L509">509</a> }
<a class="jxr_linenumber" name="L510" href="#L510">510</a> <strong class="jxr_keyword">if</strong> (statement == <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L511" href="#L511">511</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/AppenderLoggingException.html">AppenderLoggingException</a>(
<a class="jxr_linenumber" name="L512" href="#L512">512</a> <span class="jxr_string">"Error writing to JDBC Manager '%s': JDBC statement not available [%s]."</span>, getName(), connection, fieldsToString());
<a class="jxr_linenumber" name="L513" href="#L513">513</a> }
<a class="jxr_linenumber" name="L514" href="#L514">514</a> }
<a class="jxr_linenumber" name="L515" href="#L515">515</a> }
<a class="jxr_linenumber" name="L516" href="#L516">516</a> }
<a class="jxr_linenumber" name="L517" href="#L517">517</a>
<a class="jxr_linenumber" name="L518" href="#L518">518</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> closeResources(<strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> logExceptions) {
<a class="jxr_linenumber" name="L519" href="#L519">519</a> <strong class="jxr_keyword">final</strong> PreparedStatement tempPreparedStatement = <strong class="jxr_keyword">this</strong>.statement;
<a class="jxr_linenumber" name="L520" href="#L520">520</a> <strong class="jxr_keyword">this</strong>.statement = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="L521" href="#L521">521</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L522" href="#L522">522</a> <em class="jxr_comment">// Closing a statement returns it to the pool when using Apache Commons DBCP.</em>
<a class="jxr_linenumber" name="L523" href="#L523">523</a> <em class="jxr_comment">// Closing an already closed statement has no effect.</em>
<a class="jxr_linenumber" name="L524" href="#L524">524</a> Closer.close(tempPreparedStatement);
<a class="jxr_linenumber" name="L525" href="#L525">525</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> Exception e) {
<a class="jxr_linenumber" name="L526" href="#L526">526</a> <strong class="jxr_keyword">if</strong> (logExceptions) {
<a class="jxr_linenumber" name="L527" href="#L527">527</a> logWarn(<span class="jxr_string">"Failed to close SQL statement logging event or flushing buffer"</span>, e);
<a class="jxr_linenumber" name="L528" href="#L528">528</a> }
<a class="jxr_linenumber" name="L529" href="#L529">529</a> }
<a class="jxr_linenumber" name="L530" href="#L530">530</a>
<a class="jxr_linenumber" name="L531" href="#L531">531</a> <strong class="jxr_keyword">final</strong> Connection tempConnection = <strong class="jxr_keyword">this</strong>.connection;
<a class="jxr_linenumber" name="L532" href="#L532">532</a> <strong class="jxr_keyword">this</strong>.connection = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="L533" href="#L533">533</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L534" href="#L534">534</a> <em class="jxr_comment">// Closing a connection returns it to the pool when using Apache Commons DBCP.</em>
<a class="jxr_linenumber" name="L535" href="#L535">535</a> <em class="jxr_comment">// Closing an already closed connection has no effect.</em>
<a class="jxr_linenumber" name="L536" href="#L536">536</a> Closer.close(tempConnection);
<a class="jxr_linenumber" name="L537" href="#L537">537</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> Exception e) {
<a class="jxr_linenumber" name="L538" href="#L538">538</a> <strong class="jxr_keyword">if</strong> (logExceptions) {
<a class="jxr_linenumber" name="L539" href="#L539">539</a> logWarn(<span class="jxr_string">"Failed to close database connection logging event or flushing buffer"</span>, e);
<a class="jxr_linenumber" name="L540" href="#L540">540</a> }
<a class="jxr_linenumber" name="L541" href="#L541">541</a> }
<a class="jxr_linenumber" name="L542" href="#L542">542</a> }
<a class="jxr_linenumber" name="L543" href="#L543">543</a>
<a class="jxr_linenumber" name="L544" href="#L544">544</a> @Override
<a class="jxr_linenumber" name="L545" href="#L545">545</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">boolean</strong> commitAndClose() {
<a class="jxr_linenumber" name="L546" href="#L546">546</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> closed = <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="L547" href="#L547">547</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L548" href="#L548">548</a> <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.connection != <strong class="jxr_keyword">null</strong> &amp;&amp; !<strong class="jxr_keyword">this</strong>.connection.isClosed()) {
<a class="jxr_linenumber" name="L549" href="#L549">549</a> <strong class="jxr_keyword">if</strong> (isBuffered() &amp;&amp; <strong class="jxr_keyword">this</strong>.isBatchSupported &amp;&amp; <strong class="jxr_keyword">this</strong>.statement != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L550" href="#L550">550</a> logger().debug(<span class="jxr_string">"Executing batch PreparedStatement {}"</span>, <strong class="jxr_keyword">this</strong>.statement);
<a class="jxr_linenumber" name="L551" href="#L551">551</a> <strong class="jxr_keyword">int</strong>[] result;
<a class="jxr_linenumber" name="L552" href="#L552">552</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L553" href="#L553">553</a> result = <strong class="jxr_keyword">this</strong>.statement.executeBatch();
<a class="jxr_linenumber" name="L554" href="#L554">554</a> } <strong class="jxr_keyword">catch</strong> (SQLTransactionRollbackException e) {
<a class="jxr_linenumber" name="L555" href="#L555">555</a> logger().debug(<span class="jxr_string">"{} executing batch PreparedStatement {}, retrying."</span>, e, <strong class="jxr_keyword">this</strong>.statement);
<a class="jxr_linenumber" name="L556" href="#L556">556</a> result = <strong class="jxr_keyword">this</strong>.statement.executeBatch();
<a class="jxr_linenumber" name="L557" href="#L557">557</a> }
<a class="jxr_linenumber" name="L558" href="#L558">558</a> logger().debug(<span class="jxr_string">"Batch result: {}"</span>, Arrays.toString(result));
<a class="jxr_linenumber" name="L559" href="#L559">559</a> }
<a class="jxr_linenumber" name="L560" href="#L560">560</a> logger().debug(<span class="jxr_string">"Committing Connection {}"</span>, <strong class="jxr_keyword">this</strong>.connection);
<a class="jxr_linenumber" name="L561" href="#L561">561</a> <strong class="jxr_keyword">this</strong>.connection.commit();
<a class="jxr_linenumber" name="L562" href="#L562">562</a> }
<a class="jxr_linenumber" name="L563" href="#L563">563</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> SQLException e) {
<a class="jxr_linenumber" name="L564" href="#L564">564</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/DbAppenderLoggingException.html">DbAppenderLoggingException</a>(e, <span class="jxr_string">"Failed to commit transaction logging event or flushing buffer [%s]"</span>,
<a class="jxr_linenumber" name="L565" href="#L565">565</a> fieldsToString());
<a class="jxr_linenumber" name="L566" href="#L566">566</a> } <strong class="jxr_keyword">finally</strong> {
<a class="jxr_linenumber" name="L567" href="#L567">567</a> closeResources(<strong class="jxr_keyword">true</strong>);
<a class="jxr_linenumber" name="L568" href="#L568">568</a> }
<a class="jxr_linenumber" name="L569" href="#L569">569</a> <strong class="jxr_keyword">return</strong> closed;
<a class="jxr_linenumber" name="L570" href="#L570">570</a> }
<a class="jxr_linenumber" name="L571" href="#L571">571</a>
<a class="jxr_linenumber" name="L572" href="#L572">572</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">boolean</strong> commitAndCloseAll() {
<a class="jxr_linenumber" name="L573" href="#L573">573</a> <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.connection != <strong class="jxr_keyword">null</strong> || <strong class="jxr_keyword">this</strong>.statement != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L574" href="#L574">574</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L575" href="#L575">575</a> <strong class="jxr_keyword">this</strong>.commitAndClose();
<a class="jxr_linenumber" name="L576" href="#L576">576</a> <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="L577" href="#L577">577</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> AppenderLoggingException e) {
<a class="jxr_linenumber" name="L578" href="#L578">578</a> <em class="jxr_comment">// Database connection has likely gone stale.</em>
<a class="jxr_linenumber" name="L579" href="#L579">579</a> <strong class="jxr_keyword">final</strong> Throwable cause = e.getCause();
<a class="jxr_linenumber" name="L580" href="#L580">580</a> <strong class="jxr_keyword">final</strong> Throwable actual = cause == <strong class="jxr_keyword">null</strong> ? e : cause;
<a class="jxr_linenumber" name="L581" href="#L581">581</a> logger().debug(<span class="jxr_string">"{} committing and closing connection: {}"</span>, actual, actual.getClass().getSimpleName(),
<a class="jxr_linenumber" name="L582" href="#L582">582</a> e.toString(), e);
<a class="jxr_linenumber" name="L583" href="#L583">583</a> }
<a class="jxr_linenumber" name="L584" href="#L584">584</a> }
<a class="jxr_linenumber" name="L585" href="#L585">585</a> <strong class="jxr_keyword">if</strong> (factoryData.connectionSource != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L586" href="#L586">586</a> factoryData.connectionSource.stop();
<a class="jxr_linenumber" name="L587" href="#L587">587</a> }
<a class="jxr_linenumber" name="L588" href="#L588">588</a> <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="L589" href="#L589">589</a> }
<a class="jxr_linenumber" name="L590" href="#L590">590</a>
<a class="jxr_linenumber" name="L591" href="#L591">591</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> connectAndPrepare() <strong class="jxr_keyword">throws</strong> SQLException {
<a class="jxr_linenumber" name="L592" href="#L592">592</a> logger().debug(<span class="jxr_string">"Acquiring JDBC connection from {}"</span>, <strong class="jxr_keyword">this</strong>.getConnectionSource());
<a class="jxr_linenumber" name="L593" href="#L593">593</a> <strong class="jxr_keyword">this</strong>.connection = getConnectionSource().getConnection();
<a class="jxr_linenumber" name="L594" href="#L594">594</a> logger().debug(<span class="jxr_string">"Acquired JDBC connection {}"</span>, <strong class="jxr_keyword">this</strong>.connection);
<a class="jxr_linenumber" name="L595" href="#L595">595</a> logger().debug(<span class="jxr_string">"Getting connection metadata {}"</span>, <strong class="jxr_keyword">this</strong>.connection);
<a class="jxr_linenumber" name="L596" href="#L596">596</a> <strong class="jxr_keyword">final</strong> DatabaseMetaData databaseMetaData = <strong class="jxr_keyword">this</strong>.connection.getMetaData();
<a class="jxr_linenumber" name="L597" href="#L597">597</a> logger().debug(<span class="jxr_string">"Connection metadata {}"</span>, databaseMetaData);
<a class="jxr_linenumber" name="L598" href="#L598">598</a> <strong class="jxr_keyword">this</strong>.isBatchSupported = databaseMetaData.supportsBatchUpdates();
<a class="jxr_linenumber" name="L599" href="#L599">599</a> logger().debug(<span class="jxr_string">"Connection supportsBatchUpdates: {}"</span>, <strong class="jxr_keyword">this</strong>.isBatchSupported);
<a class="jxr_linenumber" name="L600" href="#L600">600</a> <strong class="jxr_keyword">this</strong>.connection.setAutoCommit(false);
<a class="jxr_linenumber" name="L601" href="#L601">601</a> logger().debug(<span class="jxr_string">"Preparing SQL {}"</span>, <strong class="jxr_keyword">this</strong>.sqlStatement);
<a class="jxr_linenumber" name="L602" href="#L602">602</a> <strong class="jxr_keyword">this</strong>.statement = <strong class="jxr_keyword">this</strong>.connection.prepareStatement(<strong class="jxr_keyword">this</strong>.sqlStatement);
<a class="jxr_linenumber" name="L603" href="#L603">603</a> logger().debug(<span class="jxr_string">"Prepared SQL {}"</span>, <strong class="jxr_keyword">this</strong>.statement);
<a class="jxr_linenumber" name="L604" href="#L604">604</a> <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.factoryData.truncateStrings) {
<a class="jxr_linenumber" name="L605" href="#L605">605</a> initColumnMetaData();
<a class="jxr_linenumber" name="L606" href="#L606">606</a> }
<a class="jxr_linenumber" name="L607" href="#L607">607</a> }
<a class="jxr_linenumber" name="L608" href="#L608">608</a>
<a class="jxr_linenumber" name="L609" href="#L609">609</a> @Override
<a class="jxr_linenumber" name="L610" href="#L610">610</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> connectAndStart() {
<a class="jxr_linenumber" name="L611" href="#L611">611</a> checkConnection();
<a class="jxr_linenumber" name="L612" href="#L612">612</a> <strong class="jxr_keyword">synchronized</strong> (<strong class="jxr_keyword">this</strong>) {
<a class="jxr_linenumber" name="L613" href="#L613">613</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L614" href="#L614">614</a> connectAndPrepare();
<a class="jxr_linenumber" name="L615" href="#L615">615</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> SQLException e) {
<a class="jxr_linenumber" name="L616" href="#L616">616</a> reconnectOn(e);
<a class="jxr_linenumber" name="L617" href="#L617">617</a> }
<a class="jxr_linenumber" name="L618" href="#L618">618</a> }
<a class="jxr_linenumber" name="L619" href="#L619">619</a> }
<a class="jxr_linenumber" name="L620" href="#L620">620</a>
<a class="jxr_linenumber" name="L621" href="#L621">621</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">Reconnector</a> createReconnector() {
<a class="jxr_linenumber" name="L622" href="#L622">622</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">Reconnector</a> recon = <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">Reconnector</a>();
<a class="jxr_linenumber" name="L623" href="#L623">623</a> recon.setDaemon(<strong class="jxr_keyword">true</strong>);
<a class="jxr_linenumber" name="L624" href="#L624">624</a> recon.setPriority(Thread.MIN_PRIORITY);
<a class="jxr_linenumber" name="L625" href="#L625">625</a> <strong class="jxr_keyword">return</strong> recon;
<a class="jxr_linenumber" name="L626" href="#L626">626</a> }
<a class="jxr_linenumber" name="L627" href="#L627">627</a>
<a class="jxr_linenumber" name="L628" href="#L628">628</a> <strong class="jxr_keyword">private</strong> String createSqlSelect() {
<a class="jxr_linenumber" name="L629" href="#L629">629</a> <strong class="jxr_keyword">final</strong> StringBuilder sb = <strong class="jxr_keyword">new</strong> StringBuilder(<span class="jxr_string">"select "</span>);
<a class="jxr_linenumber" name="L630" href="#L630">630</a> appendColumnNames(<span class="jxr_string">"SELECT"</span>, <strong class="jxr_keyword">this</strong>.factoryData, sb);
<a class="jxr_linenumber" name="L631" href="#L631">631</a> sb.append(<span class="jxr_string">" from "</span>);
<a class="jxr_linenumber" name="L632" href="#L632">632</a> sb.append(<strong class="jxr_keyword">this</strong>.factoryData.tableName);
<a class="jxr_linenumber" name="L633" href="#L633">633</a> sb.append(<span class="jxr_string">" where 1=0"</span>);
<a class="jxr_linenumber" name="L634" href="#L634">634</a> <strong class="jxr_keyword">return</strong> sb.toString();
<a class="jxr_linenumber" name="L635" href="#L635">635</a> }
<a class="jxr_linenumber" name="L636" href="#L636">636</a>
<a class="jxr_linenumber" name="L637" href="#L637">637</a> <strong class="jxr_keyword">private</strong> String fieldsToString() {
<a class="jxr_linenumber" name="L638" href="#L638">638</a> <strong class="jxr_keyword">return</strong> String.format(
<a class="jxr_linenumber" name="L639" href="#L639">639</a> <span class="jxr_string">"columnConfigs=%s, sqlStatement=%s, factoryData=%s, connection=%s, statement=%s, reconnector=%s, isBatchSupported=%s, columnMetaData=%s"</span>,
<a class="jxr_linenumber" name="L640" href="#L640">640</a> columnConfigs, sqlStatement, factoryData, connection, statement, reconnector, isBatchSupported,
<a class="jxr_linenumber" name="L641" href="#L641">641</a> columnMetaData);
<a class="jxr_linenumber" name="L642" href="#L642">642</a> }
<a class="jxr_linenumber" name="L643" href="#L643">643</a>
<a class="jxr_linenumber" name="L644" href="#L644">644</a> <strong class="jxr_keyword">public</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/ConnectionSource.html">ConnectionSource</a> getConnectionSource() {
<a class="jxr_linenumber" name="L645" href="#L645">645</a> <strong class="jxr_keyword">return</strong> factoryData.connectionSource;
<a class="jxr_linenumber" name="L646" href="#L646">646</a> }
<a class="jxr_linenumber" name="L647" href="#L647">647</a>
<a class="jxr_linenumber" name="L648" href="#L648">648</a> <strong class="jxr_keyword">public</strong> String getSqlStatement() {
<a class="jxr_linenumber" name="L649" href="#L649">649</a> <strong class="jxr_keyword">return</strong> sqlStatement;
<a class="jxr_linenumber" name="L650" href="#L650">650</a> }
<a class="jxr_linenumber" name="L651" href="#L651">651</a>
<a class="jxr_linenumber" name="L652" href="#L652">652</a> <strong class="jxr_keyword">public</strong> String getTableName() {
<a class="jxr_linenumber" name="L653" href="#L653">653</a> <strong class="jxr_keyword">return</strong> factoryData.tableName;
<a class="jxr_linenumber" name="L654" href="#L654">654</a> }
<a class="jxr_linenumber" name="L655" href="#L655">655</a>
<a class="jxr_linenumber" name="L656" href="#L656">656</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> initColumnMetaData() <strong class="jxr_keyword">throws</strong> SQLException {
<a class="jxr_linenumber" name="L657" href="#L657">657</a> <em class="jxr_comment">// Could use:</em>
<a class="jxr_linenumber" name="L658" href="#L658">658</a> <em class="jxr_comment">// this.connection.getMetaData().getColumns(catalog, schemaPattern, tableNamePattern, columnNamePattern);</em>
<a class="jxr_linenumber" name="L659" href="#L659">659</a> <em class="jxr_comment">// But this returns more data than we need for now, so do a SQL SELECT with 0 result rows instead.</em>
<a class="jxr_linenumber" name="L660" href="#L660">660</a> <strong class="jxr_keyword">final</strong> String sqlSelect = createSqlSelect();
<a class="jxr_linenumber" name="L661" href="#L661">661</a> logger().debug(<span class="jxr_string">"Getting SQL metadata for table {}: {}"</span>, <strong class="jxr_keyword">this</strong>.factoryData.tableName, sqlSelect);
<a class="jxr_linenumber" name="L662" href="#L662">662</a> <strong class="jxr_keyword">try</strong> (<strong class="jxr_keyword">final</strong> PreparedStatement mdStatement = <strong class="jxr_keyword">this</strong>.connection.prepareStatement(sqlSelect)) {
<a class="jxr_linenumber" name="L663" href="#L663">663</a> <strong class="jxr_keyword">final</strong> ResultSetMetaData rsMetaData = mdStatement.getMetaData();
<a class="jxr_linenumber" name="L664" href="#L664">664</a> logger().debug(<span class="jxr_string">"SQL metadata: {}"</span>, rsMetaData);
<a class="jxr_linenumber" name="L665" href="#L665">665</a> <strong class="jxr_keyword">if</strong> (rsMetaData != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L666" href="#L666">666</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> columnCount = rsMetaData.getColumnCount();
<a class="jxr_linenumber" name="L667" href="#L667">667</a> columnMetaData = <strong class="jxr_keyword">new</strong> HashMap&lt;&gt;(columnCount);
<a class="jxr_linenumber" name="L668" href="#L668">668</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0, j = 1; i &lt; columnCount; i++, j++) {
<a class="jxr_linenumber" name="L669" href="#L669">669</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">ResultSetColumnMetaData</a> value = <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">ResultSetColumnMetaData</a>(rsMetaData, j);
<a class="jxr_linenumber" name="L670" href="#L670">670</a> columnMetaData.put(value.getNameKey(), value);
<a class="jxr_linenumber" name="L671" href="#L671">671</a> }
<a class="jxr_linenumber" name="L672" href="#L672">672</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L673" href="#L673">673</a> logger().warn(
<a class="jxr_linenumber" name="L674" href="#L674">674</a> <span class="jxr_string">"{}: truncateStrings is true and ResultSetMetaData is null for statement: {}; manager will not perform truncation."</span>,
<a class="jxr_linenumber" name="L675" href="#L675">675</a> getClass().getSimpleName(), mdStatement);
<a class="jxr_linenumber" name="L676" href="#L676">676</a> }
<a class="jxr_linenumber" name="L677" href="#L677">677</a> }
<a class="jxr_linenumber" name="L678" href="#L678">678</a> }
<a class="jxr_linenumber" name="L679" href="#L679">679</a>
<a class="jxr_linenumber" name="L680" href="#L680">680</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L681" href="#L681">681</a> <em class="jxr_javadoccomment"> * Checks if a statement is closed. A null statement is considered closed.</em>
<a class="jxr_linenumber" name="L682" href="#L682">682</a> <em class="jxr_javadoccomment"> *</em>
<a class="jxr_linenumber" name="L683" href="#L683">683</a> <em class="jxr_javadoccomment"> * @param statement The statement to check.</em>
<a class="jxr_linenumber" name="L684" href="#L684">684</a> <em class="jxr_javadoccomment"> * @return true if a statement is closed, false if null.</em>
<a class="jxr_linenumber" name="L685" href="#L685">685</a> <em class="jxr_javadoccomment"> * @throws SQLException if a database access error occurs</em>
<a class="jxr_linenumber" name="L686" href="#L686">686</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L687" href="#L687">687</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">boolean</strong> isClosed(<strong class="jxr_keyword">final</strong> Statement statement) <strong class="jxr_keyword">throws</strong> SQLException {
<a class="jxr_linenumber" name="L688" href="#L688">688</a> <strong class="jxr_keyword">return</strong> statement == <strong class="jxr_keyword">null</strong> || statement.isClosed();
<a class="jxr_linenumber" name="L689" href="#L689">689</a> }
<a class="jxr_linenumber" name="L690" href="#L690">690</a>
<a class="jxr_linenumber" name="L691" href="#L691">691</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L692" href="#L692">692</a> <em class="jxr_javadoccomment"> * Checks if a connection is closed. A null connection is considered closed.</em>
<a class="jxr_linenumber" name="L693" href="#L693">693</a> <em class="jxr_javadoccomment"> *</em>
<a class="jxr_linenumber" name="L694" href="#L694">694</a> <em class="jxr_javadoccomment"> * @param connection The connection to check.</em>
<a class="jxr_linenumber" name="L695" href="#L695">695</a> <em class="jxr_javadoccomment"> * @return true if a connection is closed, false if null.</em>
<a class="jxr_linenumber" name="L696" href="#L696">696</a> <em class="jxr_javadoccomment"> * @throws SQLException if a database access error occurs</em>
<a class="jxr_linenumber" name="L697" href="#L697">697</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L698" href="#L698">698</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">boolean</strong> isClosed(<strong class="jxr_keyword">final</strong> Connection connection) <strong class="jxr_keyword">throws</strong> SQLException {
<a class="jxr_linenumber" name="L699" href="#L699">699</a> <strong class="jxr_keyword">return</strong> connection == <strong class="jxr_keyword">null</strong> || connection.isClosed();
<a class="jxr_linenumber" name="L700" href="#L700">700</a> }
<a class="jxr_linenumber" name="L701" href="#L701">701</a>
<a class="jxr_linenumber" name="L702" href="#L702">702</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> reconnectOn(<strong class="jxr_keyword">final</strong> Exception exception) {
<a class="jxr_linenumber" name="L703" href="#L703">703</a> <strong class="jxr_keyword">if</strong> (!factoryData.retry) {
<a class="jxr_linenumber" name="L704" href="#L704">704</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/AppenderLoggingException.html">AppenderLoggingException</a>(<span class="jxr_string">"Cannot connect and prepare"</span>, exception);
<a class="jxr_linenumber" name="L705" href="#L705">705</a> }
<a class="jxr_linenumber" name="L706" href="#L706">706</a> <strong class="jxr_keyword">if</strong> (reconnector == <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L707" href="#L707">707</a> reconnector = createReconnector();
<a class="jxr_linenumber" name="L708" href="#L708">708</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L709" href="#L709">709</a> reconnector.reconnect();
<a class="jxr_linenumber" name="L710" href="#L710">710</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> SQLException reconnectEx) {
<a class="jxr_linenumber" name="L711" href="#L711">711</a> logger().debug(<span class="jxr_string">"Cannot reestablish JDBC connection to {}: {}; starting reconnector thread {}"</span>,
<a class="jxr_linenumber" name="L712" href="#L712">712</a> factoryData, reconnectEx, reconnector.getName(), reconnectEx);
<a class="jxr_linenumber" name="L713" href="#L713">713</a> reconnector.start();
<a class="jxr_linenumber" name="L714" href="#L714">714</a> reconnector.latch();
<a class="jxr_linenumber" name="L715" href="#L715">715</a> <strong class="jxr_keyword">if</strong> (connection == <strong class="jxr_keyword">null</strong> || statement == <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L716" href="#L716">716</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/AppenderLoggingException.html">AppenderLoggingException</a>(exception, <span class="jxr_string">"Error sending to %s for %s [%s]"</span>, getName(),
<a class="jxr_linenumber" name="L717" href="#L717">717</a> factoryData, fieldsToString());
<a class="jxr_linenumber" name="L718" href="#L718">718</a> }
<a class="jxr_linenumber" name="L719" href="#L719">719</a> }
<a class="jxr_linenumber" name="L720" href="#L720">720</a> }
<a class="jxr_linenumber" name="L721" href="#L721">721</a> }
<a class="jxr_linenumber" name="L722" href="#L722">722</a>
<a class="jxr_linenumber" name="L723" href="#L723">723</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> setFields(<strong class="jxr_keyword">final</strong> MapMessage&lt;?, ?&gt; mapMessage) <strong class="jxr_keyword">throws</strong> SQLException {
<a class="jxr_linenumber" name="L724" href="#L724">724</a> <strong class="jxr_keyword">final</strong> IndexedReadOnlyStringMap map = mapMessage.getIndexedReadOnlyStringMap();
<a class="jxr_linenumber" name="L725" href="#L725">725</a> <strong class="jxr_keyword">final</strong> String simpleName = statement.getClass().getName();
<a class="jxr_linenumber" name="L726" href="#L726">726</a> <strong class="jxr_keyword">int</strong> j = 1; <em class="jxr_comment">// JDBC indices start at 1</em>
<a class="jxr_linenumber" name="L727" href="#L727">727</a> <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.factoryData.columnMappings != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L728" href="#L728">728</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> ColumnMapping mapping : <strong class="jxr_keyword">this</strong>.factoryData.columnMappings) {
<a class="jxr_linenumber" name="L729" href="#L729">729</a> <strong class="jxr_keyword">if</strong> (mapping.getLiteralValue() == <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L730" href="#L730">730</a> <strong class="jxr_keyword">final</strong> String source = mapping.getSource();
<a class="jxr_linenumber" name="L731" href="#L731">731</a> <strong class="jxr_keyword">final</strong> String key = Strings.isEmpty(source) ? mapping.getName() : source;
<a class="jxr_linenumber" name="L732" href="#L732">732</a> <strong class="jxr_keyword">final</strong> Object value = map.getValue(key);
<a class="jxr_linenumber" name="L733" href="#L733">733</a> <strong class="jxr_keyword">if</strong> (logger().isTraceEnabled()) {
<a class="jxr_linenumber" name="L734" href="#L734">734</a> <strong class="jxr_keyword">final</strong> String valueStr = value instanceof String ? <span class="jxr_string">"\&quot;"</span> + value + <span class="jxr_string">"\&quot;"</span>
<a class="jxr_linenumber" name="L735" href="#L735">735</a> : Objects.toString(value, <strong class="jxr_keyword">null</strong>);
<a class="jxr_linenumber" name="L736" href="#L736">736</a> logger().trace(<span class="jxr_string">"{} setObject({}, {}) for key '{}' and mapping '{}'"</span>, simpleName, j, valueStr,
<a class="jxr_linenumber" name="L737" href="#L737">737</a> key, mapping.getName());
<a class="jxr_linenumber" name="L738" href="#L738">738</a> }
<a class="jxr_linenumber" name="L739" href="#L739">739</a> setStatementObject(j, mapping.getNameKey(), value);
<a class="jxr_linenumber" name="L740" href="#L740">740</a> j++;
<a class="jxr_linenumber" name="L741" href="#L741">741</a> }
<a class="jxr_linenumber" name="L742" href="#L742">742</a> }
<a class="jxr_linenumber" name="L743" href="#L743">743</a> }
<a class="jxr_linenumber" name="L744" href="#L744">744</a> }
<a class="jxr_linenumber" name="L745" href="#L745">745</a>
<a class="jxr_linenumber" name="L746" href="#L746">746</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L747" href="#L747">747</a> <em class="jxr_javadoccomment"> * Sets the given Object in the prepared statement. The value is truncated if needed.</em>
<a class="jxr_linenumber" name="L748" href="#L748">748</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L749" href="#L749">749</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> setStatementObject(<strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> j, <strong class="jxr_keyword">final</strong> String nameKey, <strong class="jxr_keyword">final</strong> Object value) <strong class="jxr_keyword">throws</strong> SQLException {
<a class="jxr_linenumber" name="L750" href="#L750">750</a> <strong class="jxr_keyword">if</strong> (value == <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L751" href="#L751">751</a> <em class="jxr_comment">// [LOG4J2-2762] [JDBC] MS-SQL Server JDBC driver throws SQLServerException when inserting a null value for a VARBINARY column.</em>
<a class="jxr_linenumber" name="L752" href="#L752">752</a> <em class="jxr_comment">// Calling setNull() instead of setObject() for null values fixes [LOG4J2-2762]. </em>
<a class="jxr_linenumber" name="L753" href="#L753">753</a> <strong class="jxr_keyword">this</strong>.statement.setNull(j, columnMetaData.get(nameKey).getType());
<a class="jxr_linenumber" name="L754" href="#L754">754</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L755" href="#L755">755</a> statement.setObject(j, truncate(nameKey, value));
<a class="jxr_linenumber" name="L756" href="#L756">756</a> }
<a class="jxr_linenumber" name="L757" href="#L757">757</a> }
<a class="jxr_linenumber" name="L758" href="#L758">758</a>
<a class="jxr_linenumber" name="L759" href="#L759">759</a> @Override
<a class="jxr_linenumber" name="L760" href="#L760">760</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">boolean</strong> shutdownInternal() {
<a class="jxr_linenumber" name="L761" href="#L761">761</a> <strong class="jxr_keyword">if</strong> (reconnector != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L762" href="#L762">762</a> reconnector.shutdown();
<a class="jxr_linenumber" name="L763" href="#L763">763</a> reconnector.interrupt();
<a class="jxr_linenumber" name="L764" href="#L764">764</a> reconnector = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="L765" href="#L765">765</a> }
<a class="jxr_linenumber" name="L766" href="#L766">766</a> <strong class="jxr_keyword">return</strong> commitAndCloseAll();
<a class="jxr_linenumber" name="L767" href="#L767">767</a> }
<a class="jxr_linenumber" name="L768" href="#L768">768</a>
<a class="jxr_linenumber" name="L769" href="#L769">769</a> @Override
<a class="jxr_linenumber" name="L770" href="#L770">770</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> startupInternal() <strong class="jxr_keyword">throws</strong> Exception {
<a class="jxr_linenumber" name="L771" href="#L771">771</a> <em class="jxr_comment">// empty</em>
<a class="jxr_linenumber" name="L772" href="#L772">772</a> }
<a class="jxr_linenumber" name="L773" href="#L773">773</a>
<a class="jxr_linenumber" name="L774" href="#L774">774</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L775" href="#L775">775</a> <em class="jxr_javadoccomment"> * Truncates the value if needed.</em>
<a class="jxr_linenumber" name="L776" href="#L776">776</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L777" href="#L777">777</a> <strong class="jxr_keyword">private</strong> Object truncate(<strong class="jxr_keyword">final</strong> String nameKey, Object value) {
<a class="jxr_linenumber" name="L778" href="#L778">778</a> <strong class="jxr_keyword">if</strong> (value != <strong class="jxr_keyword">null</strong> &amp;&amp; <strong class="jxr_keyword">this</strong>.factoryData.truncateStrings &amp;&amp; columnMetaData != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L779" href="#L779">779</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/jdbc/JdbcDatabaseManager.html">ResultSetColumnMetaData</a> resultSetColumnMetaData = columnMetaData.get(nameKey);
<a class="jxr_linenumber" name="L780" href="#L780">780</a> <strong class="jxr_keyword">if</strong> (resultSetColumnMetaData != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L781" href="#L781">781</a> <strong class="jxr_keyword">if</strong> (resultSetColumnMetaData.isStringType()) {
<a class="jxr_linenumber" name="L782" href="#L782">782</a> value = resultSetColumnMetaData.truncate(value.toString());
<a class="jxr_linenumber" name="L783" href="#L783">783</a> }
<a class="jxr_linenumber" name="L784" href="#L784">784</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L785" href="#L785">785</a> logger().error(<span class="jxr_string">"Missing ResultSetColumnMetaData for {}, connection={}, statement={}"</span>, nameKey,
<a class="jxr_linenumber" name="L786" href="#L786">786</a> connection, statement);
<a class="jxr_linenumber" name="L787" href="#L787">787</a> }
<a class="jxr_linenumber" name="L788" href="#L788">788</a> }
<a class="jxr_linenumber" name="L789" href="#L789">789</a> <strong class="jxr_keyword">return</strong> value;
<a class="jxr_linenumber" name="L790" href="#L790">790</a> }
<a class="jxr_linenumber" name="L791" href="#L791">791</a>
<a class="jxr_linenumber" name="L792" href="#L792">792</a> @Override
<a class="jxr_linenumber" name="L793" href="#L793">793</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> writeInternal(<strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/LogEvent.html">LogEvent</a> event, <strong class="jxr_keyword">final</strong> Serializable serializable) {
<a class="jxr_linenumber" name="L794" href="#L794">794</a> StringReader reader = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="L795" href="#L795">795</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L796" href="#L796">796</a> <strong class="jxr_keyword">if</strong> (!<strong class="jxr_keyword">this</strong>.isRunning() || isClosed(<strong class="jxr_keyword">this</strong>.connection) || isClosed(<strong class="jxr_keyword">this</strong>.statement)) {
<a class="jxr_linenumber" name="L797" href="#L797">797</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/AppenderLoggingException.html">AppenderLoggingException</a>(
<a class="jxr_linenumber" name="L798" href="#L798">798</a> <span class="jxr_string">"Cannot write logging event; JDBC manager not connected to the database, running=%s, [%s])."</span>,
<a class="jxr_linenumber" name="L799" href="#L799">799</a> isRunning(), fieldsToString());
<a class="jxr_linenumber" name="L800" href="#L800">800</a> }
<a class="jxr_linenumber" name="L801" href="#L801">801</a> <em class="jxr_comment">// Clear in case there are leftovers.</em>
<a class="jxr_linenumber" name="L802" href="#L802">802</a> statement.clearParameters();
<a class="jxr_linenumber" name="L803" href="#L803">803</a> <strong class="jxr_keyword">if</strong> (serializable instanceof MapMessage) {
<a class="jxr_linenumber" name="L804" href="#L804">804</a> setFields((MapMessage&lt;?, ?&gt;) serializable);
<a class="jxr_linenumber" name="L805" href="#L805">805</a> }
<a class="jxr_linenumber" name="L806" href="#L806">806</a> <strong class="jxr_keyword">int</strong> j = 1; <em class="jxr_comment">// JDBC indices start at 1</em>
<a class="jxr_linenumber" name="L807" href="#L807">807</a> <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.factoryData.columnMappings != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L808" href="#L808">808</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> ColumnMapping mapping : <strong class="jxr_keyword">this</strong>.factoryData.columnMappings) {
<a class="jxr_linenumber" name="L809" href="#L809">809</a> <strong class="jxr_keyword">if</strong> (ThreadContextMap.<strong class="jxr_keyword">class</strong>.isAssignableFrom(mapping.getType())
<a class="jxr_linenumber" name="L810" href="#L810">810</a> || ReadOnlyStringMap.<strong class="jxr_keyword">class</strong>.isAssignableFrom(mapping.getType())) {
<a class="jxr_linenumber" name="L811" href="#L811">811</a> <strong class="jxr_keyword">this</strong>.statement.setObject(j++, event.getContextData().toMap());
<a class="jxr_linenumber" name="L812" href="#L812">812</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (ThreadContextStack.<strong class="jxr_keyword">class</strong>.isAssignableFrom(mapping.getType())) {
<a class="jxr_linenumber" name="L813" href="#L813">813</a> <strong class="jxr_keyword">this</strong>.statement.setObject(j++, event.getContextStack().asList());
<a class="jxr_linenumber" name="L814" href="#L814">814</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (Date.<strong class="jxr_keyword">class</strong>.isAssignableFrom(mapping.getType())) {
<a class="jxr_linenumber" name="L815" href="#L815">815</a> <strong class="jxr_keyword">this</strong>.statement.setObject(j++, DateTypeConverter.fromMillis(event.getTimeMillis(),
<a class="jxr_linenumber" name="L816" href="#L816">816</a> mapping.getType().asSubclass(Date.<strong class="jxr_keyword">class</strong>)));
<a class="jxr_linenumber" name="L817" href="#L817">817</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L818" href="#L818">818</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/StringLayout.html">StringLayout</a> layout = mapping.getLayout();
<a class="jxr_linenumber" name="L819" href="#L819">819</a> <strong class="jxr_keyword">if</strong> (layout != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L820" href="#L820">820</a> <strong class="jxr_keyword">if</strong> (Clob.<strong class="jxr_keyword">class</strong>.isAssignableFrom(mapping.getType())) {
<a class="jxr_linenumber" name="L821" href="#L821">821</a> <strong class="jxr_keyword">this</strong>.statement.setClob(j++, <strong class="jxr_keyword">new</strong> StringReader(layout.toSerializable(event)));
<a class="jxr_linenumber" name="L822" href="#L822">822</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (NClob.<strong class="jxr_keyword">class</strong>.isAssignableFrom(mapping.getType())) {
<a class="jxr_linenumber" name="L823" href="#L823">823</a> <strong class="jxr_keyword">this</strong>.statement.setNClob(j++, <strong class="jxr_keyword">new</strong> StringReader(layout.toSerializable(event)));
<a class="jxr_linenumber" name="L824" href="#L824">824</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L825" href="#L825">825</a> <strong class="jxr_keyword">final</strong> Object value = TypeConverters.convert(layout.toSerializable(event),
<a class="jxr_linenumber" name="L826" href="#L826">826</a> mapping.getType(), <strong class="jxr_keyword">null</strong>);
<a class="jxr_linenumber" name="L827" href="#L827">827</a> setStatementObject(j++, mapping.getNameKey(), value);
<a class="jxr_linenumber" name="L828" href="#L828">828</a> }
<a class="jxr_linenumber" name="L829" href="#L829">829</a> }
<a class="jxr_linenumber" name="L830" href="#L830">830</a> }
<a class="jxr_linenumber" name="L831" href="#L831">831</a> }
<a class="jxr_linenumber" name="L832" href="#L832">832</a> }
<a class="jxr_linenumber" name="L833" href="#L833">833</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> ColumnConfig column : <strong class="jxr_keyword">this</strong>.columnConfigs) {
<a class="jxr_linenumber" name="L834" href="#L834">834</a> <strong class="jxr_keyword">if</strong> (column.isEventTimestamp()) {
<a class="jxr_linenumber" name="L835" href="#L835">835</a> <strong class="jxr_keyword">this</strong>.statement.setTimestamp(j++, <strong class="jxr_keyword">new</strong> Timestamp(event.getTimeMillis()));
<a class="jxr_linenumber" name="L836" href="#L836">836</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (column.isClob()) {
<a class="jxr_linenumber" name="L837" href="#L837">837</a> reader = <strong class="jxr_keyword">new</strong> StringReader(column.getLayout().toSerializable(event));
<a class="jxr_linenumber" name="L838" href="#L838">838</a> <strong class="jxr_keyword">if</strong> (column.isUnicode()) {
<a class="jxr_linenumber" name="L839" href="#L839">839</a> <strong class="jxr_keyword">this</strong>.statement.setNClob(j++, reader);
<a class="jxr_linenumber" name="L840" href="#L840">840</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L841" href="#L841">841</a> <strong class="jxr_keyword">this</strong>.statement.setClob(j++, reader);
<a class="jxr_linenumber" name="L842" href="#L842">842</a> }
<a class="jxr_linenumber" name="L843" href="#L843">843</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (column.isUnicode()) {
<a class="jxr_linenumber" name="L844" href="#L844">844</a> <strong class="jxr_keyword">this</strong>.statement.setNString(j++, Objects.toString(
<a class="jxr_linenumber" name="L845" href="#L845">845</a> truncate(column.getColumnNameKey(), column.getLayout().toSerializable(event)), <strong class="jxr_keyword">null</strong>));
<a class="jxr_linenumber" name="L846" href="#L846">846</a> } <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L847" href="#L847">847</a> <strong class="jxr_keyword">this</strong>.statement.setString(j++, Objects.toString(
<a class="jxr_linenumber" name="L848" href="#L848">848</a> truncate(column.getColumnNameKey(), column.getLayout().toSerializable(event)), <strong class="jxr_keyword">null</strong>));
<a class="jxr_linenumber" name="L849" href="#L849">849</a> }
<a class="jxr_linenumber" name="L850" href="#L850">850</a> }
<a class="jxr_linenumber" name="L851" href="#L851">851</a>
<a class="jxr_linenumber" name="L852" href="#L852">852</a> <strong class="jxr_keyword">if</strong> (isBuffered() &amp;&amp; <strong class="jxr_keyword">this</strong>.isBatchSupported) {
<a class="jxr_linenumber" name="L853" href="#L853">853</a> <strong class="jxr_keyword">this</strong>.statement.addBatch();
<a class="jxr_linenumber" name="L854" href="#L854">854</a> } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.statement.executeUpdate() == 0) {
<a class="jxr_linenumber" name="L855" href="#L855">855</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/AppenderLoggingException.html">AppenderLoggingException</a>(
<a class="jxr_linenumber" name="L856" href="#L856">856</a> <span class="jxr_string">"No records inserted in database table for log event in JDBC manager [%s]."</span>, fieldsToString());
<a class="jxr_linenumber" name="L857" href="#L857">857</a> }
<a class="jxr_linenumber" name="L858" href="#L858">858</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> SQLException e) {
<a class="jxr_linenumber" name="L859" href="#L859">859</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/appender/db/DbAppenderLoggingException.html">DbAppenderLoggingException</a>(e, <span class="jxr_string">"Failed to insert record for log event in JDBC manager: %s [%s]"</span>, e,
<a class="jxr_linenumber" name="L860" href="#L860">860</a> fieldsToString());
<a class="jxr_linenumber" name="L861" href="#L861">861</a> } <strong class="jxr_keyword">finally</strong> {
<a class="jxr_linenumber" name="L862" href="#L862">862</a> <em class="jxr_comment">// Release ASAP</em>
<a class="jxr_linenumber" name="L863" href="#L863">863</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L864" href="#L864">864</a> <em class="jxr_comment">// statement can be null when a AppenderLoggingException is thrown at the start of this method</em>
<a class="jxr_linenumber" name="L865" href="#L865">865</a> <strong class="jxr_keyword">if</strong> (statement != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="L866" href="#L866">866</a> statement.clearParameters();
<a class="jxr_linenumber" name="L867" href="#L867">867</a> }
<a class="jxr_linenumber" name="L868" href="#L868">868</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> SQLException e) {
<a class="jxr_linenumber" name="L869" href="#L869">869</a> <em class="jxr_comment">// Ignore</em>
<a class="jxr_linenumber" name="L870" href="#L870">870</a> }
<a class="jxr_linenumber" name="L871" href="#L871">871</a> Closer.closeSilently(reader);
<a class="jxr_linenumber" name="L872" href="#L872">872</a> }
<a class="jxr_linenumber" name="L873" href="#L873">873</a> }
<a class="jxr_linenumber" name="L874" href="#L874">874</a>
<a class="jxr_linenumber" name="L875" href="#L875">875</a> @Override
<a class="jxr_linenumber" name="L876" href="#L876">876</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> writeThrough(<strong class="jxr_keyword">final</strong> <a href="../../../../../../../../org/apache/logging/log4j/core/LogEvent.html">LogEvent</a> event, <strong class="jxr_keyword">final</strong> Serializable serializable) {
<a class="jxr_linenumber" name="L877" href="#L877">877</a> <strong class="jxr_keyword">this</strong>.connectAndStart();
<a class="jxr_linenumber" name="L878" href="#L878">878</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L879" href="#L879">879</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L880" href="#L880">880</a> <strong class="jxr_keyword">this</strong>.writeInternal(event, serializable);
<a class="jxr_linenumber" name="L881" href="#L881">881</a> } <strong class="jxr_keyword">finally</strong> {
<a class="jxr_linenumber" name="L882" href="#L882">882</a> <strong class="jxr_keyword">this</strong>.commitAndClose();
<a class="jxr_linenumber" name="L883" href="#L883">883</a> }
<a class="jxr_linenumber" name="L884" href="#L884">884</a> } <strong class="jxr_keyword">catch</strong> (<strong class="jxr_keyword">final</strong> DbAppenderLoggingException e) {
<a class="jxr_linenumber" name="L885" href="#L885">885</a> reconnectOn(e);
<a class="jxr_linenumber" name="L886" href="#L886">886</a> <strong class="jxr_keyword">try</strong> {
<a class="jxr_linenumber" name="L887" href="#L887">887</a> <strong class="jxr_keyword">this</strong>.writeInternal(event, serializable);
<a class="jxr_linenumber" name="L888" href="#L888">888</a> } <strong class="jxr_keyword">finally</strong> {
<a class="jxr_linenumber" name="L889" href="#L889">889</a> <strong class="jxr_keyword">this</strong>.commitAndClose();
<a class="jxr_linenumber" name="L890" href="#L890">890</a> }
<a class="jxr_linenumber" name="L891" href="#L891">891</a> }
<a class="jxr_linenumber" name="L892" href="#L892">892</a> }
<a class="jxr_linenumber" name="L893" href="#L893">893</a>
<a class="jxr_linenumber" name="L894" href="#L894">894</a> }
</pre>
<hr/>
<div id="footer">Copyright &#169; 1999&#x2013;2020 <a href="https://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</div>
</body>
</html>