// From http://code.calum.org/
public static ResultSet getResult(String query) {
        Logger log = Logger.getLogger("foo");
        Connection conn = getConn();
        ResultSet   rs  = null;
        try {
            Statement st = conn.createStatement();
            //         System.out.println("Statement created");
            rs = null;
            rs = st.executeQuery(query);
            //         log.info("Query executed");
        } catch (SQLException ex) {
            log.severe(ex.toString());
        } finally {
            if ( conn != null ){
                try {
                    conn.close();
                    //                log.info("Connection closed");
                } catch (SQLException ex) {
                    log.severe(ex.toString());
                }
            }
        }