Scalable Database Server, HiRDB Version 8 Description
A Java stored routine has the following characteristics:
- Absence of overhead between server and client
As in the case of SQL stored procedures and SQL stored functions, Java stored routines are processed at the server, which eliminates communications overhead between server and client.
- Ability to code the procedure or function itself in Java
The Java coding language provides more sophisticated control than is possible with SQL.
- Ability to operate between dissimilar DBMSs
Because Java is a platform-independent language, programs coded in Java can operate on dissimilar DBMSs that support Java stored routines.
- Simple debugging
The debugging of an SQL stored procedure or an SQL stored function requires actual execution at the server of the procedure or function. By contrast, Java stored routines can be debugged by providing a Java debugger at the client; moreover, this debugging process can address database access operations as well.
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.