SQL/MX Guide to Stored Procedures in Java (G06.24+, H06.03+)

Getting Started
HP NonStop SQL/MX Guide to Stored Procedures in Java523727-004
2-29
SPJ Policy File and Required Permissions
classes in the /usr/mydir directory, including the JAR file, add this grant statement
to the SPJ policy file:
grant codeBase "file:/usr/mydir/*" {
permission java.io.FilePermission "/usr/ossfiles",
"read,write";
};
The execution of an SQLJ class file requires system properties to be read. Because
reading system properties is a restricted operation when Java security is enabled, you
must grant all permissions to the codebases of SQLJ-based SPJs. For example, add
this grant statement to the SPJ policy file to grant all permissions to SQLJ class files in
the /usr/sqljclasses directory:
grant codeBase "file:/usr/sqljclasses/*" {
permission java.security.AllPermission;
};
If you do not grant all permissions to SQLJ-based SPJs in the SPJ policy file, attempts
to call these types of SPJs fail.
For information about policy file syntax and Java security, see the Sun Microsystems
Java documentation.