Product Documentation

FairCom Java Stored Procedures

Previous Topic

Next Topic

Introduction to Stored Procedures and Triggers

SQL stored procedures and triggers are an easy and powerful way to move advanced logic into your server core, protecting investments in performance-sensitive processing while maintaining a centrally managed approach for long-term maintenance. Stored procedures fully encapsulate business logic for business rule enforcement. Triggers maintain database integrity directly at the database server level.

FairCom DB SQL has long supported stored procedures, triggers, and user defined functions with Java for cross-platform development ease. In this release, stored procedures are available for your Microsoft Windows .NET development environment as well.

You can program your procedure in Java or any .NET supported language. This document focuses on Java (for C# and other .Net languages, see C# .NET Stored Procedures).

FairCom stored procedure support also includes command-line utilities for deploying stored procedures, user-defined functions, and triggers. These utilities are described in the FairCom DB SQL Stored Procedures and Triggers manual.