@POST @Path(DataBaseTaskResource.GET_COLUMNS_URI) @Consumes(MediaType.APPLICATION_JSON) @Produces(MediaType.APPLICATION_JSON) public Response getColumns(TableQueryRequest requestWS) throws TCCWebServiceException { TableVO tableVO = null; try { final DatabaseTaskService dbTaskService = ServiceLocator.getServiceInstance( ServiceBuilder.DATABASE_TASK_SERVICE, DatabaseTaskService.class); if (requestWS != null) { LOGGER.debug("Getting column for table[" + requestWS.getTable() + "]."); tableVO = dbTaskService.getColumnsFromTable(requestWS); } else { LOGGER.debug("Parameters to get columns for table are invalid."); return Response.status(Status.BAD_REQUEST).build(); } } catch (TCCBusinessException tbe) { throw new TCCWebServiceException(tbe.getMessage()); } catch (TCCTechnicalException tte) { throw new TCCWebServiceException(tte.getMessage()); } return Response.status(200).entity(tableVO).build(); }
@POST @Path(DataBaseTaskResource.GET_DB_INFO_URI) @Produces(MediaType.APPLICATION_JSON) public Response getTableDetails() throws TCCWebServiceException { List<SchemaVO> schemaVOList = null; try { final DatabaseTaskService dbTaskService = ServiceLocator.getServiceInstance( ServiceBuilder.DATABASE_TASK_SERVICE, DatabaseTaskService.class); LOGGER.info("Getting table details to start application"); schemaVOList = dbTaskService.getInitialLoad(); } catch (TCCBusinessException tbe) { throw new TCCWebServiceException(tbe.getMessage(), tbe); } catch (TCCTechnicalException tte) { throw new TCCWebServiceException(tte.getMessage(), tte); } return Response.status(200).entity(schemaVOList).build(); }