SQL/MX Programming Manual for Java

Sample Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
C-17
SQLJ Source File
catch (SQLException se) {
System.err.println("SQL exception: " + se);
}
catch (Exception e) {
System.err.println("Exception: " + e);
}
}
//Overriding the run() method
public void run() {
try {
//Loading the JDBC/MX driver and creating a
//JDBC connection
Class.forName("com.tandem.sqlmx.SQLMXDriver");
Connection conn =
DriverManager.getConnection("jdbc:sqlmx:");
//Instantiating an explicit connection context object
//by using the JDBC connection
SQLMXCtx ctx = new SQLMXCtx(conn);
#sql [ctx] { MODULE samdbcat.sales.mt2ctxmod };
#sql [ctx] { UPDATE samdbcat.sales.parts
SET price = price * (1 + (:percent/100))
WHERE partnum = :partNum };
System.out.println("Updated the price of " + partNum +
" by " + percent + " percent");
ctx.close();
}
catch (SQLException se) {
System.err.println("Error updating part number " + partNum
+ ": " + se);
}
catch (Exception e) {
System.err.println("Exception " + e);
}
}
//Method that shows all part numbers and their prices in the
//PARTS table
static void showPrices()
throws SQLException {
PartsPricesIter2 iter;
#sql iter = {SELECT partnum, price
FROM samdbcat.sales.parts};
while (iter.next()) {
System.out.println("Part number: " + iter.partnum() + " "
+ "price: " + iter.price());
}
iter.close();
}
}
Example C-4. MultiThread2.sqlj—Threads With Different Connection
Contexts (page2of2)