Re: Let me be the first

Mark Jamison wrote: > Hi Lukas, > > You are aware that you can do: > > begin work; > set isolation to dirty read; > select * from tab1; > insert into tab1 values ,value list.; --This automatically turns to> comitted read > select * from tab1; -- Back to dirty read;> commit work; > > > Of course if you feel the need to use committed read all the time, you > can just use > > set lock mode to wait <wait time>> > and then you second app will wait, up till the time specified, for you > batch process to release the lock. > There is a problem that the batch processing takes tens minutes... The second problem is that I access DB from Java via JDBC (Hibernate) and I don't like (can not) have special code for Informix. I know that I can put isolation level and wait_time into my URL :-) Lukas PS: thanks for advices.