java - JPA executeUpdate always returns 1 -


i'm having issue here executeupdate command returns value 1 though there's no record updated.

first retrieve several records, bit of calculation, , update status of of retrieved records.

the jpa update code:

private int executeupdatestatustosuccess(long id, query updatequery) {     updatequery.setparameter(1, getsysdatefromdb());     updatequery.setparameter(2, id);     int cnt = updatequery.executeupdate();     return cnt; // return 1 }

the update query:

update product_param set status = 2, data_timestamp=? id = ? , status=-1

note status column practically never valued < 0. i'm purposely adding condition here show though shouldn't have updated record, executeupdate() still returns value 1.

as additional note, there no update process anywhere between data retrieval , update. it's done within local environment.

any advice if i'm possibly missing here? or if there's configuration parameter need check?

edit: jpa i'm using eclipselink. database i'm using oracle 10g driver ojdbc5.jar.

in end have eclipselink jpa source code. system executes line 

return integer.valueof(1);

from codes inside basicexecutecall method of databaseaccessor class below:

if (isinbatchwritingmode(session)) {     // if there nothing returned , not using optimistic locking batch     //if storedprocedure in/out or out parameters not batch     //logic may weird must not batch if not using jdbc batchwriting , have parameters     // may want refactor day     if (dbcall.isnothingreturned() && (!dbcall.hasoptimisticlock() || getplatform().canbatchwritewithoptimisticlocking(dbcall) )          && (!dbcall.shouldbuildoutputrow()) && (getplatform().usesjdbcbatchwriting() || (!dbcall.hasparameters())) && (!dbcall.isloblocatorneeded())) {         // handle executing batched statements, or switching mechanisms if required         getactivebatchwritingmechanism().appendcall(session, dbcall);         //bug 4241441: passing 1 avoid optimistic lock exceptions since there            // no way know if succeeded on db @ point.         return integer.valueof(1);     } else {         getactivebatchwritingmechanism().executebatchedstatements(session);     } }

one easy hack not using batch. i've tried turning off in persistence.xml , update returns expected value, 0.

<property name="eclipselink.jdbc.batch-writing" value="none" />

i'm expecting better solution 1 in situation.


Comments

Post a Comment

Popular posts from this blog

powershell Start-Process exit code -1073741502 when used with Credential from a windows service environment -

i'm running strange behavior powershell start-process call. here call: $process = start-process ` "c:\somepath\mybinary.exe" ` -passthru ` -credential $defaultcredential ` -wait ` -workingdirectory "c:\somepath" ` -loaduserprofile if ($process.exitcode -ne 0) { #do } this call return exit code - 1073741502 . after quick search, exit code seems related generic error when program not load required dll (aka. status_dll_init_failed ). when run without -credential $credential program runs correctly. in order isolate problem, manually launched some.exe in prompt target credential , runs smoothly. so problem seems come way start-process cmdlet launch process. i found potential solutions problem tried apply no luck : link , link . would have idea of what's going on here ? edit 1: run proc mon monitoring program activities when launched directly or via powershell script. problem seems occur when loading kernelbase
Read more

twig - Using Twigbridge in a Laravel 5.1 Package -

i'm trying create laravel 5.1 package uses twigbridge instead of .php views. can normal .php views display fine, when try make use of .twig templates i'm met error. possible use twigbridge templates when creating views laravel package or pretty stuck blade , php ? edit 1: loading twig template without extending works. it's when start using {% extends 'file' %} error comes out. i error error loading /virtual/laravel/packages/username/mypackage/src/views/sample.twig: template "templates.master" not defined () in "/virtual/laravel/packages/username/mypackage/src/views/sample.twig" @ line 1. my folders username |_ mypackage |_ src |_ controllers - samplecontroller.php |_ views |_ templates - master.twig - sample.twig twig template sample.twig {% extends 'templates.master' %} {% block content %} {{ parent()
Read more

c# - LINQ join Entities from HashSet's, Join vs Dictionary vs HashSet performance -

i have hashset's each stores t, have written test application compares different relation algorithms can think of, i'm not pleased results getting. does there exist more efficient ways of achieving object relations, once testing? using system; using system.collections.generic; using system.linq; using system.text; using system.threading.tasks; using system.diagnostics; namespace linqtests { class program { static void main(string[] args) { hashset<user> usertable = new hashset<user>(); hashset<userproperty> userpropertytable = new hashset<userproperty>(); #region lets create dummy data. console.writeline("please wait while creating dummy data, can take while..."); console.writeline(""); int rows = 1000000; for(int x = 0; x < rows; x++) { random rnd = new random(); // ad
Read more