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.