spring - Changes in Oracle database are not visible for a certain query -

-

i have large query looks this:

select stuff, case when (some subselect) > 0 'value 1'           when (another subselect) > 0 'value 2'           else 'value 3' end status (yet subselect) e

it works great. then, spring, trough jparepositories make changes effect some subselect part, reason, these changes not immediate. in other queries changes visible, tried using several transnational mechanism in spring, tried not using transaction @ all, i'm using saveandflush on repositories, without luck.

but delay happened if restarted tomcat server before changes visible. delay visible external db manipulation program, i'm guessing problem not application.

can kind of oracle caches or transactions effect this? how can purge, flush, commit them?

edit (for request in comments):

in java make basic changes

java code

myentity myentity = myentitydao.findone(someid); myentity.setproperty(newvalue); myentitydao.saveandflush(myentity);

where myentitydao looks like

@repository public interface myentitydao extends jparepository<myentity, integer> {      //... other unrelated hql query methods }

sorry can't post more specific, it's huge, , also, can't, corporate reasons. note, working, delay, between modification , 1 specific query. other queries can see changes immediately.

most probable reasons are:
1) changes made in separate transaction , not committed before query started.
oracle doesn't allow read not committed changes other transactions.
, query returns consistent data moment of query start.
2) if change transaction "read only" or "serializable" oracle return data consistent transaction start. changes made in transaction need committed before read transaction started.


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more