sp_helpjava

Description

Displays information about Java classes and associated JARs that are installed in the database.

Syntax

 sp_helpjava ["class"[, java_class_name[, “detail” | “depends”]] | 
	"jar", jar_name[, “depends”]]]

Parameters

"class" | "jar": specifies whether to display information about a class or a JAR. Both “class” and “jar” are keywords, so the quotes are required.

java_class_name: the name of the class about which you want information. The class must be a system class or a user-defined class that is installed in the database.

detail: specifies that you want to see detailed information about the class.

depends: lists all the database objects that depend on the specified class or classes in the JAR, including SQLJ functions, SQLJ stored procedures, views, Transact-SQL stored procedures, and tables.

jar_name: the name of the JAR for which you want to see information. The JAR must be installed in the database using installjava.

Examples

Example 1

Displays the names of all classes and associated JAR files installed in the database:

sp_helpjava

Example 2

Displays the name of all classes:

sp_helpjava "class"

Example 3

Displays detailed information about the Address class:

sp_helpjava "class", Address, detail

Class
-------------------------------------------------- 
Address

(1 row affected)
Class Modifiers
-------------------------------------------------- 
 public synchronized
 
 Implemented Interfaces
 -------------------------------------------------- 
 java.io.Serializable
 
 Extended Superclass
 -------------------------------------------------- 
 java.lang.Object
 
 Constructors
 -------------------------------------------------- 
 public Address()
 public Address(java.lang.String,java.lang.String)
 
 Methods
 --------------------------------------------------
 public final native java.lang.Class java.lang.Object.getClass()
 public native int java.lang.Object.hashCode()
 public boolean java.lang.Object.equals(java.lang.Object)
 public java.lang.String java.lang.Object.toString()
 public final native void java.lang.Object.notify()
 public final native void java.lang.Object.notifyAll()
 public final native void java.lang.Object.wait(long) throws
java.lang.InterruptedException
public final void java.lang.Object.wait(long,int) throws
java.lang.InterruptedException
 public final void java.lang.Object.wait() throws
java.lang.InterruptedException
 public java.lang.String Address.display()
 public void Address.removeLeadingBlanks()
 
 Fields
 -------------------------------------- 
 public java.lang.String Address.street
 public java.lang.String Address.zip

Usage

The depends parameter lists dependencies of a class or classes if the class is listed in the external name clause of a create statement for a SQLJ routine or is used as a datatype of a column in the database.

Permissions

Any user can execute sp_helpjava. Permission checks do not differ based on the granular permissions settings.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect