// From http://code.calum.org/ public static ResultSet getResult(PreparedStatement ps) { Logger log = Logger.getLogger("foo"); Connection conn = getConn(); ResultSet rs = null; try { // log.info("Executing PS " + ps.toString()); rs = ps.executeQuery(); // log.info("Executed PS"); } catch (SQLException ex) { ex.printStackTrace(); } finally { if ( conn != null ){ try { conn.close(); // log.info("Connection closed"); } catch (SQLException ex) { log.severe(ex.toString()); } } } // log.info("Returning RS"); return rs; }