sqlj.replace

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > EXECUTE PROCEDURE >

sqlj.replace_jar

Use the sqlj.replace_jar( ) procedure to replace a previously installed jar file with a new version. When you use this syntax, you provide only the new jar file and assign it to the jar ID for which you want to replace the file.

sqlj.replace_jar:
 
                                                  (1)
|--sqlj.replace_jar--(--jar_file--,--| Jar Name |-------)-------|

Notes:

See Jar Name

Element	Description	Restrictions	Syntax
jar_file	URL of the jar file that contains the UDR written in Java	The maximum length of the URL is 255 bytes	Quoted String

If you attempt to replace a jar file that is referenced by one or more UDRs, the database server generates an error. You must drop the referencing UDRs before replacing the jar file.

For example, the following call replaces the Courses.jar file, which had previously been installed for the course_jar identifier, with the Subjects.jar file:

EXECUTE PROCEDURE 
   sqlj.replace_jar("file://students/data/Subjects.jar",
   "course_jar")

Before you replace the Course.jar file, you must drop the user-defined function sql_explosive_reaction( ) with the DROP FUNCTION (or DROP ROUTINE) statement.