FairCom Java & .NET Stored Procedures

Java Stored Procedures, Triggers, and UDFs

The FairCom DB SQL implementation of stored procedures allows use of standard Java programming constructs instead of requiring proprietary flow-control language. To do this, the FairCom DB SQL interacts with Java in the following ways:

• When you create a stored procedure, FairCom DB SQL processes the Java code, submits it to the Java compiler, and receives the compiled results to store in the database.
• When applications call a stored procedure, FairCom DB SQL interacts with the Java virtual machine (JRE) to execute the stored procedure and receive any results.

In This Chapter Creating Stored Procedures Calling Stored Procedures LVARCHAR Fields Allowed in Stored Procedure Code Java Stored Procedures and Triggers Require JDK V1.7 or Newer SQL Stored Procedures - Close cursors that were left open Java Quick Tour Throw Custom Error Message on Stored Procedure or UDF Exception Java Class Reference Using FairCom DB SQL Java Classes Debugging Java Stored Procedures Using Java Stored Procedures Using Triggers Using User-Defined Scalar Functions