SQL/MX Programming Manual for Java

SQLJ Programming
HP NonStop SQL/MX Programming Manual for Java—523726-003
3-26
Nonblocking JDBC/MX (Nowait SQL)
WHERE partnum = :partNum };
System.out.println("Updated the price of " + partNum +
" by " + percent + " percent");
ctx.close();
}
...
For the entire program, see MultiThread2.sqlj—Threads With Explicit Connection
Contexts on page C-16.
Nonblocking JDBC/MX (Nowait SQL)
Because SQLJ programs connect to a NonStop SQL database by using the JDBC/MX
driver, these programs use the multithreading and nonblocking functionality of the
JDBC/MX environment.
When nonblocking (or nowait SQL) mode is enabled, the JDBC/MX driver blocks only
the thread that invokes an SQL operation and not the whole JVM process. In
nonblocking mode, the JVM can schedule other threads concurrently while each SQL
operation is being executed by a thread.
To manage nonblocking JDBC/MX, see the JDBC Driver for SQL/MX Programmer’s
Reference.