Removing Opaque Types and JAR Files

Home | Previous Page | Next Page Working with Opaque Types > Creating Opaque Types and UDRs >

Removing Opaque Types and JAR Files

You can remove opaque types and their JAR files using the following methods:

public static void removeUDT(String sqlname) throws SQLException
public static void removeJar(String jarfilesqlname, int undeploy) 
   throws SQLException

The removeUDT() method removes the opaque type, with all its casts and UDRs, from the database server. It does not remove the JAR file itself because other opaque types or UDRs could be using the same JAR file.

Important:

If your application calls removeUDT() within a transaction or if your database is ANSI or enables logging, some extra guidelines apply. For more information, see Executing in a Transaction.

The removeJar() method removes the JAR file from the system catalog. The jarfilesqlname parameter is the name you specified with the setJarFileSQLName() method.

For the undeploy parameter, see Specifying Deployment Descriptor Actions.

Important:

Before calling removeJar(), you must first remove all functions and procedures that depend on the JAR file. Otherwise, the database server fails to remove the file.