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

See also

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

Commands remove java

Utilities extractjava, installjava