INSTALL statement
556
INSTALL statement
Use this statement to make Java classes available for use within a database.
INSTALL JAVA
[ NEW | UPDATE ]
[ JAR
jar-name
]
FROM { FILE
filename
|
expression
}
DBA permissions are required to execute the INSTALL statement.
All installed classes can be referenced in any way by any user.
Not supported on Windows CE.
"REMOVE statement" on page 589
The class definition for each class is loaded by each connection’s VM the
first time that class is used. When you INSTALL a class, the VM on your
connection is implicitly restarted. Therefore, you have immediate access to
the new class, whether the INSTALL has an install-mode of NEW or
UPDATE. Because the VM is restarted, any values stored in java static
variables are lost, and any SQL variables with java class types are dropped.
For other connections, the new class is loaded the next time a VM accesses
the class for the first time. If the class is already loaded by a VM, that
connection does not see the new class until the VM is restarted for that
connection (for example, with a STOP JAVA and START JAVA).
NEW | UPDATE keyword If you specify an install mode of NEW, the
referenced Java classes must be new classes, rather than updates of currently
installed classes. An error occurs if a class with the same name exists in the
database and the NEW install mode is used.
If you specify UPDATE, the referenced Java classes may include
replacements for Java classes that are already installed in the given database.
If install-mode is omitted, the default is NEW.
JAR clause If this is specified, then the filename must designate a jar file.
Jar files typically have extensions of
.jar
or
.zip
.
Installed jar and zip files can be compressed or uncompressed.
If the JAR option is specified, the jar is retained as a jar after the classes that
it contains have been installed. That jar is the associated jar of each of those
classes. The jars installed in a database with the JAR option are called the
retained jars of the database.
Function
Syntax
Permissions
See also
Description
Parameters
To Next Page
Loading...