Documentation

SQL Operations Guide

Previous Topic

Next Topic

Run-Time Settings for Java Stored Procedure Support

FairCom DB SQL requires the Java 1.7 JDK and JRE environment for Stored Procedures, Triggers, and User Defined Functions (UDFs), JDBC, and c-treeDB API Java (FairCom DB SQL V11.0 requires 1.6 or newer). Java is readily available from the Oracle Java downloads website. FairCom DB supports Java on any platform that the Java environment is currently available, including Windows, AIX, Oracle Sun, and Linux.

Check with FairCom for the latest Java compatibility announcements and availability of the latest Java support.

Windows users, see Using Java 1.7 or Later on Windows.

The Java JDK and JRE for many platforms are available at no cost. Click here to download.

Note: 64-bit versions of FairCom DB SQL require a 64-bit version of the JVM to implement stored procedures.

FairCom DB SQL Configuration

Use the following FairCom Server configuration keywords to set your Java environment to take advantage of full stored procedures, triggers, and user-defined functions support.

; JDK environment settings - Be sure to set the JDK to your version.

SETENV CLASSPATH=C:\Program Files\Java\jdk1.7.0_07\jre\lib\rt.jar;C:\FairCom\VX.X.X\win32\bin\ace\sql\classes\ctreeSQLSP.jar (where VX.X.X refers to your FairCom DB version number)

SETENV JVM_LIB=C:\Program Files\Java\jdk1.7.0_07\jre\bin\server\jvm.dll

SETENV JAVA_COMPILER=C:\Program Files\Java\jdk1.7.0_07\bin\javac.exe

The following table lists the Java-related runtime settings needed for the FairCom DB SQL to support Stored Procedures, Triggers and User-Defined Functions. These are required for initializing the JVM within FairCom DB SQL.

Java Related Runtime Settings FairCom DB SQL with JSP

Environment Variable Name

Environment Variable Value

JDKHOME

DRIVE:\PATH_TO_JAVA\

CTREEHOME

DRIVE:\PATH_TO_CTREE\

CLASSPATH

%JDKHOME%\jre\lib\rt.jar;

%CTREEHOME%\ctreeSDK\ctreeAPI\bin.jql\classes

JVM_LIB

%JDKHOME%\jre\bin\server\jvm.dll

JAVA_COMPILER

%JDKHome%\bin\javac.exe

TOCIndex