java - Hibernate : Transaction commited but data not inserted to the Database -


i've got unusual situation using hibernate. have shopping cart in web application. used following methods add or update cart.

isitemexists(...) - check whether item exists in cart or not

additem() - add item item not exists or update existing item.

incrementcarttotal(..) - update cart total

additem(..)

 public void addcartitem2(cartitems item, int qty) {     session ses = factory.opensession();     transaction tr = ses.begintransaction();     try {         cartitems c1 = isitemexists(item.getmodel(), item.getcart());          if (c1 != null) {             double unitprice = smodel.getstock(item.getmodel()).getunitprice();              query q = ses.createquery("update "                     + " cartitems "                     + " set qty = qty + " + qty + " , sub_total = sub_total +" + qty * unitprice                     + " model_id=" + c1.getmodel().getid()                     + "  , cart_id=" + c1.getcart().getid());             q.executeupdate();         } else {             ses.save(item);         }          tr.commit();          incrementcarttotal(item.getcart(), numberutilities.parsedouble(item.getsubtotal()));      } catch (hibernateexception e) {         e.printstacktrace();         logger.err(e.getmessage());     } {         if (ses.isopen()) {             ses.close();         }     } }

i can add or update cart items once. after remove items cart can't add or update items cart. cart total updating. transaction commited but, data not inserted.

how can solve problem.

try this, not use additem() method update , save.

  • use isitemexists() mthod check whether item exists or not.
  • if not create method save item
  • if exists create method update existing item

save()

 public void save(cartitems item) {     session ses = factory.opensession();     try {         transaction tr = ses.begintransaction();         ses.save(item);         tr.commit();          incrementcarttotal(item.getcart(), numberutilities.parsedouble(item.getsubtotal()));     } catch (hibernateexception e) {        // handle exception     } {         // close session     } }

update()

 public void update(cartitems item,int qty, double price) {     session ses = factory.opensession();     transaction tr = ses.begintransaction();     try {         query q = ses.createquery("update "                 + " cartitems "                 + " set qty = qty + "+qty+" , sub_total = sub_total +" + qty*price                 + " model_id=" + item.getmodel().getid()                 + "  , cart_id=" + item.getcart().getid());         q.executeupdate();          tr.commit();     } catch (hibernateexception e) {         // handle exception     } {         // close session     }     incrementcarttotal(item.getcart(), numberutilities.parsedouble(item.getsubtotal())); }

and use these whereever want

... if(isitemexists(..)){   update(); }else{   save(); } ....

hope helped !


Comments

Post a Comment

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

while performing simple hover test on firefox through selenium (3.4.0) python bindings (3.4.3) using of available os in saucelabs (except linux, latest available firefox version old), performing following actionchain: hover = actionchains(driver) hover.move_to_element(elm_men_menu).perform() it throws following error: taceback: file [...] in testhover hover.perform() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 80, in perform action() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 290, in <lambda> command.move_to, {'element': to_element.id})) file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/remote/webdriver.py", line 256, in execute self.error_handler.check_response(response) file "/usr/local/lib/python2.7/...
Read more

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

transpose - Maple isnt executing function but prints function term -

im using maple im in worksheetmode tried using maple input , 2d input , want transpose matrix a: := `<|>`(`<,>`(1, .5, -2), `<,>`(.5, 9/4+b, 5+3*b), `<,>`(-2, 5+3*b, 18+9*b+4*a)); b:= transpose(a); when exectute sheet dont translated values, there same input. matrix looks same input matrix plus function term. you can see picture in following link: why arent functions executed? meanwhile b:=a^+ doing right way , transposed matrix. other functions return function body instead needed values... if using 2d input mode (the default) space you've got between transpose , bracketed (b) interpreted multiplcation. rid of such space. also, either load package @ start of document like, with(linearalgebra): before calling transpose command package, or call it's full name like, linearalgebra:-transpose(b);
Read more