NonStop Systems Introduction for H-Series RVUs

The Relational Database Management System
NonStop Systems Introduction for H-Series RVUs—540083-001
4-9
SQL/MX and Applications
SQL/MX automatically binds the host language portion and the SQL language portion
of the program into a single object file. The program is ready for use in a production
environment.
The Java Database Connectivity (JDBC) API provides universal data access for the
Java programming language. The JDBC API consists of a set of classes and interfaces
written in Java that provide a standard API for application developers. Using the JDBC
API, Java programs can directly query an SQL/MX database. JDBC is included as a
component of NonStop EJB. To compile a Java source program containing JDBC
method calls of SQL statements, run the Java programming language compiler.
SQL/MX compiles the SQL statements at run time.
Because the Java language is powerful and easy to use, it is an excellent choice for
database applications. JDBC makes it possible to write robust database applications
using a Java-based API. JDBC is also highly portable, being able to access virtually
any type of database.
SQL/MX and Applications
The SQL/MX programming interface makes it possible for programmers to include SQL
statements in applications. Specifically, programmers can embed SQL statements in
server programs written in COBOL, C, C++, and Java. As a result, the servers can
access SQL/MX tables and select, insert, update, or delete rows in these tables.
Figure 4-5 shows the relationship between applications and SQL/MX in the NonStop
application environment.
You can develop applications without using SQL/MX, and you can develop SQL/MX
applications that do not run under control of an application server environment (such
as the NonStop CORBA, NonStop Tuxedo, or WebLogic Server environment).
However, the combination of flexibility in managing servers provided by the application
server environments and speed in accessing the database provided by SQL/MX
delivers extremely efficient performance in the production environment.
Workstation Access to SQL/MX
HP offers products that provide open access to SQL/MX. These products enable users
to submit database requests directly from a workstation. One of these products is the
Figure 4-5. SQL/MX in Database Applications
The server program
contains SQL/MX
statements.
Client
program
Server
program
VST048.vsd