SQLJ.REPLACE_JAR

The SQLJ.REPLACE_JAR system procedure replaces a jar file in a database.

For more information about using JAR files, see the Using Functions and Stored Procedures section in our Developer’s Guide.

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 Splice Machine name of the jar file, qualified by the schema name. Two examples:

MYSCHEMA.Sample1
  -- a delimited identifier.
MYSCHEMA."Sample2"

Results

This procedure does not return a result.

Execute Privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.

SQL Example

   -- SQL statement
CALL sqlj.replace_jar('c:\myjarfiles\newtours.jar', 'SPLICE.Sample1');

   -- SQL statement
   -- replace jar from remote location
CALL SQLJ.REPLACE_JAR('http://www.example.com/tours.jar', 'SPLICE.Sample2');

See Also