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
