db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r649681 - /db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita
Date Fri, 18 Apr 2008 20:19:04 GMT
Author: chaase3
Date: Fri Apr 18 13:19:03 2008
New Revision: 649681

URL: http://svn.apache.org/viewvc?rev=649681&view=rev
Log:
DERBY-3622: SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference
manual

Documented procedure based on information in DERBY-2914.

Patch: DERBY-3622-2.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita

Modified: db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita?rev=649681&r1=649680&r2=649681&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita Fri Apr 18 13:19:03 2008
@@ -22,8 +22,18 @@
 <title>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure</title>
 <refbody>
 <section><p>The <codeph>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE</codeph>
stored
-procedure is a useful diagnostic tool.</p></section>
-<section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()</codeblock></section>
-<section><title>Example</title><codeblock>CALL SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()</codeblock></section>
+procedure removes as many compiled statements (plans) as possible from the
+database-wide statement cache. The procedure does not remove statements related
+to currently executing queries or to activations that are about to be garbage
+collected, so the cache is not guaranteed to be completely empty after a call
+to this procedure.</p></section>
+<section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()</codeblock>
+</section>
+<section><title>JDBC Example</title>
+<codeblock>CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()");
+cs.execute();
+cs.close();</codeblock></section>
+<section><title>SQL Example</title><codeblock>CALL SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE();</codeblock></section>
 </refbody>
 </reference>



Mime
View raw message