You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@logging.apache.org by ca...@apache.org on 2007/08/29 21:46:35 UTC

svn commit: r570911 [10/21] - in /logging/site/trunk/docs/log4j/companions/receivers: ./ apidocs/ apidocs/org/apache/log4j/db/ apidocs/org/apache/log4j/db/class-use/ apidocs/org/apache/log4j/db/dialect/ apidocs/org/apache/log4j/db/dialect/class-use/ ap...

Modified: logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/DBAppender.html
URL: http://svn.apache.org/viewvc/logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/DBAppender.html?rev=570911&r1=570910&r2=570911&view=diff
==============================================================================
--- logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/DBAppender.html (original)
+++ logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/DBAppender.html Wed Aug 29 12:46:25 2007
@@ -124,289 +124,292 @@
 <a name="115" href="#115">115</a> <em> *</em>
 <a name="116" href="#116">116</a> <em> * @author Ceki G&amp;uuml;lc&amp;uuml;</em>
 <a name="117" href="#117">117</a> <em> * @author Ray DeCampo</em>
-<a name="118" href="#118">118</a> <em> * @since 1.3</em>
-<a name="119" href="#119">119</a> <em> */</em>
-<a name="120" href="#120">120</a> <strong>public</strong> <strong>class</strong> <a href="../../../../org/apache/log4j/db/DBAppender.html">DBAppender</a> <strong>extends</strong> AppenderSkeleton implements UnrecognizedElementHandler {
-<a name="121" href="#121">121</a>   <strong>static</strong> <strong>final</strong> String insertPropertiesSQL =
-<a name="122" href="#122">122</a>     <span class="string">"INSERT INTO  logging_event_property (event_id, mapped_key, mapped_value) VALUES (?, ?, ?)"</span>;
-<a name="123" href="#123">123</a>   <strong>static</strong> <strong>final</strong> String insertExceptionSQL =
-<a name="124" href="#124">124</a>     <span class="string">"INSERT INTO  logging_event_exception (event_id, i, trace_line) VALUES (?, ?, ?)"</span>;
-<a name="125" href="#125">125</a>   <strong>static</strong> <strong>final</strong> String insertSQL;
-<a name="126" href="#126">126</a>   <strong>private</strong> <strong>static</strong> <strong>final</strong> Method GET_GENERATED_KEYS_METHOD;
+<a name="118" href="#118">118</a> <em> */</em>
+<a name="119" href="#119">119</a> <strong>public</strong> <strong>class</strong> <a href="../../../../org/apache/log4j/db/DBAppender.html">DBAppender</a> <strong>extends</strong> AppenderSkeleton implements UnrecognizedElementHandler {
+<a name="120" href="#120">120</a>   <strong>static</strong> <strong>final</strong> String insertPropertiesSQL =
+<a name="121" href="#121">121</a>     <span class="string">"INSERT INTO  logging_event_property (event_id, mapped_key, mapped_value) VALUES (?, ?, ?)"</span>;
+<a name="122" href="#122">122</a>   <strong>static</strong> <strong>final</strong> String insertExceptionSQL =
+<a name="123" href="#123">123</a>     <span class="string">"INSERT INTO  logging_event_exception (event_id, i, trace_line) VALUES (?, ?, ?)"</span>;
+<a name="124" href="#124">124</a>   <strong>static</strong> <strong>final</strong> String insertSQL;
+<a name="125" href="#125">125</a>   <strong>private</strong> <strong>static</strong> <strong>final</strong> Method GET_GENERATED_KEYS_METHOD;
+<a name="126" href="#126">126</a> 
 <a name="127" href="#127">127</a> 
-<a name="128" href="#128">128</a> 
-<a name="129" href="#129">129</a>   <strong>static</strong> {
-<a name="130" href="#130">130</a>     StringBuffer sql = <strong>new</strong> StringBuffer();
-<a name="131" href="#131">131</a>     sql.append(<span class="string">"INSERT INTO logging_event ("</span>);
-<a name="132" href="#132">132</a>     sql.append(<span class="string">"sequence_number, "</span>);
-<a name="133" href="#133">133</a>     sql.append(<span class="string">"timestamp, "</span>);
-<a name="134" href="#134">134</a>     sql.append(<span class="string">"rendered_message, "</span>);
-<a name="135" href="#135">135</a>     sql.append(<span class="string">"logger_name, "</span>);
-<a name="136" href="#136">136</a>     sql.append(<span class="string">"level_string, "</span>);
-<a name="137" href="#137">137</a>     sql.append(<span class="string">"ndc, "</span>);
-<a name="138" href="#138">138</a>     sql.append(<span class="string">"thread_name, "</span>);
-<a name="139" href="#139">139</a>     sql.append(<span class="string">"reference_flag, "</span>);
-<a name="140" href="#140">140</a>     sql.append(<span class="string">"caller_filename, "</span>);
-<a name="141" href="#141">141</a>     sql.append(<span class="string">"caller_class, "</span>);
-<a name="142" href="#142">142</a>     sql.append(<span class="string">"caller_method, "</span>);
-<a name="143" href="#143">143</a>     sql.append(<span class="string">"caller_line) "</span>);
-<a name="144" href="#144">144</a>     sql.append(<span class="string">" VALUES (?, ?, ? ,?, ?, ?, ?, ?, ?, ?, ?, ?)"</span>);
-<a name="145" href="#145">145</a>     insertSQL = sql.toString();
-<a name="146" href="#146">146</a>     <em class="comment">//</em>
-<a name="147" href="#147">147</a>     <em class="comment">//   PreparedStatement.getGeneratedKeys added in JDK 1.4</em>
-<a name="148" href="#148">148</a>     <em class="comment">//</em>
-<a name="149" href="#149">149</a>     Method getGeneratedKeysMethod;
-<a name="150" href="#150">150</a>     <strong>try</strong> {
-<a name="151" href="#151">151</a>         getGeneratedKeysMethod = PreparedStatement.<strong>class</strong>.getMethod(<span class="string">"getGeneratedKeys"</span>, <strong>null</strong>);
-<a name="152" href="#152">152</a>     } <strong>catch</strong>(Exception ex) {
-<a name="153" href="#153">153</a>         getGeneratedKeysMethod = <strong>null</strong>;
-<a name="154" href="#154">154</a>     }
-<a name="155" href="#155">155</a>     GET_GENERATED_KEYS_METHOD = getGeneratedKeysMethod;
-<a name="156" href="#156">156</a>   }
-<a name="157" href="#157">157</a> 
-<a name="158" href="#158">158</a>   <a href="../../../../org/apache/log4j/db/ConnectionSource.html">ConnectionSource</a> connectionSource;
-<a name="159" href="#159">159</a>   <strong>boolean</strong> cnxSupportsGetGeneratedKeys = false;
-<a name="160" href="#160">160</a>   <strong>boolean</strong> cnxSupportsBatchUpdates = false;
-<a name="161" href="#161">161</a>   <a href="../../../../org/apache/log4j/db/dialect/SQLDialect.html">SQLDialect</a> sqlDialect;
-<a name="162" href="#162">162</a>   <strong>boolean</strong> locationInfo = false;
-<a name="163" href="#163">163</a>   
-<a name="164" href="#164">164</a> 
-<a name="165" href="#165">165</a>   <strong>public</strong> <a href="../../../../org/apache/log4j/db/DBAppender.html">DBAppender</a>() {
-<a name="166" href="#166">166</a>       <strong>super</strong>(false);
-<a name="167" href="#167">167</a>   }
-<a name="168" href="#168">168</a> 
-<a name="169" href="#169">169</a>   <strong>public</strong> <strong>void</strong> activateOptions() {
-<a name="170" href="#170">170</a>     LogLog.debug(<span class="string">"DBAppender.activateOptions called"</span>);
-<a name="171" href="#171">171</a> 
-<a name="172" href="#172">172</a>     <strong>if</strong> (connectionSource == <strong>null</strong>) {
-<a name="173" href="#173">173</a>       <strong>throw</strong> <strong>new</strong> IllegalStateException(
-<a name="174" href="#174">174</a>         <span class="string">"DBAppender cannot function without a connection source"</span>);
-<a name="175" href="#175">175</a>     }
-<a name="176" href="#176">176</a> 
-<a name="177" href="#177">177</a>     sqlDialect = Util.getDialectFromCode(connectionSource.getSQLDialectCode());
-<a name="178" href="#178">178</a>     <strong>if</strong> (GET_GENERATED_KEYS_METHOD != <strong>null</strong>) {
-<a name="179" href="#179">179</a>         cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
-<a name="180" href="#180">180</a>     } <strong>else</strong> {
-<a name="181" href="#181">181</a>         cnxSupportsGetGeneratedKeys = false;
-<a name="182" href="#182">182</a>     }
-<a name="183" href="#183">183</a>     cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
-<a name="184" href="#184">184</a>     <strong>if</strong> (!cnxSupportsGetGeneratedKeys &amp;&amp; (sqlDialect == <strong>null</strong>)) {
-<a name="185" href="#185">185</a>       <strong>throw</strong> <strong>new</strong> IllegalStateException(
-<a name="186" href="#186">186</a>         <span class="string">"DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect"</span>);
-<a name="187" href="#187">187</a>     }
-<a name="188" href="#188">188</a>     
-<a name="189" href="#189">189</a>     <em class="comment">// all nice and dandy on the eastern front</em>
-<a name="190" href="#190">190</a>     <strong>super</strong>.activateOptions();
-<a name="191" href="#191">191</a>   }
-<a name="192" href="#192">192</a> 
-<a name="193" href="#193">193</a>   <em>/**<em>*</em></em>
-<a name="194" href="#194">194</a> <em>   * @return Returns the connectionSource.</em>
-<a name="195" href="#195">195</a> <em>   */</em>
-<a name="196" href="#196">196</a>   <strong>public</strong> <a href="../../../../org/apache/log4j/db/ConnectionSource.html">ConnectionSource</a> getConnectionSource() {
-<a name="197" href="#197">197</a>     <strong>return</strong> connectionSource;
-<a name="198" href="#198">198</a>   }
-<a name="199" href="#199">199</a> 
-<a name="200" href="#200">200</a>   <em>/**<em>*</em></em>
-<a name="201" href="#201">201</a> <em>   * @param connectionSource</em>
-<a name="202" href="#202">202</a> <em>   *          The connectionSource to set.</em>
-<a name="203" href="#203">203</a> <em>   */</em>
-<a name="204" href="#204">204</a>   <strong>public</strong> <strong>void</strong> setConnectionSource(<a href="../../../../org/apache/log4j/db/ConnectionSource.html">ConnectionSource</a> connectionSource) {
-<a name="205" href="#205">205</a>     LogLog.debug(<span class="string">"setConnectionSource called for DBAppender"</span>);
-<a name="206" href="#206">206</a>     <strong>this</strong>.connectionSource = connectionSource;
-<a name="207" href="#207">207</a>   }
-<a name="208" href="#208">208</a> 
-<a name="209" href="#209">209</a>   <strong>protected</strong> <strong>void</strong> append(LoggingEvent event) {
-<a name="210" href="#210">210</a>       Connection connection = <strong>null</strong>;
-<a name="211" href="#211">211</a>       <strong>try</strong> {
-<a name="212" href="#212">212</a>           connection = connectionSource.getConnection();
-<a name="213" href="#213">213</a>           connection.setAutoCommit(false);
-<a name="214" href="#214">214</a>           
-<a name="215" href="#215">215</a>           PreparedStatement insertStatement =
-<a name="216" href="#216">216</a>               connection.prepareStatement(insertSQL);
-<a name="217" href="#217">217</a> 
-<a name="218" href="#218">218</a> <em class="comment">/*<em class="comment">          insertStatement.setLong(1, event.getSequenceNumber());*/</em></em>
-<a name="219" href="#219">219</a> 		  insertStatement.setLong(1, 0);
-<a name="220" href="#220">220</a> 		
-<a name="221" href="#221">221</a>           insertStatement.setLong(2, event.getTimeStamp());
-<a name="222" href="#222">222</a>           insertStatement.setString(3, event.getRenderedMessage());
-<a name="223" href="#223">223</a>           insertStatement.setString(4, event.getLoggerName());
-<a name="224" href="#224">224</a>           insertStatement.setString(5, event.getLevel().toString());
-<a name="225" href="#225">225</a>           insertStatement.setString(6, event.getNDC());
-<a name="226" href="#226">226</a>           insertStatement.setString(7, event.getThreadName());
-<a name="227" href="#227">227</a>           insertStatement.setShort(8, DBHelper.computeReferenceMask(event));
-<a name="228" href="#228">228</a>           
-<a name="229" href="#229">229</a>           LocationInfo li;
-<a name="230" href="#230">230</a>           
-<a name="231" href="#231">231</a>           <strong>if</strong> (event.locationInformationExists() || locationInfo) {
-<a name="232" href="#232">232</a>               li = event.getLocationInformation();
-<a name="233" href="#233">233</a>           } <strong>else</strong> {
-<a name="234" href="#234">234</a>               li = LocationInfo.NA_LOCATION_INFO;
-<a name="235" href="#235">235</a>           }
-<a name="236" href="#236">236</a>           
-<a name="237" href="#237">237</a>           insertStatement.setString(9, li.getFileName());
-<a name="238" href="#238">238</a>           insertStatement.setString(10, li.getClassName());
-<a name="239" href="#239">239</a>           insertStatement.setString(11, li.getMethodName());
-<a name="240" href="#240">240</a>           insertStatement.setString(12, li.getLineNumber());
-<a name="241" href="#241">241</a>           
-<a name="242" href="#242">242</a>           <strong>int</strong> updateCount = insertStatement.executeUpdate();
-<a name="243" href="#243">243</a>           <strong>if</strong> (updateCount != 1) {
-<a name="244" href="#244">244</a>               LogLog.warn(<span class="string">"Failed to insert loggingEvent"</span>);
-<a name="245" href="#245">245</a>           }
-<a name="246" href="#246">246</a>           
-<a name="247" href="#247">247</a>           ResultSet rs = <strong>null</strong>;
-<a name="248" href="#248">248</a>           Statement idStatement = <strong>null</strong>;
-<a name="249" href="#249">249</a>           <strong>boolean</strong> gotGeneratedKeys = false;
-<a name="250" href="#250">250</a>           <strong>if</strong> (cnxSupportsGetGeneratedKeys) {
-<a name="251" href="#251">251</a>               <strong>try</strong> {
-<a name="252" href="#252">252</a>                   rs = (ResultSet) GET_GENERATED_KEYS_METHOD.invoke(insertStatement, <strong>null</strong>);
-<a name="253" href="#253">253</a>                   gotGeneratedKeys = <strong>true</strong>;
-<a name="254" href="#254">254</a>               } <strong>catch</strong>(InvocationTargetException ex) {
-<a name="255" href="#255">255</a>                   Throwable target = ex.getTargetException();
-<a name="256" href="#256">256</a>                   <strong>if</strong> (target instanceof SQLException) {
-<a name="257" href="#257">257</a>                       <strong>throw</strong> (SQLException) target;
-<a name="258" href="#258">258</a>                   }
-<a name="259" href="#259">259</a>                   <strong>throw</strong> ex; 
-<a name="260" href="#260">260</a>               } <strong>catch</strong>(IllegalAccessException ex) {
-<a name="261" href="#261">261</a>                   LogLog.warn(<span class="string">"IllegalAccessException invoking PreparedStatement.getGeneratedKeys"</span>, ex);
-<a name="262" href="#262">262</a>               }
-<a name="263" href="#263">263</a>           }
-<a name="264" href="#264">264</a>           
-<a name="265" href="#265">265</a>           <strong>if</strong> (!gotGeneratedKeys) {
-<a name="266" href="#266">266</a>               insertStatement.close();
-<a name="267" href="#267">267</a>               insertStatement = <strong>null</strong>;
-<a name="268" href="#268">268</a>               
-<a name="269" href="#269">269</a>               idStatement = connection.createStatement();
-<a name="270" href="#270">270</a>               idStatement.setMaxRows(1);
-<a name="271" href="#271">271</a>               rs = idStatement.executeQuery(sqlDialect.getSelectInsertId());
-<a name="272" href="#272">272</a>           }
-<a name="273" href="#273">273</a>           
-<a name="274" href="#274">274</a>           <em class="comment">// A ResultSet cursor is initially positioned before the first row; the </em>
-<a name="275" href="#275">275</a>           <em class="comment">// first call to the method next makes the first row the current row</em>
-<a name="276" href="#276">276</a>           rs.next();
-<a name="277" href="#277">277</a>           <strong>int</strong> eventId = rs.getInt(1);
-<a name="278" href="#278">278</a>           
-<a name="279" href="#279">279</a>           rs.close();
-<a name="280" href="#280">280</a> 
-<a name="281" href="#281">281</a>           <em class="comment">// we no longer need the insertStatement</em>
-<a name="282" href="#282">282</a>           <strong>if</strong>(insertStatement != <strong>null</strong>) {
-<a name="283" href="#283">283</a>               insertStatement.close();
-<a name="284" href="#284">284</a>               insertStatement = <strong>null</strong>;
-<a name="285" href="#285">285</a>           }
-<a name="286" href="#286">286</a> 
-<a name="287" href="#287">287</a>           <strong>if</strong>(idStatement != <strong>null</strong>) {
-<a name="288" href="#288">288</a>               idStatement.close();
-<a name="289" href="#289">289</a>               idStatement = <strong>null</strong>;
-<a name="290" href="#290">290</a>           }
-<a name="291" href="#291">291</a> 
-<a name="292" href="#292">292</a>           Set propertiesKeys = event.getPropertyKeySet();
-<a name="293" href="#293">293</a>           
-<a name="294" href="#294">294</a>           <strong>if</strong> (propertiesKeys.size() > 0) {
-<a name="295" href="#295">295</a>               PreparedStatement insertPropertiesStatement =
-<a name="296" href="#296">296</a>                   connection.prepareStatement(insertPropertiesSQL);
-<a name="297" href="#297">297</a>               
-<a name="298" href="#298">298</a>               <strong>for</strong> (Iterator i = propertiesKeys.iterator(); i.hasNext();) {
-<a name="299" href="#299">299</a>                   String key = (String) i.next();
-<a name="300" href="#300">300</a>                   String value = (String) event.getProperty(key);
-<a name="301" href="#301">301</a>                   
-<a name="302" href="#302">302</a>                   <em class="comment">//LogLog.info("id " + eventId + ", key " + key + ", value " + value);</em>
-<a name="303" href="#303">303</a>                   insertPropertiesStatement.setInt(1, eventId);
-<a name="304" href="#304">304</a>                   insertPropertiesStatement.setString(2, key);
-<a name="305" href="#305">305</a>                   insertPropertiesStatement.setString(3, value);
-<a name="306" href="#306">306</a>                   
-<a name="307" href="#307">307</a>                   <strong>if</strong> (cnxSupportsBatchUpdates) {
-<a name="308" href="#308">308</a>                       insertPropertiesStatement.addBatch();
-<a name="309" href="#309">309</a>                   } <strong>else</strong> {
-<a name="310" href="#310">310</a>                       insertPropertiesStatement.execute();
-<a name="311" href="#311">311</a>                   }
-<a name="312" href="#312">312</a>               }
-<a name="313" href="#313">313</a>               
-<a name="314" href="#314">314</a>               <strong>if</strong> (cnxSupportsBatchUpdates) {
-<a name="315" href="#315">315</a>                   insertPropertiesStatement.executeBatch();
-<a name="316" href="#316">316</a>               }
-<a name="317" href="#317">317</a>               
-<a name="318" href="#318">318</a>               insertPropertiesStatement.close();
-<a name="319" href="#319">319</a>               insertPropertiesStatement = <strong>null</strong>;
-<a name="320" href="#320">320</a>           }
-<a name="321" href="#321">321</a>           
-<a name="322" href="#322">322</a>           String[] strRep = event.getThrowableStrRep();
-<a name="323" href="#323">323</a>           
-<a name="324" href="#324">324</a>           <strong>if</strong> (strRep != <strong>null</strong>) {
-<a name="325" href="#325">325</a>               LogLog.debug(<span class="string">"Logging an exception"</span>);
-<a name="326" href="#326">326</a>               
-<a name="327" href="#327">327</a>               PreparedStatement insertExceptionStatement =
-<a name="328" href="#328">328</a>                   connection.prepareStatement(insertExceptionSQL);
+<a name="128" href="#128">128</a>   <strong>static</strong> {
+<a name="129" href="#129">129</a>     StringBuffer sql = <strong>new</strong> StringBuffer();
+<a name="130" href="#130">130</a>     sql.append(<span class="string">"INSERT INTO logging_event ("</span>);
+<a name="131" href="#131">131</a>     sql.append(<span class="string">"sequence_number, "</span>);
+<a name="132" href="#132">132</a>     sql.append(<span class="string">"timestamp, "</span>);
+<a name="133" href="#133">133</a>     sql.append(<span class="string">"rendered_message, "</span>);
+<a name="134" href="#134">134</a>     sql.append(<span class="string">"logger_name, "</span>);
+<a name="135" href="#135">135</a>     sql.append(<span class="string">"level_string, "</span>);
+<a name="136" href="#136">136</a>     sql.append(<span class="string">"ndc, "</span>);
+<a name="137" href="#137">137</a>     sql.append(<span class="string">"thread_name, "</span>);
+<a name="138" href="#138">138</a>     sql.append(<span class="string">"reference_flag, "</span>);
+<a name="139" href="#139">139</a>     sql.append(<span class="string">"caller_filename, "</span>);
+<a name="140" href="#140">140</a>     sql.append(<span class="string">"caller_class, "</span>);
+<a name="141" href="#141">141</a>     sql.append(<span class="string">"caller_method, "</span>);
+<a name="142" href="#142">142</a>     sql.append(<span class="string">"caller_line) "</span>);
+<a name="143" href="#143">143</a>     sql.append(<span class="string">" VALUES (?, ?, ? ,?, ?, ?, ?, ?, ?, ?, ?, ?)"</span>);
+<a name="144" href="#144">144</a>     insertSQL = sql.toString();
+<a name="145" href="#145">145</a>     <em class="comment">//</em>
+<a name="146" href="#146">146</a>     <em class="comment">//   PreparedStatement.getGeneratedKeys added in JDK 1.4</em>
+<a name="147" href="#147">147</a>     <em class="comment">//</em>
+<a name="148" href="#148">148</a>     Method getGeneratedKeysMethod;
+<a name="149" href="#149">149</a>     <strong>try</strong> {
+<a name="150" href="#150">150</a>         getGeneratedKeysMethod = PreparedStatement.<strong>class</strong>.getMethod(<span class="string">"getGeneratedKeys"</span>, <strong>null</strong>);
+<a name="151" href="#151">151</a>     } <strong>catch</strong>(Exception ex) {
+<a name="152" href="#152">152</a>         getGeneratedKeysMethod = <strong>null</strong>;
+<a name="153" href="#153">153</a>     }
+<a name="154" href="#154">154</a>     GET_GENERATED_KEYS_METHOD = getGeneratedKeysMethod;
+<a name="155" href="#155">155</a>   }
+<a name="156" href="#156">156</a> 
+<a name="157" href="#157">157</a>   <a href="../../../../org/apache/log4j/db/ConnectionSource.html">ConnectionSource</a> connectionSource;
+<a name="158" href="#158">158</a>   <strong>boolean</strong> cnxSupportsGetGeneratedKeys = false;
+<a name="159" href="#159">159</a>   <strong>boolean</strong> cnxSupportsBatchUpdates = false;
+<a name="160" href="#160">160</a>   <a href="../../../../org/apache/log4j/db/dialect/SQLDialect.html">SQLDialect</a> sqlDialect;
+<a name="161" href="#161">161</a>   <strong>boolean</strong> locationInfo = false;
+<a name="162" href="#162">162</a>   
+<a name="163" href="#163">163</a> 
+<a name="164" href="#164">164</a>   <strong>public</strong> <a href="../../../../org/apache/log4j/db/DBAppender.html">DBAppender</a>() {
+<a name="165" href="#165">165</a>       <strong>super</strong>(false);
+<a name="166" href="#166">166</a>   }
+<a name="167" href="#167">167</a> 
+<a name="168" href="#168">168</a>   <strong>public</strong> <strong>void</strong> activateOptions() {
+<a name="169" href="#169">169</a>     LogLog.debug(<span class="string">"DBAppender.activateOptions called"</span>);
+<a name="170" href="#170">170</a> 
+<a name="171" href="#171">171</a>     <strong>if</strong> (connectionSource == <strong>null</strong>) {
+<a name="172" href="#172">172</a>       <strong>throw</strong> <strong>new</strong> IllegalStateException(
+<a name="173" href="#173">173</a>         <span class="string">"DBAppender cannot function without a connection source"</span>);
+<a name="174" href="#174">174</a>     }
+<a name="175" href="#175">175</a> 
+<a name="176" href="#176">176</a>     sqlDialect = Util.getDialectFromCode(connectionSource.getSQLDialectCode());
+<a name="177" href="#177">177</a>     <strong>if</strong> (GET_GENERATED_KEYS_METHOD != <strong>null</strong>) {
+<a name="178" href="#178">178</a>         cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
+<a name="179" href="#179">179</a>     } <strong>else</strong> {
+<a name="180" href="#180">180</a>         cnxSupportsGetGeneratedKeys = false;
+<a name="181" href="#181">181</a>     }
+<a name="182" href="#182">182</a>     cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
+<a name="183" href="#183">183</a>     <strong>if</strong> (!cnxSupportsGetGeneratedKeys &amp;&amp; (sqlDialect == <strong>null</strong>)) {
+<a name="184" href="#184">184</a>       <strong>throw</strong> <strong>new</strong> IllegalStateException(
+<a name="185" href="#185">185</a>         <span class="string">"DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect"</span>);
+<a name="186" href="#186">186</a>     }
+<a name="187" href="#187">187</a>     
+<a name="188" href="#188">188</a>     <em class="comment">// all nice and dandy on the eastern front</em>
+<a name="189" href="#189">189</a>     <strong>super</strong>.activateOptions();
+<a name="190" href="#190">190</a>   }
+<a name="191" href="#191">191</a> 
+<a name="192" href="#192">192</a>   <em>/**<em>*</em></em>
+<a name="193" href="#193">193</a> <em>   * @return Returns the connectionSource.</em>
+<a name="194" href="#194">194</a> <em>   */</em>
+<a name="195" href="#195">195</a>   <strong>public</strong> <a href="../../../../org/apache/log4j/db/ConnectionSource.html">ConnectionSource</a> getConnectionSource() {
+<a name="196" href="#196">196</a>     <strong>return</strong> connectionSource;
+<a name="197" href="#197">197</a>   }
+<a name="198" href="#198">198</a> 
+<a name="199" href="#199">199</a>   <em>/**<em>*</em></em>
+<a name="200" href="#200">200</a> <em>   * @param connectionSource</em>
+<a name="201" href="#201">201</a> <em>   *          The connectionSource to set.</em>
+<a name="202" href="#202">202</a> <em>   */</em>
+<a name="203" href="#203">203</a>   <strong>public</strong> <strong>void</strong> setConnectionSource(<a href="../../../../org/apache/log4j/db/ConnectionSource.html">ConnectionSource</a> connectionSource) {
+<a name="204" href="#204">204</a>     LogLog.debug(<span class="string">"setConnectionSource called for DBAppender"</span>);
+<a name="205" href="#205">205</a>     <strong>this</strong>.connectionSource = connectionSource;
+<a name="206" href="#206">206</a>   }
+<a name="207" href="#207">207</a> 
+<a name="208" href="#208">208</a>   <strong>protected</strong> <strong>void</strong> append(LoggingEvent event) {
+<a name="209" href="#209">209</a>       Connection connection = <strong>null</strong>;
+<a name="210" href="#210">210</a>       <strong>try</strong> {
+<a name="211" href="#211">211</a>           connection = connectionSource.getConnection();
+<a name="212" href="#212">212</a>           connection.setAutoCommit(false);
+<a name="213" href="#213">213</a>           
+<a name="214" href="#214">214</a>           PreparedStatement insertStatement;
+<a name="215" href="#215">215</a>           <strong>if</strong> (cnxSupportsGetGeneratedKeys) {
+<a name="216" href="#216">216</a>         	  insertStatement = connection.prepareStatement(insertSQL, Statement.RETURN_GENERATED_KEYS);
+<a name="217" href="#217">217</a>           } <strong>else</strong> {
+<a name="218" href="#218">218</a>               insertStatement = connection.prepareStatement(insertSQL);
+<a name="219" href="#219">219</a>           }
+<a name="220" href="#220">220</a> 
+<a name="221" href="#221">221</a> <em class="comment">/*<em class="comment">          insertStatement.setLong(1, event.getSequenceNumber());*/</em></em>
+<a name="222" href="#222">222</a> 		  insertStatement.setLong(1, 0);
+<a name="223" href="#223">223</a> 		
+<a name="224" href="#224">224</a>           insertStatement.setLong(2, event.getTimeStamp());
+<a name="225" href="#225">225</a>           insertStatement.setString(3, event.getRenderedMessage());
+<a name="226" href="#226">226</a>           insertStatement.setString(4, event.getLoggerName());
+<a name="227" href="#227">227</a>           insertStatement.setString(5, event.getLevel().toString());
+<a name="228" href="#228">228</a>           insertStatement.setString(6, event.getNDC());
+<a name="229" href="#229">229</a>           insertStatement.setString(7, event.getThreadName());
+<a name="230" href="#230">230</a>           insertStatement.setShort(8, DBHelper.computeReferenceMask(event));
+<a name="231" href="#231">231</a>           
+<a name="232" href="#232">232</a>           LocationInfo li;
+<a name="233" href="#233">233</a>           
+<a name="234" href="#234">234</a>           <strong>if</strong> (event.locationInformationExists() || locationInfo) {
+<a name="235" href="#235">235</a>               li = event.getLocationInformation();
+<a name="236" href="#236">236</a>           } <strong>else</strong> {
+<a name="237" href="#237">237</a>               li = LocationInfo.NA_LOCATION_INFO;
+<a name="238" href="#238">238</a>           }
+<a name="239" href="#239">239</a>           
+<a name="240" href="#240">240</a>           insertStatement.setString(9, li.getFileName());
+<a name="241" href="#241">241</a>           insertStatement.setString(10, li.getClassName());
+<a name="242" href="#242">242</a>           insertStatement.setString(11, li.getMethodName());
+<a name="243" href="#243">243</a>           insertStatement.setString(12, li.getLineNumber());
+<a name="244" href="#244">244</a>           
+<a name="245" href="#245">245</a>           <strong>int</strong> updateCount = insertStatement.executeUpdate();
+<a name="246" href="#246">246</a>           <strong>if</strong> (updateCount != 1) {
+<a name="247" href="#247">247</a>               LogLog.warn(<span class="string">"Failed to insert loggingEvent"</span>);
+<a name="248" href="#248">248</a>           }
+<a name="249" href="#249">249</a>           
+<a name="250" href="#250">250</a>           ResultSet rs = <strong>null</strong>;
+<a name="251" href="#251">251</a>           Statement idStatement = <strong>null</strong>;
+<a name="252" href="#252">252</a>           <strong>boolean</strong> gotGeneratedKeys = false;
+<a name="253" href="#253">253</a>           <strong>if</strong> (cnxSupportsGetGeneratedKeys) {
+<a name="254" href="#254">254</a>               <strong>try</strong> {
+<a name="255" href="#255">255</a>                   rs = (ResultSet) GET_GENERATED_KEYS_METHOD.invoke(insertStatement, <strong>null</strong>);
+<a name="256" href="#256">256</a>                   gotGeneratedKeys = <strong>true</strong>;
+<a name="257" href="#257">257</a>               } <strong>catch</strong>(InvocationTargetException ex) {
+<a name="258" href="#258">258</a>                   Throwable target = ex.getTargetException();
+<a name="259" href="#259">259</a>                   <strong>if</strong> (target instanceof SQLException) {
+<a name="260" href="#260">260</a>                       <strong>throw</strong> (SQLException) target;
+<a name="261" href="#261">261</a>                   }
+<a name="262" href="#262">262</a>                   <strong>throw</strong> ex; 
+<a name="263" href="#263">263</a>               } <strong>catch</strong>(IllegalAccessException ex) {
+<a name="264" href="#264">264</a>                   LogLog.warn(<span class="string">"IllegalAccessException invoking PreparedStatement.getGeneratedKeys"</span>, ex);
+<a name="265" href="#265">265</a>               }
+<a name="266" href="#266">266</a>           }
+<a name="267" href="#267">267</a>           
+<a name="268" href="#268">268</a>           <strong>if</strong> (!gotGeneratedKeys) {
+<a name="269" href="#269">269</a>               insertStatement.close();
+<a name="270" href="#270">270</a>               insertStatement = <strong>null</strong>;
+<a name="271" href="#271">271</a>               
+<a name="272" href="#272">272</a>               idStatement = connection.createStatement();
+<a name="273" href="#273">273</a>               idStatement.setMaxRows(1);
+<a name="274" href="#274">274</a>               rs = idStatement.executeQuery(sqlDialect.getSelectInsertId());
+<a name="275" href="#275">275</a>           }
+<a name="276" href="#276">276</a>           
+<a name="277" href="#277">277</a>           <em class="comment">// A ResultSet cursor is initially positioned before the first row; the </em>
+<a name="278" href="#278">278</a>           <em class="comment">// first call to the method next makes the first row the current row</em>
+<a name="279" href="#279">279</a>           rs.next();
+<a name="280" href="#280">280</a>           <strong>int</strong> eventId = rs.getInt(1);
+<a name="281" href="#281">281</a>           
+<a name="282" href="#282">282</a>           rs.close();
+<a name="283" href="#283">283</a> 
+<a name="284" href="#284">284</a>           <em class="comment">// we no longer need the insertStatement</em>
+<a name="285" href="#285">285</a>           <strong>if</strong>(insertStatement != <strong>null</strong>) {
+<a name="286" href="#286">286</a>               insertStatement.close();
+<a name="287" href="#287">287</a>               insertStatement = <strong>null</strong>;
+<a name="288" href="#288">288</a>           }
+<a name="289" href="#289">289</a> 
+<a name="290" href="#290">290</a>           <strong>if</strong>(idStatement != <strong>null</strong>) {
+<a name="291" href="#291">291</a>               idStatement.close();
+<a name="292" href="#292">292</a>               idStatement = <strong>null</strong>;
+<a name="293" href="#293">293</a>           }
+<a name="294" href="#294">294</a> 
+<a name="295" href="#295">295</a>           Set propertiesKeys = event.getPropertyKeySet();
+<a name="296" href="#296">296</a>           
+<a name="297" href="#297">297</a>           <strong>if</strong> (propertiesKeys.size() > 0) {
+<a name="298" href="#298">298</a>               PreparedStatement insertPropertiesStatement =
+<a name="299" href="#299">299</a>                   connection.prepareStatement(insertPropertiesSQL);
+<a name="300" href="#300">300</a>               
+<a name="301" href="#301">301</a>               <strong>for</strong> (Iterator i = propertiesKeys.iterator(); i.hasNext();) {
+<a name="302" href="#302">302</a>                   String key = (String) i.next();
+<a name="303" href="#303">303</a>                   String value = (String) event.getProperty(key);
+<a name="304" href="#304">304</a>                   
+<a name="305" href="#305">305</a>                   <em class="comment">//LogLog.info("id " + eventId + ", key " + key + ", value " + value);</em>
+<a name="306" href="#306">306</a>                   insertPropertiesStatement.setInt(1, eventId);
+<a name="307" href="#307">307</a>                   insertPropertiesStatement.setString(2, key);
+<a name="308" href="#308">308</a>                   insertPropertiesStatement.setString(3, value);
+<a name="309" href="#309">309</a>                   
+<a name="310" href="#310">310</a>                   <strong>if</strong> (cnxSupportsBatchUpdates) {
+<a name="311" href="#311">311</a>                       insertPropertiesStatement.addBatch();
+<a name="312" href="#312">312</a>                   } <strong>else</strong> {
+<a name="313" href="#313">313</a>                       insertPropertiesStatement.execute();
+<a name="314" href="#314">314</a>                   }
+<a name="315" href="#315">315</a>               }
+<a name="316" href="#316">316</a>               
+<a name="317" href="#317">317</a>               <strong>if</strong> (cnxSupportsBatchUpdates) {
+<a name="318" href="#318">318</a>                   insertPropertiesStatement.executeBatch();
+<a name="319" href="#319">319</a>               }
+<a name="320" href="#320">320</a>               
+<a name="321" href="#321">321</a>               insertPropertiesStatement.close();
+<a name="322" href="#322">322</a>               insertPropertiesStatement = <strong>null</strong>;
+<a name="323" href="#323">323</a>           }
+<a name="324" href="#324">324</a>           
+<a name="325" href="#325">325</a>           String[] strRep = event.getThrowableStrRep();
+<a name="326" href="#326">326</a>           
+<a name="327" href="#327">327</a>           <strong>if</strong> (strRep != <strong>null</strong>) {
+<a name="328" href="#328">328</a>               LogLog.debug(<span class="string">"Logging an exception"</span>);
 <a name="329" href="#329">329</a>               
-<a name="330" href="#330">330</a>               <strong>for</strong> (<strong>short</strong> i = 0; i &lt; strRep.length; i++) {
-<a name="331" href="#331">331</a>                   insertExceptionStatement.setInt(1, eventId);
-<a name="332" href="#332">332</a>                   insertExceptionStatement.setShort(2, i);
-<a name="333" href="#333">333</a>                   insertExceptionStatement.setString(3, strRep[i]);
-<a name="334" href="#334">334</a>                   <strong>if</strong> (cnxSupportsBatchUpdates) {
-<a name="335" href="#335">335</a>                       insertExceptionStatement.addBatch();
-<a name="336" href="#336">336</a>                   } <strong>else</strong> {
-<a name="337" href="#337">337</a>                       insertExceptionStatement.execute();
-<a name="338" href="#338">338</a>                   }
-<a name="339" href="#339">339</a>               }
-<a name="340" href="#340">340</a>               <strong>if</strong> (cnxSupportsBatchUpdates) {
-<a name="341" href="#341">341</a>                   insertExceptionStatement.executeBatch();
+<a name="330" href="#330">330</a>               PreparedStatement insertExceptionStatement =
+<a name="331" href="#331">331</a>                   connection.prepareStatement(insertExceptionSQL);
+<a name="332" href="#332">332</a>               
+<a name="333" href="#333">333</a>               <strong>for</strong> (<strong>short</strong> i = 0; i &lt; strRep.length; i++) {
+<a name="334" href="#334">334</a>                   insertExceptionStatement.setInt(1, eventId);
+<a name="335" href="#335">335</a>                   insertExceptionStatement.setShort(2, i);
+<a name="336" href="#336">336</a>                   insertExceptionStatement.setString(3, strRep[i]);
+<a name="337" href="#337">337</a>                   <strong>if</strong> (cnxSupportsBatchUpdates) {
+<a name="338" href="#338">338</a>                       insertExceptionStatement.addBatch();
+<a name="339" href="#339">339</a>                   } <strong>else</strong> {
+<a name="340" href="#340">340</a>                       insertExceptionStatement.execute();
+<a name="341" href="#341">341</a>                   }
 <a name="342" href="#342">342</a>               }
-<a name="343" href="#343">343</a>               insertExceptionStatement.close();
-<a name="344" href="#344">344</a>               insertExceptionStatement = <strong>null</strong>;
-<a name="345" href="#345">345</a>           }
-<a name="346" href="#346">346</a>           
-<a name="347" href="#347">347</a>           connection.commit();
-<a name="348" href="#348">348</a>       } <strong>catch</strong> (Throwable sqle) {
-<a name="349" href="#349">349</a>           LogLog.error(<span class="string">"problem appending event"</span>, sqle);
-<a name="350" href="#350">350</a>       } <strong>finally</strong> {
-<a name="351" href="#351">351</a>           DBHelper.closeConnection(connection);
-<a name="352" href="#352">352</a>       }
-<a name="353" href="#353">353</a>   }
-<a name="354" href="#354">354</a> 
-<a name="355" href="#355">355</a>   <strong>public</strong> <strong>void</strong> close() {
-<a name="356" href="#356">356</a>     closed = <strong>true</strong>;
-<a name="357" href="#357">357</a>   }
-<a name="358" href="#358">358</a> 
-<a name="359" href="#359">359</a>   <em>/**<em>*</em></em>
-<a name="360" href="#360">360</a> <em>   * Returns value of the &lt;b>LocationInfo &lt;/b> property which determines whether</em>
-<a name="361" href="#361">361</a> <em>   * caller's location info is written to the database.</em>
-<a name="362" href="#362">362</a> <em>   */</em>
-<a name="363" href="#363">363</a>   <strong>public</strong> <strong>boolean</strong> getLocationInfo() {
-<a name="364" href="#364">364</a>     <strong>return</strong> locationInfo;
-<a name="365" href="#365">365</a>   }
-<a name="366" href="#366">366</a> 
-<a name="367" href="#367">367</a>   <em>/**<em>*</em></em>
-<a name="368" href="#368">368</a> <em>   * If true, the information written to the database will include caller's</em>
-<a name="369" href="#369">369</a> <em>   * location information. Due to performance concerns, by default no location</em>
-<a name="370" href="#370">370</a> <em>   * information is written to the database.</em>
-<a name="371" href="#371">371</a> <em>   */</em>
-<a name="372" href="#372">372</a>   <strong>public</strong> <strong>void</strong> setLocationInfo(<strong>boolean</strong> locationInfo) {
-<a name="373" href="#373">373</a>     <strong>this</strong>.locationInfo = locationInfo;
-<a name="374" href="#374">374</a>   }
-<a name="375" href="#375">375</a> 
-<a name="376" href="#376">376</a>     <em>/**<em>*</em></em>
-<a name="377" href="#377">377</a> <em>     * Gets whether appender requires a layout.</em>
-<a name="378" href="#378">378</a> <em>     * @return false</em>
-<a name="379" href="#379">379</a> <em>     */</em>
-<a name="380" href="#380">380</a>   <strong>public</strong> <strong>boolean</strong> requiresLayout() {
-<a name="381" href="#381">381</a>       <strong>return</strong> false;
-<a name="382" href="#382">382</a>   }
-<a name="383" href="#383">383</a> 
-<a name="384" href="#384">384</a>     <em>/**<em>*</em></em>
-<a name="385" href="#385">385</a> <em>     * @{inheritDoc}</em>
-<a name="386" href="#386">386</a> <em>     */</em>
-<a name="387" href="#387">387</a>   <strong>public</strong> <strong>boolean</strong> parseUnrecognizedElement(Element element, Properties props) throws Exception {
-<a name="388" href="#388">388</a>         <strong>if</strong> (<span class="string">"connectionSource"</span>.equals(element.getNodeName())) {
-<a name="389" href="#389">389</a>             Object instance =
-<a name="390" href="#390">390</a>                     DOMConfigurator.parseElement(element, props, ConnectionSource.<strong>class</strong>);
-<a name="391" href="#391">391</a>             <strong>if</strong> (instance instanceof ConnectionSource) {
-<a name="392" href="#392">392</a>                <a href="../../../../org/apache/log4j/db/ConnectionSource.html">ConnectionSource</a> source = (ConnectionSource) instance;
-<a name="393" href="#393">393</a>                source.activateOptions();
-<a name="394" href="#394">394</a>                setConnectionSource(source);
-<a name="395" href="#395">395</a>             }
-<a name="396" href="#396">396</a>             <strong>return</strong> <strong>true</strong>;
-<a name="397" href="#397">397</a>         }
-<a name="398" href="#398">398</a>         <strong>return</strong> false;
-<a name="399" href="#399">399</a>   }
-<a name="400" href="#400">400</a> }
+<a name="343" href="#343">343</a>               <strong>if</strong> (cnxSupportsBatchUpdates) {
+<a name="344" href="#344">344</a>                   insertExceptionStatement.executeBatch();
+<a name="345" href="#345">345</a>               }
+<a name="346" href="#346">346</a>               insertExceptionStatement.close();
+<a name="347" href="#347">347</a>               insertExceptionStatement = <strong>null</strong>;
+<a name="348" href="#348">348</a>           }
+<a name="349" href="#349">349</a>           
+<a name="350" href="#350">350</a>           connection.commit();
+<a name="351" href="#351">351</a>       } <strong>catch</strong> (Throwable sqle) {
+<a name="352" href="#352">352</a>           LogLog.error(<span class="string">"problem appending event"</span>, sqle);
+<a name="353" href="#353">353</a>       } <strong>finally</strong> {
+<a name="354" href="#354">354</a>           DBHelper.closeConnection(connection);
+<a name="355" href="#355">355</a>       }
+<a name="356" href="#356">356</a>   }
+<a name="357" href="#357">357</a> 
+<a name="358" href="#358">358</a>   <strong>public</strong> <strong>void</strong> close() {
+<a name="359" href="#359">359</a>     closed = <strong>true</strong>;
+<a name="360" href="#360">360</a>   }
+<a name="361" href="#361">361</a> 
+<a name="362" href="#362">362</a>   <em>/**<em>*</em></em>
+<a name="363" href="#363">363</a> <em>   * Returns value of the &lt;b>LocationInfo &lt;/b> property which determines whether</em>
+<a name="364" href="#364">364</a> <em>   * caller's location info is written to the database.</em>
+<a name="365" href="#365">365</a> <em>   */</em>
+<a name="366" href="#366">366</a>   <strong>public</strong> <strong>boolean</strong> getLocationInfo() {
+<a name="367" href="#367">367</a>     <strong>return</strong> locationInfo;
+<a name="368" href="#368">368</a>   }
+<a name="369" href="#369">369</a> 
+<a name="370" href="#370">370</a>   <em>/**<em>*</em></em>
+<a name="371" href="#371">371</a> <em>   * If true, the information written to the database will include caller's</em>
+<a name="372" href="#372">372</a> <em>   * location information. Due to performance concerns, by default no location</em>
+<a name="373" href="#373">373</a> <em>   * information is written to the database.</em>
+<a name="374" href="#374">374</a> <em>   */</em>
+<a name="375" href="#375">375</a>   <strong>public</strong> <strong>void</strong> setLocationInfo(<strong>boolean</strong> locationInfo) {
+<a name="376" href="#376">376</a>     <strong>this</strong>.locationInfo = locationInfo;
+<a name="377" href="#377">377</a>   }
+<a name="378" href="#378">378</a> 
+<a name="379" href="#379">379</a>     <em>/**<em>*</em></em>
+<a name="380" href="#380">380</a> <em>     * Gets whether appender requires a layout.</em>
+<a name="381" href="#381">381</a> <em>     * @return false</em>
+<a name="382" href="#382">382</a> <em>     */</em>
+<a name="383" href="#383">383</a>   <strong>public</strong> <strong>boolean</strong> requiresLayout() {
+<a name="384" href="#384">384</a>       <strong>return</strong> false;
+<a name="385" href="#385">385</a>   }
+<a name="386" href="#386">386</a> 
+<a name="387" href="#387">387</a>     <em>/**<em>*</em></em>
+<a name="388" href="#388">388</a> <em>     * @{inheritDoc}</em>
+<a name="389" href="#389">389</a> <em>     */</em>
+<a name="390" href="#390">390</a>   <strong>public</strong> <strong>boolean</strong> parseUnrecognizedElement(Element element, Properties props) throws Exception {
+<a name="391" href="#391">391</a>         <strong>if</strong> (<span class="string">"connectionSource"</span>.equals(element.getNodeName())) {
+<a name="392" href="#392">392</a>             Object instance =
+<a name="393" href="#393">393</a>                     DOMConfigurator.parseElement(element, props, ConnectionSource.<strong>class</strong>);
+<a name="394" href="#394">394</a>             <strong>if</strong> (instance instanceof ConnectionSource) {
+<a name="395" href="#395">395</a>                <a href="../../../../org/apache/log4j/db/ConnectionSource.html">ConnectionSource</a> source = (ConnectionSource) instance;
+<a name="396" href="#396">396</a>                source.activateOptions();
+<a name="397" href="#397">397</a>                setConnectionSource(source);
+<a name="398" href="#398">398</a>             }
+<a name="399" href="#399">399</a>             <strong>return</strong> <strong>true</strong>;
+<a name="400" href="#400">400</a>         }
+<a name="401" href="#401">401</a>         <strong>return</strong> false;
+<a name="402" href="#402">402</a>   }
+<a name="403" href="#403">403</a> }
 </pre>
 <hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
 </html>

Added: logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/SybaseDialect.html
URL: http://svn.apache.org/viewvc/logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/SybaseDialect.html?rev=570911&view=auto
==============================================================================
--- logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/SybaseDialect.html (added)
+++ logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/SybaseDialect.html Wed Aug 29 12:46:25 2007
@@ -0,0 +1,45 @@
+<!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=ISO-8859-1" /><title>SybaseDialect xref</title>
+<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
+</head>
+<body>
+<div id="overview"><a href="../../../../../../../../../../../../apidocs/org/apache/log4j/db/dialect/SybaseDialect.html">View Javadoc</a></div><pre>
+
+<a name="1" href="#1">1</a>   <em class="comment">/*</em>
+<a name="2" href="#2">2</a>   <em class="comment"> * Licensed to the Apache Software Foundation (ASF) under one</em>
+<a name="3" href="#3">3</a>   <em class="comment"> * or more contributor license agreements.  See the NOTICE file</em>
+<a name="4" href="#4">4</a>   <em class="comment"> * distributed with this work for additional information</em>
+<a name="5" href="#5">5</a>   <em class="comment"> * regarding copyright ownership.  The ASF licenses this file</em>
+<a name="6" href="#6">6</a>   <em class="comment"> * to you under the Apache License, Version 2.0 (the</em>
+<a name="7" href="#7">7</a>   <em class="comment"> * "License"); you may not use this file except in compliance</em>
+<a name="8" href="#8">8</a>   <em class="comment"> * with the License.  You may obtain a copy of the License at</em>
+<a name="9" href="#9">9</a>   <em class="comment"> *</em>
+<a name="10" href="#10">10</a>  <em class="comment"> *   <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em>
+<a name="11" href="#11">11</a>  <em class="comment"> *</em>
+<a name="12" href="#12">12</a>  <em class="comment"> * Unless required by applicable law or agreed to in writing,</em>
+<a name="13" href="#13">13</a>  <em class="comment"> * software distributed under the License is distributed on an</em>
+<a name="14" href="#14">14</a>  <em class="comment"> * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY</em>
+<a name="15" href="#15">15</a>  <em class="comment"> * KIND, either express or implied.  See the License for the</em>
+<a name="16" href="#16">16</a>  <em class="comment"> * specific language governing permissions and limitations</em>
+<a name="17" href="#17">17</a>  <em class="comment"> * under the License.</em>
+<a name="18" href="#18">18</a>  <em class="comment"> */</em>
+<a name="19" href="#19">19</a>  
+<a name="20" href="#20">20</a>  <strong>package</strong> org.apache.log4j.db.dialect; 
+<a name="21" href="#21">21</a>  
+<a name="22" href="#22">22</a>  <em>/**<em>* </em></em>
+<a name="23" href="#23">23</a>  <em> * The Sybase dialect. </em>
+<a name="24" href="#24">24</a>  <em> * </em>
+<a name="25" href="#25">25</a>  <em>*/</em> 
+<a name="26" href="#26">26</a>  <strong>public</strong> <strong>class</strong> <a href="../../../../../org/apache/log4j/db/dialect/SybaseDialect.html">SybaseDialect</a> implements <a href="../../../../../org/apache/log4j/db/dialect/SQLDialect.html">SQLDialect</a> { 
+<a name="27" href="#27">27</a>   <strong>public</strong> <strong>static</strong> <strong>final</strong> String SELECT_CURRVAL = <span class="string">"select @@identity"</span>; 
+<a name="28" href="#28">28</a>  
+<a name="29" href="#29">29</a>   <strong>public</strong> String getSelectInsertId() { 
+<a name="30" href="#30">30</a>     <strong>return</strong> SELECT_CURRVAL; 
+<a name="31" href="#31">31</a>   } 
+<a name="32" href="#32">32</a>  }
+</pre>
+<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
+</html>
+

Propchange: logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/SybaseDialect.html
------------------------------------------------------------------------------
    svn:mime-type = text/html

Modified: logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/package-frame.html
URL: http://svn.apache.org/viewvc/logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/package-frame.html?rev=570911&r1=570910&r2=570911&view=diff
==============================================================================
--- logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/package-frame.html (original)
+++ logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/package-frame.html Wed Aug 29 12:46:25 2007
@@ -4,7 +4,7 @@
 	<head>
 		<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
 		<title>Apache Receivers Companion for log4j 1.2. 1.1-SNAPSHOT Reference Package org.apache.log4j.db.dialect</title>
-		<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="style" />
+		<link rel="stylesheet" type="text/css" href="\.\./\.\./\.\./\.\./\.\./stylesheet.css" title="style" />
 	</head>
 	<body>
 
@@ -32,6 +32,9 @@
           	</li>
           	          	<li>
             	<a href="SQLDialect.html" target="classFrame">SQLDialect</a>
+          	</li>
+          	          	<li>
+            	<a href="SybaseDialect.html" target="classFrame">SybaseDialect</a>
           	</li>
           	          	<li>
             	<a href="Util.html" target="classFrame">Util</a>

Modified: logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/package-summary.html
URL: http://svn.apache.org/viewvc/logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/package-summary.html?rev=570911&r1=570910&r2=570911&view=diff
==============================================================================
--- logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/package-summary.html (original)
+++ logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/dialect/package-summary.html Wed Aug 29 12:46:25 2007
@@ -4,13 +4,13 @@
 	<head>
 		<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
 		<title>Apache Receivers Companion for log4j 1.2. 1.1-SNAPSHOT Reference Package $name</title>
-		<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="style" />
+		<link rel="stylesheet" type="text/css" href="\.\./\.\./\.\./\.\./\.\./stylesheet.css" title="style" />
 	</head>
 	<body>
 		      	<div class="overview">
         	<ul>
           		<li>
-            		<a href="../../../../../overview-summary.html">Overview</a>
+            		<a href="\.\./\.\./\.\./\.\./\.\./overview-summary.html">Overview</a>
           		</li>
           		<li class="selected">Package</li>
         	</ul>
@@ -18,7 +18,7 @@
       	<div class="framenoframe">
         	<ul>
           		<li>
-            		<a href="../../../../../index.html" target="_top">FRAMES</a>
+            		<a href="\.\./\.\./\.\./\.\./\.\./index.html" target="_top">FRAMES</a>
           		</li>
           		<li>
             		<a href="package-summary.html" target="_top">NO FRAMES</a>
@@ -67,6 +67,11 @@
             	</tr>
 				            	<tr>
               		<td>
+                		<a href="SybaseDialect.html" target="classFrame">SybaseDialect</a>
+              		</td>
+            	</tr>
+				            	<tr>
+              		<td>
                 		<a href="Util.html" target="classFrame">Util</a>
               		</td>
             	</tr>
@@ -76,7 +81,7 @@
 		      	<div class="overview">
         	<ul>
           		<li>
-            		<a href="../../../../../overview-summary.html">Overview</a>
+            		<a href="\.\./\.\./\.\./\.\./\.\./overview-summary.html">Overview</a>
           		</li>
           		<li class="selected">Package</li>
         	</ul>
@@ -84,7 +89,7 @@
       	<div class="framenoframe">
         	<ul>
           		<li>
-            		<a href="../../../../../index.html" target="_top">FRAMES</a>
+            		<a href="\.\./\.\./\.\./\.\./\.\./index.html" target="_top">FRAMES</a>
           		</li>
           		<li>
             		<a href="package-summary.html" target="_top">NO FRAMES</a>

Modified: logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/package-frame.html
URL: http://svn.apache.org/viewvc/logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/package-frame.html?rev=570911&r1=570910&r2=570911&view=diff
==============================================================================
--- logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/package-frame.html (original)
+++ logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/package-frame.html Wed Aug 29 12:46:25 2007
@@ -4,7 +4,7 @@
 	<head>
 		<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
 		<title>Apache Receivers Companion for log4j 1.2. 1.1-SNAPSHOT Reference Package org.apache.log4j.db</title>
-		<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="style" />
+		<link rel="stylesheet" type="text/css" href="\.\./\.\./\.\./\.\./stylesheet.css" title="style" />
 	</head>
 	<body>
 

Modified: logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/package-summary.html
URL: http://svn.apache.org/viewvc/logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/package-summary.html?rev=570911&r1=570910&r2=570911&view=diff
==============================================================================
--- logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/package-summary.html (original)
+++ logging/site/trunk/docs/log4j/companions/receivers/xref/org/apache/log4j/db/package-summary.html Wed Aug 29 12:46:25 2007
@@ -4,13 +4,13 @@
 	<head>
 		<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
 		<title>Apache Receivers Companion for log4j 1.2. 1.1-SNAPSHOT Reference Package $name</title>
-		<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="style" />
+		<link rel="stylesheet" type="text/css" href="\.\./\.\./\.\./\.\./stylesheet.css" title="style" />
 	</head>
 	<body>
 		      	<div class="overview">
         	<ul>
           		<li>
-            		<a href="../../../../overview-summary.html">Overview</a>
+            		<a href="\.\./\.\./\.\./\.\./overview-summary.html">Overview</a>
           		</li>
           		<li class="selected">Package</li>
         	</ul>
@@ -18,7 +18,7 @@
       	<div class="framenoframe">
         	<ul>
           		<li>
-            		<a href="../../../../index.html" target="_top">FRAMES</a>
+            		<a href="\.\./\.\./\.\./\.\./index.html" target="_top">FRAMES</a>
           		</li>
           		<li>
             		<a href="package-summary.html" target="_top">NO FRAMES</a>
@@ -91,7 +91,7 @@
 		      	<div class="overview">
         	<ul>
           		<li>
-            		<a href="../../../../overview-summary.html">Overview</a>
+            		<a href="\.\./\.\./\.\./\.\./overview-summary.html">Overview</a>
           		</li>
           		<li class="selected">Package</li>
         	</ul>
@@ -99,7 +99,7 @@
       	<div class="framenoframe">
         	<ul>
           		<li>
-            		<a href="../../../../index.html" target="_top">FRAMES</a>
+            		<a href="\.\./\.\./\.\./\.\./index.html" target="_top">FRAMES</a>
           		</li>
           		<li>
             		<a href="package-summary.html" target="_top">NO FRAMES</a>