SQLJ.REPLACE_JAR system procedure The SQLJ.REPLACE_JAR system procedure replaces a jar file in a database. SQLJ.REPLACE_JAR system procedure system proceduresSQLJ.REPLACE_JAR jar filesreplacing in databases
Syntax SQLJ.REPLACE_JAR(IN JAR_FILE_PATH_OR_URL VARCHAR(32672), IN QUALIFIED_JAR_NAME VARCHAR(32672))
JAR_FILE_PATH_OR_URL
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: d:/todays_build/tours.jar
QUALIFIED_JAR_NAME
The name of the jar file, qualified by the schema name. Two examples: MYSCHEMA.Sample1 -- a delimited identifier. MYSCHEMA."Sample2"
Execute privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this procedure by default. See "Enabling user authentication" and "Setting the SQL standard authorization mode" in the for more information. The database owner can grant access to other users.

SQL example -- SQL statement CALL sqlj.replace_jar('c:\myjarfiles\newtours.jar', 'APP.Sample1') -- SQL statement -- replace jar from remote location CALL SQLJ.REPLACE_JAR('http://www.example.com/tours.jar', 'APP.Sample2')