List of usage examples for org.springframework.transaction.support DefaultTransactionDefinition DefaultTransactionDefinition
public DefaultTransactionDefinition()
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView deleteTargetList(HttpServletRequest request, HttpServletResponse response) throws ServletException { String retMsg = "{success:false}"; //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {// w w w. j a va 2s . c om if (!StringUtil.isNullOrEmpty(request.getParameter("jsondata"))) { String jsondata = request.getParameter("jsondata"); JSONArray jarr = new JSONArray("[" + jsondata + "]"); for (int i = 0; i < jarr.length(); i++) { String listid = jarr.getJSONObject(i).getString("listid"); HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("mode", 2); requestParams.put("listid", listid); KwlReturnObject kmsg = crmEmailMarketingDAOObj.saveTargetListTargets(requestParams); HashMap<String, Object> subRequestParams = new HashMap<String, Object>(); ArrayList filter_names = new ArrayList(); ArrayList filter_params = new ArrayList(); filter_names.add("deleted"); filter_params.add(0); filter_names.add("targetlist.id"); filter_params.add(listid); subRequestParams.put("filter_names", filter_names); subRequestParams.put("filter_params", filter_params); subRequestParams.put("allflag", true); KwlReturnObject subkmsg = crmEmailMarketingDAOObj.getCampaignTarget(subRequestParams); Iterator ite = subkmsg.getEntityList().iterator(); while (ite.hasNext()) { CampaignTarget ct = (CampaignTarget) ite.next(); JSONObject jObj = new JSONObject(); jObj.put("camptargetid", ct.getId()); jObj.put("deleted", 1); crmEmailMarketingDAOObj.editCampaignTarget(jObj); } } } retMsg = "{success:true}"; txnManager.commit(status); } catch (ServiceException e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } catch (Exception e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } return new ModelAndView("jsonView", "model", retMsg); }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView assignManager(HttpServletRequest request, HttpServletResponse response) { KwlReturnObject result = null;//from w w w . j a v a2 s. c om List tabledata = null; String[] userids = request.getParameterValues("userid"); String[] reviewerids = request.getParameterValues("reviewerid"); String[] managerids = request.getParameterValues("managerid"); String[] availmanagerid = request.getParameterValues("availmanagerid"); JSONObject jobj = new JSONObject(); //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try { HashMap<String, Object> requestParams = new HashMap<String, Object>(); if (Boolean.parseBoolean(request.getParameter("isManager"))) { for (int i = 0; i < userids.length; i++) { requestParams.put("filter_names", Arrays.asList("assignemp.userID", "managerstatus")); requestParams.put("filter_values", Arrays.asList(userids[i], 1)); result = hrmsCommonDAOObj.getAssignmanager(requestParams); tabledata = result.getEntityList(); Iterator ite = tabledata.iterator(); while (ite.hasNext()) { Assignmanager log = (Assignmanager) ite.next(); requestParams.clear(); requestParams.put("Id", log.getId()); requestParams.put("Managerstatus", 0); hrmsCommonDAOObj.addAssignmanager(requestParams); } } for (int i = 0; i < userids.length; i++) { for (int j = 0; j < managerids.length; j++) { requestParams.clear(); requestParams.put("Assignemp", userids[i]); requestParams.put("Assignman", managerids[j]); requestParams.put("Managerstatus", 1); hrmsCommonDAOObj.addAssignmanager(requestParams); } } } else if (Boolean.parseBoolean(request.getParameter("salaryManagerF"))) { hrmsCommonDAOObj.addAssignSalaryManager(managerids, availmanagerid); } else { for (int i = 0; i < userids.length; i++) { requestParams.clear(); requestParams.put("filter_names", Arrays.asList("employee.userID", "reviewerstatus")); requestParams.put("filter_values", Arrays.asList(userids[i], 1)); result = hrmsCommonDAOObj.getAssignreviewer(requestParams); tabledata = result.getEntityList(); Iterator ite = tabledata.iterator(); while (ite.hasNext()) { Assignreviewer log = (Assignreviewer) ite.next(); requestParams.clear(); requestParams.put("Id", log.getId()); requestParams.put("Reviewerstatus", 0); hrmsCommonDAOObj.addAssignreviewer(requestParams); } } for (int i = 0; i < userids.length; i++) { for (int j = 0; j < managerids.length; j++) { requestParams.clear(); requestParams.put("Employee", userids[i]); requestParams.put("Reviewer", managerids[j]); requestParams.put("Reviewerstatus", 1); hrmsCommonDAOObj.addAssignreviewer(requestParams); } } } jobj.put("valid", true); jobj.put("data", ""); txnManager.commit(status); } catch (Exception ex) { ex.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj.toString()); } }
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView saveCampEmailMarketConfig(HttpServletRequest request, HttpServletResponse response) throws ServletException { String retMsg = "{success:false}"; //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {// w w w . ja v a 2 s. c o m String emailMarketingID = null; HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("userid", sessionHandlerImpl.getUserid(request)); requestParams.put("templateid", request.getParameter("templateid")); KwlReturnObject copyMsg = crmEmailMarketingDAOObj.copyDefaultTemplates(requestParams); String templateid = request.getParameter("templateid"); if (copyMsg.isSuccessFlag()) { List template = copyMsg.getEntityList(); templateid = template.get(0).toString(); } requestParams = new HashMap<String, Object>(); requestParams.put("mode", request.getParameter("mode")); requestParams.put("emailmarkid", request.getParameter("emailmarkid")); requestParams.put("userid", sessionHandlerImpl.getUserid(request)); requestParams.put("name", request.getParameter("name")); requestParams.put("fromname", request.getParameter("fromname")); requestParams.put("fromaddress", request.getParameter("fromaddress")); requestParams.put("replyaddress", request.getParameter("replyaddress")); requestParams.put("inboundemail", request.getParameter("inboundemail")); requestParams.put("htmlcont", request.getParameter("htmlcont")); requestParams.put("plaincont", request.getParameter("plaincont")); requestParams.put("unsub", request.getParameter("unsub")); requestParams.put("marketingsubject", request.getParameter("marketingsubject")); requestParams.put("fwdfriend", request.getParameter("fwdfriend")); requestParams.put("archive", request.getParameter("archive")); requestParams.put("updatelink", request.getParameter("updatelink")); requestParams.put("templateid", templateid); requestParams.put("campid", request.getParameter("campid")); requestParams.put("captureLead", Boolean.parseBoolean(request.getParameter("captureLead"))); requestParams.put("colortheme", request.getParameter("colortheme")); requestParams.put("targetlist", request.getParameter("targetlist")); requestParams.put("csaccept", Boolean.parseBoolean(request.getParameter("csaccept"))); KwlReturnObject kmsg = crmEmailMarketingDAOObj.saveCampEmailMarketConfig(requestParams); Iterator ite = kmsg.getEntityList().iterator(); while (ite.hasNext()) { EmailMarketing emobj = (EmailMarketing) ite.next(); HashMap<String, Object> requestParams1 = new HashMap<String, Object>(); emailMarketingID = emobj.getId(); requestParams1.put("emailmarkid", emailMarketingID); KwlReturnObject kmsg1 = crmEmailMarketingDAOObj.deleteEmailmarketingTargetList(requestParams1); requestParams1.put("targetlist", request.getParameter("targetlist")); KwlReturnObject kmsg2 = crmEmailMarketingDAOObj.mapEmailmarketingTargetList(requestParams1); retMsg = kmsg2.getEntityList().get(0).toString(); } HashMap<String, Object> requestParams2 = new HashMap<String, Object>(); requestParams2.put("campaignid", request.getParameter("campid")); crmEmailMarketingDAOObj.deleteCampaignTarget(requestParams2); requestParams2.put("targetlist", request.getParameter("targetlist")); requestParams2.put("userid", sessionHandlerImpl.getUserid(request)); KwlReturnObject kmsg4 = crmEmailMarketingDAOObj.saveCampaignTargetList(requestParams2); // To Get Default Values of Email Marketing Template if (emailMarketingID != null) { JSONArray jArr = new JSONArray(request.getParameter("defaulttemplatestore")); crmEmailMarketingDAOObj.removeEmailMarketingDefaults(emailMarketingID); EmailMarketing em = crmEmailMarketingDAOObj.getEmailMarketing(emailMarketingID); EmailMarketingDefault emDefault; for (int i = 0; i < jArr.length(); i++) { JSONObject obj = jArr.getJSONObject(i); emDefault = new EmailMarketingDefault(); emDefault.setEmailMarketing(em); emDefault.setVariableName(obj.getString("varname")); emDefault.setDefaultValue(obj.getString("varval")); crmEmailMarketingDAOObj.saveEmailMarketingDefault(emDefault); } } txnManager.commit(status); } catch (ServiceException e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } catch (Exception e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } return new ModelAndView("jsonView", "model", retMsg); }
From source file:com.krawler.spring.importFunctionality.ImportUtil.java
/** * @param filename/*from ww w . j av a2 s . c o m*/ * @param delimiterType * @param startindex * @param importDao * @return * @throws ServiceException */ public static void dumpCSVFileData(String filename, String delimiterType, int startindex, ImportDAO importDao, HibernateTransactionManager txnManager) throws ServiceException { boolean commitedEx = false; DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("import_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); TransactionStatus status = txnManager.getTransaction(def); try { CsvReader csvReader = null; FileInputStream fstream = null; String destinationDirectory = storageHandlerImpl.GetDocStorePath() + "importplans"; File csv = new File(destinationDirectory + "/" + filename); fstream = new FileInputStream(csv); csvReader = new CsvReader(new InputStreamReader(fstream), delimiterType); // csvReader.readHeaders(); String tableName = importDao.getTableName(filename); Session session = txnManager.getSessionFactory().getCurrentSession(); int flushCounter = 0; while (csvReader.readRecord()) { ArrayList<String> dataArray = new ArrayList<String>(); for (int i = 0; i < csvReader.getColumnCount(); i++) { dataArray.add(cleanHTML(csvReader.get(i))); } importDao.dumpFileRow(tableName, dataArray.toArray()); if (flushCounter % 30 == 0) { session.flush(); session.clear(); } flushCounter++; } try { txnManager.commit(status); } catch (Exception ex) { commitedEx = true; throw ex; } } catch (IOException ex) { throw ServiceException.FAILURE("dumpCSVFileData: " + ex.getMessage(), ex); } catch (Exception ex) { if (!commitedEx) { //if exception occurs during commit then dont call rollback txnManager.rollback(status); } throw ServiceException.FAILURE("dumpCSVFileData: " + ex.getMessage(), ex); } }
From source file:com.siblinks.ws.service.impl.VideoServiceImpl.java
/** * {@inheritDoc}// ww w .ja va2s.c o m */ @Override @RequestMapping(value = "/rateVideo", method = RequestMethod.POST) public ResponseEntity<Response> rateVideo(@RequestBody final RequestData request) { String entityName = null; boolean status = false; SimpleResponse response = null; TransactionStatus statusDao = null; try { if (!AuthenticationFilter.isAuthed(context)) { response = new SimpleResponse(SibConstants.FAILURE, "Authentication required."); return new ResponseEntity<Response>(response, HttpStatus.FORBIDDEN); } String vid = request.getRequest_data().getVid(); String uid = request.getRequest_data().getUid(); String rate = request.getRequest_data().getRating(); // Return if vid or uid if (StringUtil.isNull(vid) || StringUtil.isNull(uid) || StringUtil.isNull(rate)) { response = new SimpleResponse(SibConstants.FAILURE, request.getRequest_data_type(), request.getRequest_data_method(), "Parameter cannot null or Emppty."); return new ResponseEntity<Response>(response, HttpStatus.OK); } TransactionDefinition def = new DefaultTransactionDefinition(); statusDao = transactionManager.getTransaction(def); Object[] queryParams = new Object[] { uid, vid }; entityName = SibConstants.SqlMapper.SQL_SIB_GET_USER_RATE_VIDEO; List<Object> videoRated = dao.readObjects(entityName, queryParams); boolean isRated = videoRated.size() > 0 ? true : false; if (!isRated) { entityName = SibConstants.SqlMapper.SQL_SIB_RATE_VIDEO; queryParams = new Object[] { vid, uid, rate }; Object[] queryUpdateRate = { rate, vid }; dao.insertUpdateObject(SibConstants.SqlMapper.SQL_UPDATE_AVG_RATE, queryUpdateRate); status = dao.insertUpdateObject(entityName, queryParams); } else { int newRate = Integer.parseInt(rate); int rateOld = ((Map<String, Integer>) videoRated.get(0)).get(Parameters.RATING); if (newRate != rateOld) { queryParams = new Object[] { rate, vid, uid }; entityName = SibConstants.SqlMapper.SQL_SIB_RATE_UPDATE_VIDEO; // Update again Object[] queryUpdateRate = { newRate - rateOld, vid }; dao.insertUpdateObject(SibConstants.SqlMapper.SQL_UPDATE_AVG_RATE_AGAIN, queryUpdateRate); status = dao.insertUpdateObject(entityName, queryParams); } } transactionManager.commit(statusDao); logger.info("Rate video success " + new Date()); response = new SimpleResponse("" + status, request.getRequest_data_type(), request.getRequest_data_method(), request.getRequest_data().getVid()); } catch (Exception e) { e.printStackTrace(); if (transactionManager != null) { transactionManager.rollback(statusDao); } response = new SimpleResponse(SibConstants.FAILURE, request.getRequest_data_type(), request.getRequest_data_method(), e.getMessage()); } return new ResponseEntity<Response>(response, HttpStatus.OK); }
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView saveModuleTargetsForTemplate(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject jobj = new JSONObject(); //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {// ww w.j a v a 2 s. co m HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("relatedto", request.getParameter("relatedto")); requestParams.put("listid", request.getParameter("listid")); requestParams.put("userid", sessionHandlerImpl.getUserid(request)); requestParams.put("data", request.getParameter("data")); KwlReturnObject kmsg = crmEmailMarketingDAOObj.saveModuleTargetsForTemp(requestParams); TargetList tl = (TargetList) kmsg.getEntityList().get(0); jobj.put("success", true); jobj.put("TLID", tl.getId()); txnManager.commit(status); } catch (ServiceException e) { logger.warn(e.getMessage()); txnManager.rollback(status); } catch (Exception e) { logger.warn(e.getMessage()); txnManager.rollback(status); } return new ModelAndView("jsonView", "model", jobj.toString()); }
From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java
public ModelAndView deleteAllappliations(HttpServletRequest request, HttpServletResponse response) { List tabledata = null;//from w w w. j a va 2 s .c om JSONObject jobj = new JSONObject(); JSONObject jobj1 = new JSONObject(); //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try { String[] ids = request.getParameterValues("ids"); for (int i = 0; i < ids.length; i++) { HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("id", ids[i]); hrmsRecJobDAOObj.deleteAllapplications(requestParams); } jobj.put("success", "true"); jobj1.put("data", jobj.toString()); jobj1.put("valid", true); txnManager.commit(status); } catch (Exception ex) { txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.siblinks.ws.service.impl.VideoServiceImpl.java
/** * {@inheritDoc}/*from w w w.j a v a 2s . c o m*/ */ @Override @RequestMapping(value = "/rateVideoAdmission", method = RequestMethod.POST) public ResponseEntity<Response> rateVideoAdmission(@RequestBody final RequestData request) { String entityName = null; boolean status = false; SimpleResponse response = null; TransactionStatus statusDao = null; try { if (!AuthenticationFilter.isAuthed(context)) { response = new SimpleResponse(SibConstants.FAILURE, "Authentication required."); return new ResponseEntity<Response>(response, HttpStatus.FORBIDDEN); } String vid = request.getRequest_data().getVid(); String uid = request.getRequest_data().getUid(); String rate = request.getRequest_data().getRating(); // Return if vid or uid if (StringUtil.isNull(vid) || StringUtil.isNull(uid) || StringUtil.isNull(rate)) { response = new SimpleResponse(SibConstants.FAILURE, request.getRequest_data_type(), request.getRequest_data_method(), "Parameter cannot null or Emppty."); return new ResponseEntity<Response>(response, HttpStatus.OK); } TransactionDefinition def = new DefaultTransactionDefinition(); statusDao = transactionManager.getTransaction(def); // Check user rated yet Object[] queryParams = new Object[] { request.getRequest_data().getUid(), request.getRequest_data().getVid() }; List<Object> videoRated = dao.readObjects(SibConstants.SqlMapper.SQL_SIB_GET_USER_RATE_VIDEO_ADMISSION, queryParams); boolean isRated = videoRated.size() > 0 ? true : false; if (!isRated) { // New rating entityName = SibConstants.SqlMapper.SQL_SIB_RATE_VIDEO_ADMISSION; queryParams = new Object[] { vid, uid, rate }; status = dao.insertUpdateObject(entityName, queryParams); Object[] queryUpdateRate = { rate, vid }; status = dao.insertUpdateObject(SibConstants.SqlMapper.SQL_UPDATE_AVG_RATE_VIDEO_ADMISSION, queryUpdateRate); // Activity Log activiLogService.insertActivityLog(new ActivityLogData(SibConstants.TYPE_VIDEO, "C", "You rated a video", uid, String.valueOf(vid))); } else { Map<String, Integer> object = (Map<String, Integer>) videoRated.get(0); int rateOld = object.get(Parameters.RATING); int rateNew = Integer.parseInt(rate); if (rateNew != rateOld) { // Update rating queryParams = new Object[] { rate, vid, uid }; entityName = SibConstants.SqlMapper.SQL_SIB_RATE_UPDATE_VIDEO_ADMISSION; status = dao.insertUpdateObject(entityName, queryParams); Object[] queryUpdateRate = { rateNew - rateOld, vid }; status = dao.insertUpdateObject( SibConstants.SqlMapper.SQL_UPDATE_AVG_RATE_VIDEO_ADMISSION_AGAIN, queryUpdateRate); // Activity Log activiLogService.insertActivityLog(new ActivityLogData(SibConstants.TYPE_VIDEO, "U", "You updated the rating a video", uid, String.valueOf(vid))); } } transactionManager.commit(statusDao); logger.info("Rating video addmission successful" + new Date()); response = new SimpleResponse("" + status, request.getRequest_data_type(), request.getRequest_data_method(), request.getRequest_data().getVid()); } catch (Exception e) { if (statusDao != null) { transactionManager.rollback(statusDao); } e.printStackTrace(); response = new SimpleResponse(SibConstants.FAILURE, request.getRequest_data_type(), request.getRequest_data_method(), e.getMessage()); } return new ResponseEntity<Response>(response, HttpStatus.OK); }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView rehireEmp(HttpServletRequest request, HttpServletResponse response) { SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd"); SimpleDateFormat sdf = new SimpleDateFormat("dd-mm-yyyy"); JSONObject msg = new JSONObject(); //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {//from w ww . j a v a2 s . c o m Empprofile e = null; String ids[] = request.getParameterValues("ids"); String deptid = request.getParameter("dept"); String desgid = request.getParameter("desg"); String salary = (request.getParameter("salary")); String reldate = request.getParameter("joindate"); String tempid = request.getParameter("templateid"); Date rvdate = fmt.parse(reldate); Date now = new Date(); for (int i = 0; i < ids.length; i++) { e = (Empprofile) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.ess.Empprofile", ids[i]); if (e != null) { if (e.getRelievedate() != null) { if (e.getRelievedate().after(rvdate)) { msg.put("msg", "invalidjoindate"); msg.put("success", true); txnManager.commit(status); return new ModelAndView("jsonView", "model", msg.toString()); } } } HashMap<String, Object> requestParams = new HashMap<String, Object>(); if (rvdate.before(now) || rvdate.equals(now)) { requestParams.put("termnd", false); } requestParams.put("userid", ids[i]); requestParams.put("joindate", request.getParameter("joindate")); requestParams.put("confirmdate", null); requestParams.put("relievedate", null); hrmsCommonDAOObj.addEmpprofile(requestParams); requestParams.clear(); requestParams.put("UserID", ids[i]); requestParams.put("Department", deptid); requestParams.put("Designationid", desgid); requestParams.put("Salary", salary); requestParams.put("Templateid", tempid); hrmsCommonDAOObj.addUseraccount(requestParams); if (rvdate.before(now) || rvdate.equals(now)) { requestParams.clear(); requestParams.put("UserID", ids[i]); requestParams.put("Deleteflag", 0); hrmsCommonDAOObj.adduser(requestParams); } // User u=(User)session.get(User.class,ids[i]); // Empprofile emp=(Empprofile)session.get(Empprofile.class,ids[i]); // Useraccount ua = (Useraccount) session.get(Useraccount.class, u.getUserID()); // ua.setDepartment((dept)); // ua.setDesignationid(desg); // ua.setSalary(salary); // u.setDeleteflag(0); // if (StringUtil.isNullOrEmpty(tempid) == false) { // ua.setTemplateid(tempid); // } // emp.setJoindate(rvdate); // emp.setTermnd(false); // emp.setRelievedate(null); // session.saveOrUpdate(emp); // session.saveOrUpdate(u); // session.saveOrUpdate(ua); //@@ProfileHandler.insertAuditLog(session, AuditAction.REHIRE_EMPLOYEE, "User " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has rehired employee " + AuthHandler.getFullName(u) ,request); } msg.put("success", true); txnManager.commit(status); } catch (Exception e) { e.printStackTrace(); txnManager.rollback(status); } finally { //return new ModelAndView("jsonView","model","{\"success\":\"true\"}"); return new ModelAndView("jsonView", "model", msg.toString()); } }
From source file:com.krawler.spring.importFunctionality.ImportUtil.java
/** * @param filename/*from w w w . ja v a 2 s .c om*/ * @param sheetNo * @param startindex * @param importDao * @return * @throws ServiceException */ public static void dumpXLSFileData(String filename, int sheetNo, int startindex, ImportDAO importDao, HibernateTransactionManager txnManager) throws ServiceException { boolean commitedEx = false; DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("import_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); TransactionStatus status = txnManager.getTransaction(def); Session session = txnManager.getSessionFactory().getCurrentSession(); try { String destinationDirectory = storageHandlerImpl.GetDocStorePath() + "xlsfiles"; POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(destinationDirectory + "/" + filename)); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheetAt(sheetNo); //DateFormat sdf = new SimpleDateFormat(df_full); int maxRow = sheet.getLastRowNum(); int maxCol = 0; String tableName = importDao.getTableName(filename); int flushCounter = 0; for (int i = startindex; i <= maxRow; i++) { HSSFRow row = sheet.getRow(i); if (row == null) { continue; } if (i == startindex) { maxCol = row.getLastCellNum(); //Column Count } ArrayList<String> dataArray = new ArrayList<String>(); JSONObject dataObj = new JSONObject(); for (int j = 0; j < maxCol; j++) { HSSFCell cell = row.getCell(j); String val = null; if (cell == null) { dataArray.add(val); continue; } String colHeader = new CellReference(i, j).getCellRefParts()[2]; switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_NUMERIC: if (HSSFDateUtil.isCellDateFormatted(cell)) { val = Long.toString(cell.getDateCellValue().getTime()); } else { val = dfmt.format(cell.getNumericCellValue()); } break; case HSSFCell.CELL_TYPE_STRING: val = ImportUtil.cleanHTML(cell.getRichStringCellValue().getString()); break; } dataObj.put(colHeader, val); dataArray.add(val); //Collect row data } //Insert Query if (dataObj.length() > 0) { // Empty row check (if lenght==0 then all columns are empty) importDao.dumpFileRow(tableName, dataArray.toArray()); if (flushCounter % 30 == 0) { session.flush(); session.clear(); } flushCounter++; } } try { txnManager.commit(status); } catch (Exception ex) { commitedEx = true; throw ex; } } catch (IOException ex) { throw ServiceException.FAILURE("dumpXLSFileData: " + ex.getMessage(), ex); } catch (Exception ex) { if (!commitedEx) { //if exception occurs during commit then dont call rollback txnManager.rollback(status); } throw ServiceException.FAILURE("dumpXLSFileData: " + ex.getMessage(), ex); } }