java - How to avoid Concurreny from front end -



java - How to avoid Concurreny from front end -

we have requiremnt manager log in site , see list of user record in table format. when click on record detail of user , phone call user resolve issue.now possible 2 manager login , click on same record , phone call same user @ same time. want avoid this.

condition 1 : 2 manager login @ same time record available both in normal color green. manager 1 click on record , start editing/calling user. in case there should kind of lock if manager 2 tries open same record pop message 'in progress'.

condition 2 : manager 1 login , see record in greenish color. manager 2 login , see same record in gray color. should not able click record.

+++++++++++++++++

manager1: select status, ver_no record record_id=? (ver_no zero) click on record see detail , update record set status='in progress', ver_no=1 record_id=? , ver_no=0 (ver_no 1 - success)

now manager 2 login after time , manager 1 has not closed record means status still in progress or closed browser straight manager2: select status, ver_no record record_id=? (ver_no 1) click on record see detail , manager2: update record set status='in progress', ver_no=1 record_id=? , ver_no=1 (ver_no 1 - success)

this case optimistic locking scenario. work in backend server code. cannot lock user using java script on front end end.

let me explain in simple terms how this:

add version number column , status flag database table. on record table.

manager 1 clicks on record, select record database first, increment version number , update flag saying record picked up.

manager 2 clicks on record, (if @ same manager 2 select same record selected manager 1). when manager 2 tries update record, version number not match , update homecoming no rows updated. utilize update ui saying record in progress.

the conversation below:

manager1: select status, ver_no record record_id=? (ver_no zero) manager2: select status, ver_no record record_id=? (ver_no zero) manager1: update record set status='in progress', ver_no=1 record_id=? , ver_no=0 (ver_no 1 - success) manager2: update record set status='in progress', ver_no=1 record_id=? , ver_no=0 (this fail update row)

the above in case both attack same row @ same time. of time when manager 2 selects itself, status in progress. if not can work record.

java javascript oracle11g

-

Comments

Post a Comment

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

formatting - SAS SQL Datepart function returning odd values - i'm having massive problem project can't seem right. i'm trying modify info variable in datetime format. first info 30mar12:00:00:00. i've been advised utilize code below returns value 30mar60:5:30:00. want date component , have no thought how info got exported in format wasn't in microsoft access. i've tried several mods code 1 time again comes blank or sends error message. proc sql; update dataset set date = datepart(date); quit; any advice appreciated. i'm guessing variable date numeric , formatted datetime. 1 time you've carried out conversion, alter format date9. sas datetime value number of seconds since 01 jan 1960, whereas dates number of days since 01 jan 1960. both stored numbers, using right format display value key. illustration below. data _null_; a='30mar12:00:00:00'dt; b=datepart(a); c=b; format b datetime. c date9.; set b c; run; ...
Read more

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) - here error: duplicate symbol _objc_metaclass_$_bfapplinkreturntorefererview in: /users/user/documents/facebooksdk/facebooksdk.framework/facebooksdk(bfapplinkreturntorefererview.o) /users/user/desktop/project/project/project/assets/facebook/editor/ios/facebooksdk/facebooksdk.a(bfapplinkreturntorefererview.o) ld: 889 duplicate symbols architecture armv7 clang: error: linker command failed exit code 1 (use -v see invocation) i have searched find solution of error couldn't. there tons of similar error this, 1 hasn't been asked yet. problem shows when add together "-objc" "other linker flags". need add together utilize admob service. problem? how can solve this? i faced same issue while integrating facebook-ios-sdk. because using 3rd party library had bolts.framework linked against it. solution found incorporate facebook-ios-sdk source code hosted on github. ...
Read more

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' - extension's github project: https://github.com/mdmsoft/yii2-admin i'm using advanced template of yii2, i've backend , frontend , common folders advanced folder. the advanced folder on same level of vendor folder. i've others extensions , working then installed yii2-admin composer php composer.phar require mdmsoft/yii2-admin "*" installation worked well. into vendor folder i've mdmsoft folder yii2-admin subfolder it. this actual content of v endor/yiisoft/extensions.php (modified composer installation, haven't manually touched it) <?php $vendordir = dirname(__dir__); homecoming array ( 'yiisoft/yii2-jui' => array ( 'name' => 'yiisoft/yii2-jui', 'version' => '2.0.0.0', 'alias' => array ( '@yii/jui' => $vendordir . '/yiisoft/yii2-jui', ...
Read more