we are using 7.5.0.11.
We set autocommit off. With all isolation levels > 0 in our installation INSERT to table T1 locks all "SELECT * FROM T1" until commit or rollback.
This means, we can not display a list of all entries in T1 while someone else inserts a new entry but has not committed the work.
We expect to get all committed rows from the select.
Switching to isolation level 0 is not a solution (we get uncommitted data).
Can we somehow change this behavior?
We currently check, if we can port an application from oracle to MaxDB.
Matthias Schweizer SoliDat GmbH
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
