Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

2. Open the Schemas folder, and navigate to the schema that contains the SPJ that you want
to drop from the Neoview database.
3. Open the schema folder, and then open the Procedures folder.
4. Click the procedure that you want to drop and then right-click the procedure and then select
Drop:
5. When prompted to drop the procedure, click Yes to continue or No to quit the operation:
The procedure is dropped from the Neoview database and no longer appears in the
Procedures folder.
Altering an SPJ and Its Java Bytecode
Occasionally, you might need to update an SPJ or its Java bytecode. The Java bytecode includes
the SPJ's class file and any associated class files that are packaged in the SPJ JAR file. Suppose
that you want to update the Java bytecode of an SPJ without changing the class name, method
name, or Java signature of the SPJ method. In this case, you would upload a new JAR file and
overwrite the original JAR file on the Neoview platform. For more information, see “Uploading
SPJ JAR Files to the Neoview Platform” (page 35).
If you upload a JAR file that contains an SPJ method that has a different class name, method
name, or signature than the original SPJ method, you must drop the SPJ from the database before
uploading the JAR file. After uploading the JAR file, re-create the SPJ in the database. You must
also drop and re-create an SPJ to rename the procedure or change the SQL parameter definitions
even if the Java bytecode remains the same. For more information, see “Dropping SPJs” (page 49)
and “Creating SPJs” (page 43).
When you update an SPJ or its Java bytecode, try to avoid making those changes when client
applications are actively calling the SPJ. If you update an SPJ or its Java bytecode when a client
application is calling the SPJ, the CALL statement might return wrong or inconsistent data to
the calling application. Therefore, schedule a time to update the SPJ or its Java bytecode when
client applications are not actively calling the SPJ.
50 Creating SPJs in a Neoview Database