This topic describes how to access databases using the JavaCompute node.
The broker resource manager does not coordinate database access when using type 2 or type 4 JDBC drivers, or SQLJ. Only the MbSQLStatement is fully supported. Types 2 and 4 JDBC drivers are supported, but the drivers are not provided with the broker.
MbMessage newMsg = new MbMessage(assembly.getMessage()); MbMessageAssembly newAssembly = new MbMessageAssembly(assembly, newMsg); String table = "dbTable"; MbSQLStatement state = createSQLStatement( "dbName", "SET OutputRoot.XMLNS.integer[] = PASSTHRU('SELECT * FROM " + table + "');" ); state.setThrowExceptionOnDatabaseError(false); state.setTreatWarningsAsErrors(true); state.select( assembly, newAssembly ); int sqlCode = state.getSQLCode(); if(sqlCode != 0) { // Do error handling here } getOutputTerminal("out").propagate(assembly);