RE: Setting transaction isolation level in TranQL

["Zakharov, Vasily M" <va...@intel.com>]

Ooh. So for now there's completely no way I can provide the application
with the isolation level other than read-uncommitted?

When can we expect that TranQL 1.3.1 to appear? :)

Until then, is there a way to pass some SQL statements to the database
through the connector?

By the way, isn't there a J2EE specification requirement of the ability
to set isolation levels on connectors?

 Vasily


-----Original Message-----
From: Matt Hogstrom [mailto:matt@hogstrom.org] 
Sent: Wednesday, May 31, 2006 9:55 PM
To: user@geronimo.apache.org
Subject: Re: Setting transaction isolation level in TranQL

This is a feature I'm looking to put into TranQL 1.3.1 as well as
allowing the ability to set the 
default Isolation Level for a DataSource.


Zakharov, Vasily M wrote:
> Hi, all,
> 
> Can I somewhat configure the entity (or connector) to use a particular
> Transaction Isolation level?
> 
> Stanley Bradbury recently described how it can be done with SQL query
to
> Derby, but how can I do that while working through a TranQL connector?
> 
> Thank you!
> 
> Vasily Zakharov
> Intel Middleware Products Division
> 
> 
> 

Re: Setting transaction isolation level in TranQL

[Mario Rübsam <mr...@coderesearch.com>]

Vasily,

there is a way in some DBMS to bypass the settings and set the
isolation level via SQL or via the connection url. I dont know
which side effects this has.

- Mario


Zakharov, Vasily M wrote:
> Ooh. So for now there's completely no way I can provide the application
> with the isolation level other than read-uncommitted?
> 
> When can we expect that TranQL 1.3.1 to appear? :)
> 
> Until then, is there a way to pass some SQL statements to the database
> through the connector?
> 
> By the way, isn't there a J2EE specification requirement of the ability
> to set isolation levels on connectors?
> 
>  Vasily
> 
> 
> -----Original Message-----
> From: Matt Hogstrom [mailto:matt@hogstrom.org] 
> Sent: Wednesday, May 31, 2006 9:55 PM
> To: user@geronimo.apache.org
> Subject: Re: Setting transaction isolation level in TranQL
> 
> This is a feature I'm looking to put into TranQL 1.3.1 as well as
> allowing the ability to set the 
> default Isolation Level for a DataSource.
> 
> 
> Zakharov, Vasily M wrote:
>> Hi, all,
>>
>> Can I somewhat configure the entity (or connector) to use a particular
>> Transaction Isolation level?
>>
>> Stanley Bradbury recently described how it can be done with SQL query
> to
>> Derby, but how can I do that while working through a TranQL connector?
>>
>> Thank you!
>>
>> Vasily Zakharov
>> Intel Middleware Products Division
>>
>>
>>
> 

Re: Setting transaction isolation level in TranQL

[Matt Hogstrom <ma...@hogstrom.org>]

I cut Tranql 1.3 last night....1.3.1 will have this support soon :)

Zakharov, Vasily M wrote:
> Ooh. So for now there's completely no way I can provide the application
> with the isolation level other than read-uncommitted?
> 
> When can we expect that TranQL 1.3.1 to appear? :)
> 
> Until then, is there a way to pass some SQL statements to the database
> through the connector?
> 
> By the way, isn't there a J2EE specification requirement of the ability
> to set isolation levels on connectors?
> 
>  Vasily
> 
> 
> -----Original Message-----
> From: Matt Hogstrom [mailto:matt@hogstrom.org] 
> Sent: Wednesday, May 31, 2006 9:55 PM
> To: user@geronimo.apache.org
> Subject: Re: Setting transaction isolation level in TranQL
> 
> This is a feature I'm looking to put into TranQL 1.3.1 as well as
> allowing the ability to set the 
> default Isolation Level for a DataSource.
> 
> 
> Zakharov, Vasily M wrote:
>> Hi, all,
>>
>> Can I somewhat configure the entity (or connector) to use a particular
>> Transaction Isolation level?
>>
>> Stanley Bradbury recently described how it can be done with SQL query
> to
>> Derby, but how can I do that while working through a TranQL connector?
>>
>> Thank you!
>>
>> Vasily Zakharov
>> Intel Middleware Products Division
>>
>>
>>
> 
> 
>