sp_helpjava

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: