|Built-in System Procedures / JAR Installation Procedures|
The SQLJ.INSTALL_JAR system procedure installs a JAR file in GemFire XD.
To use the sqlj.install_jar procedure, the JAR file path must be available on the specific GemFire XD data store to which the client is connected. If the client connects directly to a known GemFire XD server, then only that server requires the JAR file to be available at the specified path when the procedure executes. However, if the client connects using a locator then it may be connected to any available server in the distributed system. In this case, the JAR file path should be available to all members of the GemFire XD cluster (for example, from a fileshare location such as z:\) to ensure that the procedure can execute.
SQLJ.INSTALL_JAR(IN JAR_FILE_PATH VARCHAR(32672), IN QUALIFIED_JAR_NAME VARCHAR(32672), IN DEPLOY INTEGER)
z:\todays_build\tours.jarUse a file system path appropriate for the operating system (such as z:\filename.jar or /opt/filename.jar). You cannot specify a HTTP URL to use for loading the JAR file.
-- a delimited identifier MYSCHEMA."Sample2"You can use the JAR name in subsequent calls to SQLJ.REPLACE_JAR or SQLJ.REMOVE_JAR.
-- SQL statement CALL SQLJ.INSTALL_JAR('tours.jar', 'APP.Sample1', 0) -- SQL statement -- using a quoted identifier for the -- GemFire XD jar name CALL SQLJ.INSTALL_JAR('tours.jar', 'APP."Sample2"', 0)