You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ch...@apache.org on 2008/04/18 22:19:04 UTC
svn commit: r649681 - /db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita
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>