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 2011/08/02 16:03:48 UTC
svn commit: r1153132 - in /db/derby/docs/branches/10.8/src/ref: rrefstorejarinstall.dita rrefstorejarreplace.dita

Author: chaase3
Date: Tue Aug  2 14:03:48 2011
New Revision: 1153132

URL: http://svn.apache.org/viewvc?rev=1153132&view=rev
Log:
DERBY-5361  Document use of URLs with SQLJ.INSTALL_JAR

Merged DERBY-5361-2.diff to 10.8 docs branch from trunk revision 1153117.

Modified:
    db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita
    db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita

Modified: db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita?rev=1153132&r1=1153131&r2=1153132&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita Tue Aug  2 14:03:48 2011
@@ -29,12 +29,14 @@ The SQLJ.INSTALL_JAR system procedure st
 </keywords></metadata></prolog>
 <refbody>
 <section><title>Syntax</title>
-<codeblock>SQLJ.INSTALL_JAR(IN JAR_FILE_PATH VARCHAR(32672), 
+<codeblock>SQLJ.INSTALL_JAR(IN JAR_FILE_PATH_OR_URL VARCHAR(32672), 
                  IN QUALIFIED_JAR_NAME VARCHAR(32672),
                  IN DEPLOY INTEGER)</codeblock>
 <dl>
-<dlentry><dt>JAR_FILE_PATH</dt>
-<dd>The path and physical name of the jar file to add. For example:
+<dlentry><dt>JAR_FILE_PATH_OR_URL</dt>
+<dd>The path or URL of the jar file to add. A path includes both the directory
+and the file name (unless the file is in the current directory, in which case
+the directory is optional). For example:
 <codeblock>d:/todays_build/tours.jar</codeblock>
 </dd>
 </dlentry>
@@ -62,13 +64,22 @@ authentication" and "Setting the SQL sta
 database owner can grant access to other users.</p>
 </section>
 <section><title>SQL examples</title>
-<codeblock><b>-- SQL statement</b>
+<codeblock><b>-- SQL statement
+-- install jar from current directory</b>
 CALL SQLJ.INSTALL_JAR('tours.jar', 'APP.Sample1', 0)
 
 <b>-- SQL statement
--- using a quoted identifier for the 
+-- install jar using full path</b>
+CALL SQLJ.INSTALL_JAR('c:\myjarfiles\tours.jar', 'APP.Sample1', 0)
+
+<b>-- SQL statement
+-- install jar from remote location</b>
+CALL SQLJ.INSTALL_JAR('http://www.example.com/tours.jar', 'APP.Sample2', 0)
+
+<b>-- SQL statement
+-- install jar using a quoted identifier for the 
 -- <ph conref="../conrefs.dita#prod/productshortname"></ph> jar name</b>
-CALL SQLJ.INSTALL_JAR('tours.jar', 'APP."Sample2"', 0)</codeblock>
+CALL SQLJ.INSTALL_JAR('tours.jar', 'APP."Sample3"', 0)</codeblock>
 </section>
 </refbody>
 </reference>

Modified: db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita?rev=1153132&r1=1153131&r2=1153132&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita Tue Aug  2 14:03:48 2011
@@ -29,12 +29,13 @@ The SQLJ.REPLACE_JAR system procedure re
 </keywords></metadata></prolog>
 <refbody>
 <section><title>Syntax</title>
-<codeblock>SQLJ.REPLACE_JAR(IN JAR_FILE_PATH VARCHAR(32672), 
+<codeblock>SQLJ.REPLACE_JAR(IN JAR_FILE_PATH_OR_URL VARCHAR(32672), 
                  IN QUALIFIED_JAR_NAME VARCHAR(32672))</codeblock>
 <dl>
-<dlentry><dt>JAR_FILE_PATH</dt>
-<dd>The path and physical name of the jar file to use as a replacement. For
-example:
+<dlentry><dt>JAR_FILE_PATH_OR_URL</dt>
+<dd>The path or URL of the jar file to use as a replacement. A path includes
+both the directory and the file name (unless the file is in the current
+directory, in which case the directory is optional). For example:
 <codeblock>d:/todays_build/tours.jar</codeblock></dd>
 </dlentry>
 <dlentry><dt>QUALIFIED_JAR_NAME</dt>
@@ -57,7 +58,11 @@ database owner can grant access to other
 </section>
 <section><title>SQL example</title>
 <codeblock><b>-- SQL statement</b>
-CALL sqlj.replace_jar('c:\myjarfiles\newtours.jar', 'APP.Sample1')</codeblock>
+CALL sqlj.replace_jar('c:\myjarfiles\newtours.jar', 'APP.Sample1')
+
+<b>-- SQL statement
+-- replace a jar at a remote location</b>
+CALL SQLJ.REPLACE_JAR('http://www.example.com/tours.jar', 'APP.Sample2')</codeblock>
 </section>
 </refbody>
 </reference>