@Override public String getpages() throws Exception { if (this.checkpermission("getpages")) { int intRegsPerPag = ParameterCook.prepareRpp(oRequest); ArrayList<FilterBeanHelper> alFilter = ParameterCook.prepareFilter(oRequest); String data = null; Connection oConnection = null; ConnectionInterface oDataConnectionSource = null; try { oDataConnectionSource = getSourceConnection(); oConnection = oDataConnectionSource.newConnection(); EstadoDao oEstadoDao = new EstadoDao(oConnection); data = JsonMessage.getJson( "200", Integer.toString(oEstadoDao.getPages(intRegsPerPag, alFilter))); } catch (Exception ex) { ExceptionBooster.boost( new Exception(this.getClass().getName() + ":getPages ERROR: " + ex.getMessage())); } finally { if (oConnection != null) { oConnection.close(); } if (oDataConnectionSource != null) { oDataConnectionSource.disposeConnection(); } } return data; } else { return JsonMessage.getJsonMsg("401", "Unauthorized"); } }