java - Ability to rollback changes when insert data using a server API -


i have following situation:

i have build client java application, used communicate mysql database directly. when inserting lot of data, used autocommit turned off. easy do, because had direct access connection. had chosen this, because enabled me rollback changes when went wrong during synchronization.

now, application evolving , thought better build server api communicates mysql database. so, @ moment, inserting data doing http requests. each request opens , closes new connection.

now, able rollback changes when 1 of requests goes wrong. assume can not work autocommit, because based on connection, , 1 different each request.

can tell me how done usually?

i have thought of following:

  • first call url sets autocommit false, , requests , check if 1 fails. go wrong if client inserting data @ same time.
  • sending data server 1 request, force me alter design drastically.

note: know code required when asking question, can not see how improve question. however, if needed, feel free request it.

every web request should run in it's own transaction.

send data belongs logical transaction in 1 request , call commit @ end of request processing.

spaning transactions accros multiple web requests bad idea. think crashing clients never commit. leave open transactions never close.


Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more