1.1.1

System.out.println("ResultSet 2 ends");
}
moreResults = callableStmt.getMoreResults();
} while (moreResults);
assert rowCount == cnt;
assert rowCount == 4;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void myProc(String inParam1, int[] outParam2,
ExampleObj[] example, int[] count, ResultSet[] resultSet1,
ResultSet[] resultSet2,
ProcedureExecutionContext ctx) throws SQLException {
Connection conn = ctx.getConnection();
ExampleObj obj = new ExampleObj();
obj.setValue(100);
example[0] = obj;
outParam2[0] = 200;
Statement stmt = conn.createStatement();
stmt.execute("select * from mytable");
resultSet1[0] = stmt.getResultSet();
Statement stmt3 = conn.createStatement();
stmt3 .execute("select count(*) from mytable");
stmt3.getResultSet().next();
Integer cnt = stmt3.getResultSet().getInt(1);
count[0] = cnt;
Statement stmt2 = conn.createStatement();
stmt2.execute("select count(*) from mytable");
resultSet2[0] = stmt2.getResultSet();
}
}
vFabric SQLFire User's Guide162
Developing Applications with SQLFire