Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

Setting Up Your Environment to Write Stored Procedures

Before you create stored procedures, you need to have a Java development environment running on your system. FairCom DB SQL stored procedures support the following environments:

  • On Unix and Windows XP/2003/Vista: Oracle JDK (previously known as "JavaSoft JDK™") Version 1.5

Specific FairCom DB SQL configuration options set the environment related paths required to enable stored procedure support.

Java Related Configuration Options

Configuration Option
(ctsrvr.cfg)

Example Configuration (Windows)

SETENV CLASSPATH

SETENV CLASSPATH=C:\Program Files\Java\jdk1.6.0_13\jre\lib\rt.jar;C:\FairCom\V9.1.0\win32\bin\ace\sql\classes\ctreeSQLSP.jar

SETENV JVM_LIB

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

SETENV JAVA_COMPILER

SETENV JAVA_COMPILER=C:\Program Files\Java\jdk1.6.0_13\bin\javac.exe

Note: The JAVA_COMPILER configuration option is only required to submit and compile stored procedures. It is not necessary to specify this option for calling and executing already compiled procedures.

TOCIndex