public static ResultSet Read() throws ResponseException {
ResultSet rs = null;
PreparedStatement statement = null;
String query = "select * from unlocked;";
Connection connect = null;
CachedRowSet crs = null;
IConnection c = MiscUtil.getIConnection();
try (CachedRowSet crs2 = RowSetProvider.newFactory().createCachedRowSet()) {
connect = c.init();
statement = connect.prepareStatement(query);
rs = statement.executeQuery();
crs2.populate(rs);
crs = crs2.createCopy();
} catch (SQLException e) {
logger.error("SQL Error", e);
throw new ResponseException("SQL Error", HttpServletResponse.SC_INTERNAL_SERVER_ERROR);
} catch (ResponseException e) {
throw e;
} finally {
try {
if (statement != null) statement.close();
if (connect != null) connect.close();
} catch (SQLException e) {
logger.error("SQL Error", e);
}
}
return (crs);
}
