The following table 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
		When a Type2 JDBC driver is used	When a Type4 JDBC driver is used
HP-UX	32-bit#	Y	Y
	64-bit	N	Y
	IPF	Y	Y
Solaris	32-bit#	Y	Y
	64-bit	N	Y
AIX	32-bit#	Y	Y
	64-bit	N	Y
Linux	32-bit	Y	Y
	EM64T	N	Y

Legend:

Y: Can be used.

N: Cannot be used.

#: Only the POSIX library version is supported.

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 statement (CALL statement or function invocation). Thus, there are no restrictions on the control statement description language.

The following figure 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