FairCom Java & .NET Stored Procedures

Using Java Stored Procedures

This chapter describes basic stored procedure operations (such as creating and deleting) and provides a tutorial on using supplied FairCom DB SQL classes. See Java Class Reference for detailed reference information on the classes and their methods.

Stored procedures extend the SQL capabilities of a database by adding control flow through Java program constructs that enforce business rules and perform administrative tasks.

Stored procedures can take advantage of the power of Java programming features. Stored procedures can:

• Receive and return input and output parameters
• Handle exceptions
• Include any number and kind of SQL statements to access the database
• Return a procedure result set to the calling application
• Make calls to other procedures
• Use predefined and external Java classes

FairCom DB SQL provides support for SQL statements in Java through several classes. The following table summarizes the functionality of these FairCom DB SQL - supplied classes. (See Java Class Reference for detailed reference information.)

Summary of FairCom DB SQL Java Classes

Functionality	FairCom DB SQL Java Class
Immediate (one-time) execution of FairCom DB SQL statements	SQLIStatement
Prepared (repeated) execution of FairCom DB SQL statements	SQLPStatement
Retrieval of FairCom DB SQL result sets	SQLCursor
Returning a procedure result set to the application	DhSQLResultSet
Exception handling for FairCom DB SQL statements	DhSQLException

In This Chapter Stored Procedure Basics