Still waiting for an answer :-( I used Server_version 7.4.3.25 for Linux.
I can't belive nobody else wan`t to have this isolation-behavior. --- In [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: > I had 2 WEB-SQL-Studio-Browser-Windows, > both connect to teh same datebase as same databse-user, > both autommit off > /( user is created not exclusive ) > > In one Window I did in the other > > select count(*) from testtab > > insert into testtab values ( 10,'test') > > select count(*) from testtab > > > I want to see the result in both of the > select count(*) from testtab, since the insert in the other session > is not commited. > I do not want the second select count(*) from testtab waiting > for commit or rollback. > > Is this possible ? > > In my understanding of the documentation isolationlevel "committed" (= 1 or 10) for both sessions should > be correct for this. > But in my tests with "commited", the result of the second "select count(*) from testtab" > is reuslt of the first "select count(*) from testtab" + 1 > this is yust the same as using isolation-level"uncommited" (=0) > > When using isolation levels 2,,15,3 the second "select count(*) from testtab" waits for commit or rollback. > > I don`t think it`s a bug in WEB-Sql-Studio because I have the same effect in a python-script. > > > > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
