[Squirrel-sql-users] Re: Setting transaction isolation

[<Bir...@t-...>]

Hi Kovács,

Kovács Gergely wrote:

 > Hi,
 >
 > I find SQuirreL SQL client a very usefull tool for my everyday work. 
I > have only one little problem with it: how to set the transaction
 > isolation for a connection alias? The way I've tried: selected alias
 > in the listbox, clicked Change alias, checked Use driver properties
 > checkbox, in the driver properties list set DIL to an integer value (1
 > for uncommitted read). It should be TRANSACTION_READ_UNCOMMITTED but,
 > when I check the status, after connection it still shows
 > TRANSACTION_READ_COMMITTED. What is the right way to set this
 > property?
 > I use version 1.2beta6 with Progess database.

I tried setting the isolation level and it worked. Make sure you checked 
the 'Specify' check box and reopen the properties dialog after you set 
your props to check if your changes are still there. The table handling 
is sometimes a bit awkward.

It might be that it still won't work with your version because I'm using 
a snapshot of the sources that is a bit newer than 1.2beta6. 
Unfortunately I can't recommend building the current CVS sources.

If the props still won't work for you and you want me to I can mail you 
the sources of my version. It is a 1.5 mb zip file and needs to be 
completed by some libs that you need to check out from CVS.

Gerd