How to Write Java Stored Function/Procedure

Steps to write a Java stored function/procedure are as follows:

1. Check the cubrid.conf file
2. Write and compile the Java source code
3. Load the complied Java class into CUBRID
4. Publish the loaded Java class
5. Call the Java stored function/procedure

Check the cubrid.conf file

By default, the java_stored_procedure is set to no in the cubrid.conf file. To use a Java stored function/procedure, this value must be changed to yes. For more information on this value, see Other Parameters in Database Server Configuration.

Write and compile the Java source code

Compile the SpCubrid.java file as follows:

public class SpCubrid{

      public static String HelloCubrid() {

              return "Hello, Cubrid !!";

      }

      public static int SpInt(int i) {

              return i + 1;

      }

      public static void outTest(String[] o) {

              o[0] = "Hello, CUBRID";

      }

}

%javac SpCubrid.java

Here, the Java class method must be public static.

Load the compiled Java class into CUBRID

Load the compiled Java class into CUBRID.

% loadjava demodb SpCubrid.class

Publish the loaded Java class

Create a CUBRID stored function and publish the Java class as shown below.

csql> create function hello() return string

csql> as language java

csql> name 'SpCubrid.HelloCubrid() return java.lang.String';

csql> ;xrun

Call the Java stored function/procedure

Call the published Java stored function as follows:

csql> call hello() into :Hello;

csql> ;xrun

=== < Result of CALL Command in Line 1> ===

 Result

======================

'Hello, Cubrid !!'