TheUKDave

Sometimes you should be careful about the form in which you represent your data.You should always be careful about the form in which you represent your data. And you should always try to represent it in the semantically correctly form.

In some cases you might get unexpected results (read: bugs) when you neglect to the above guidance. I've ...

read more.

The following is a perfectly reasonable method, whereby we execute a stored procedure in the database, that may well result in some changes and a result being returned.

public ResultSet myTest(Connection conn) throws Exception {
    ResultSet result = null;
    Statement stmt = conn.createStatement();

    String sql = "CALL my_stored_procedure()";

    try {
        result = stmt.executeQuery(sql);
        conn.commit();
    } catch (Exception e) {
        conn.rollback();
        throw e ...

read more.