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

Permissions

Any user can execute sp_helpjava.

See also

Documents See Java in Adaptive Server Enterprise for more information about Java in the database.

Commands remove java

Utilities extractjava, installjava