db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r649683 - /db/derby/docs/branches/10.4/src/ref/rrefemptystmtcache.dita
Date Fri, 18 Apr 2008 20:32:34 GMT
Author: chaase3
Date: Fri Apr 18 13:32:30 2008
New Revision: 649683

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

Merged DERBY-3622-2.diff to 10.4 docs branch from trunk revision 649681.

Modified:
    db/derby/docs/branches/10.4/src/ref/rrefemptystmtcache.dita

Modified: db/derby/docs/branches/10.4/src/ref/rrefemptystmtcache.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.4/src/ref/rrefemptystmtcache.dita?rev=649683&r1=649682&r2=649683&view=diff
==============================================================================
--- db/derby/docs/branches/10.4/src/ref/rrefemptystmtcache.dita (original)
+++ db/derby/docs/branches/10.4/src/ref/rrefemptystmtcache.dita Fri Apr 18 13:32:30 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