75 lines
5.2 KiB
HTML
75 lines
5.2 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="reference" />
|
||
|
|
<meta name="DC.Title" content="SQLJ.REFRESH_CLASSES" />
|
||
|
|
<meta name="abstract" content="The SQLJ.REFRESH_CLASSES stored procedure causes the reloading of user defined classes used by Java stored procedures or Java UDFs in the current database connection. This stored procedure must be called by existing database connections to obtain changes made by a call to the SQLJ.REPLACE_JAR stored procedure." />
|
||
|
|
<meta name="description" content="The SQLJ.REFRESH_CLASSES stored procedure causes the reloading of user defined classes used by Java stored procedures or Java UDFs in the current database connection. This stored procedure must be called by existing database connections to obtain changes made by a call to the SQLJ.REPLACE_JAR stored procedure." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sqljjar.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sqljinst.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sqljremv.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sqljrplc.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sqljupdt.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sqljrcvr.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="sqljrfc" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>SQLJ.REFRESH_CLASSES</title>
|
||
|
|
</head>
|
||
|
|
<body id="sqljrfc"><a name="sqljrfc"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">SQLJ.REFRESH_CLASSES</h1>
|
||
|
|
<div><p>The SQLJ.REFRESH_CLASSES stored procedure causes the reloading
|
||
|
|
of user defined classes used by Java™ stored procedures or Java UDFs
|
||
|
|
in the current database connection. This stored procedure must be called
|
||
|
|
by existing database connections to obtain changes made by a call to the SQLJ.REPLACE_JAR
|
||
|
|
stored procedure.</p>
|
||
|
|
<div class="section"><h4 class="sectiontitle">Authorization</h4><p>NONE</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><h4 class="sectiontitle">Syntax</h4><pre>
|
||
|
|
>>-CALL--SQLJ.REFRESH_CLASSES-- ()-->
|
||
|
|
>--------------------------------------------------------------><</pre>
|
||
|
|
</div>
|
||
|
|
<div class="section"><h4 class="sectiontitle">Example</h4><p>Call a Java stored procedure, MYPROCEDURE, that
|
||
|
|
uses a class in a jar file registered with the MYJAR jarid:</p>
|
||
|
|
<pre>
|
||
|
|
CALL MYPROCEDURE()</pre>
|
||
|
|
<p>Replace the jar file using the following
|
||
|
|
call:</p>
|
||
|
|
<pre> CALL SQLJ.REPLACE_JAR('MYJAR', '/tmp/newjarfile.jar')</pre>
|
||
|
|
<p>In order for subsequence calls to the MYPROCEDURE stored procedure
|
||
|
|
to use the updated jar file, SQLJ.REFRESH_CLASSES must be called:</p>
|
||
|
|
<pre> CALL SQLJ.REFRESH_CLASSES()</pre>
|
||
|
|
<p>Call the stored procedure again.
|
||
|
|
The updated class files are used when the procedure is called.</p>
|
||
|
|
<pre> CALL MYPROCEDURE()</pre>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="sqljjar.htm" title="Both Java stored procedures and Java UDFs can use Java classes that are stored in Java JAR files.">SQLJ procedures that manipulate JAR files</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="sqljinst.htm" title="The SQLJ.INSTALL_JAR stored procedure installs a JAR file into the database system. This JAR file can be used in subsequent CREATE FUNCTION and CREATE PROCEDURE statements.">SQLJ.INSTALL_JAR</a></div>
|
||
|
|
<div><a href="sqljremv.htm" title="The SQLJ.REMOVE_JAR stored procedure removes a JAR file from the database system.">SQLJ.REMOVE_JAR</a></div>
|
||
|
|
<div><a href="sqljrplc.htm" title="">SQLJ.REPLACE_JAR</a></div>
|
||
|
|
<div><a href="sqljupdt.htm" title="The SQLJ.UPDATEJARINFO updates the CLASS_SOURCE column of the SYSJARCONTENTS catalog table. This procedure is not part of the SQLJ standard but is used by the DB2 UDB for iSeries stored procedure builder.">SQLJ.UPDATEJARINFO</a></div>
|
||
|
|
<div><a href="sqljrcvr.htm" title="The SQLJ.RECOVERJAR procedure takes the JAR file that is stored in the SYSJAROBJECTS catalog and restores it to the /QIBM/UserData/OS400/SQLLib/Function/jar/jarschema/jar_id.jar file.">SQLJ.RECOVERJAR</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|