This section provides an overview of Java stored procedures and Java stored functions.
Table 17-1 shows the environments in which Java stored procedures and Java stored functions can be used.
Table 17-1 Environments in which Java stored procedures and Java stored functions can be used
OS | Usable | Remarks |
---|---|---|
HP-UX | Y | Can be used in either of the following environments:
|
Solaris | Y | Can be used in the following environment:
|
AIX 5L | Y | |
Linux | Y | Can be used in the following environments
|
Java stored procedures and Java stored functions are stored procedures and stored functions in which the type of routine control statements that can be described in SQL are instead written in Java. Java stored procedures and Java stored functions use Java methods created externally to HiRDB. Because these methods are registered into HiRDB as routine control statements, it is possible to perform platform-independent processing, development, and debugging.
As with stored procedures and stored functions described in SQL, Java stored procedures and Java stored functions can be called from an SQL (CALL statement or function invocation). Thus, there are no restrictions on the control statement description language.
Figure 17-1 shows the actions (invocation procedures) of Java stored procedures and Java stored functions.
Figure 17-1 Actions (invocation procedures) of Java stored procedures and Java stored functions