if i do conn.setTransactionIsolation(4);, this will change the
isolation level of all the resultsets under same connection, and i
need to keep the record lock mean while allow other table access, so i
am not sure when is the best time to set back to cs. i feel unsafe
using this way, that is why i use forward only undatable cursor, but
not forsee the problem. is there any suggestion? thanks a lot