NonStop Server for Java Programmer's Reference (NSJ 4.2+)

simplicity. Using Jolt, you can build, deploy and maintain robust, modular, and scalable
electronic commerce systems that operate over the Internet.
The Jolt product includes the JoltBeans toolkit, which provides a JavaBeans compliant interface
to Jolt for NonStop Tuxedo. The JoltBeans toolkit contains beans that wrap the existing Jolt
class library into reusable bean components, such as the JoltSessionBean or the
JoltServiceBean. These beans can be customized easily by giving application specific values to
properties and connecting them with other bean components. You can use the JoltBeans toolkit
with your Integrated Development Environment (IDE) to create Jolt clients that can access a
Tuxedo application.
The Jolt product includes the Jolt Web Application Services Toolkit, which is an extension to
the Jolt 1.1 Java class library. The Toolkit allows the Jolt client class library to be used in a
Web Server to provide an interface between HTML clients or browsers, and Tuxedo services.
For more detailed information, see TUXEDO product documentation in the NonStop Technical
Library under Independent Products.
SQLJ
Java applications that contain embedded SQL statements are known as SQLJ programs. SQLJ
Part 0 is part of the SQLJ standard that has been incorporated into the ANSI SQL-2002
standard. SQLJ supports statically compiled SQL statements in addition to dynamically
executed SQL statements in JDBC.
You can use SQLJ programs written to this standard as supported by NonStop SQL/MX. In
SQL/MX, an SQLJ program uses embedded SQL/MX statements to access an SQL/MP
database and/or an SQL/MX database.
For detailed information on using SQLJ, see the SQL/MX Programming Manual for Java in the
NonStop Technical Library, under G06 RVU publications for SQL/MX.
Stored Procedures in Java
Stored procedures in Java (SPJs) provide an efficient and secure way to implement business
logic in an SQL/MX database. They allow you to write portable applications in Java and access
an industry-standard SQL database.
A SPJ is a type of user-defined routine (UDR) that operates within a database server. A UDR
can be either a stored procedure, which does not return a value directly to the caller, or a
user-defined function, which does return a value directly to the caller. (A stored procedure
returns a value only to a host variable or dynamic parameter in its parameter list.)
In the SQL/MX database, a SPJ is a Java method contained in a Java class, registered in
SQL/MX, and invoked by SQL/MX when an application issues a CALL statement to the
method.