Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

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

NetBeans Plugin for Java

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

TOCIndex