remove java

Description

Removes one or more Java-SQL classes, packages, or JARs from a database, when Java classes are installed in the database.

Syntax

remove java 
	class class_name[, class_name]...
		| package package_name[, package_name]...
		| jar jar_name[, jar_name]...[retain classes]

Parameters

class class_name

the name of one or more Java classes to be removed from the database. The classes must be installed in the current database.

package package_name

the name of one or more Java packages to be removed. The packages must be stored in the current database.

jar jar_name

either a SQL identifier or character string value of up to 30 bytes that contains a valid SQL identifier.

Each jar_name must be equal to the name of a retained JAR in the current database.

retain classes

specifies that the named JARs are no longer retained in the database, and the retained classes have no associated JAR.

Usage


Locks

Permissions

You must be a System Administrator or Database Owner to use remove java.

Auditing

Values in event and extrainfo columns of sysaudits are:

Event

Audit option

Command or access audited

Information in extrainfo

94

remove

remove java

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – NULL

  • Proxy information – Original login name, if a set proxy is in effect

See also

Documentation Java in Adaptive Server Enterprise

System procedures sp_helpjava

System tables sysjars, sysxtypes

Utilities extractjava, installjava