Re[2]: [JBoss-user] Specifying isolation level

2002-09-20 Thread Alex Loubyansky
Thursday, September 19, 2002, 9:31:47 PM, you wrote: DS> He means UPDATE WHERE, which we don't support. The better way it to use DS> SELECT FOR UPDATE, which is supported. DS> If all you care about is a sequence generator, just use the one included DS> with JBoss. The CMP example code that c

Re: [JBoss-user] Specifying isolation level

2002-09-20 Thread Pete Beck
On Fri, 2002-09-20 at 13:20, David Jencks wrote: > AFAIK Oracle xa is the only db that disagrees with our code that sets tx > isolation. No surprises there. :-) -- Peter Beck BEng (hons) - Managing Director, Electrostrata Ltd. http://www.electrostrata.com --+-+-+-+-- Experts in e-business an

RE: [JBoss-user] Specifying isolation level

2002-09-20 Thread Saroj Kumar
: Re: [JBoss-user] Specifying isolation level All jboss versions use the db default tx isolation level unless you set it explicitly in the config file. AFAIK Oracle xa is the only db that disagrees with our code that sets tx isolation. Where did you get postgres-xa?? postgres doesn't suppo

Re: [JBoss-user] Specifying isolation level

2002-09-20 Thread David Jencks
ursday, September 19, 2002 11:26 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Specifying isolation level > > > You could have a bunch of properties per connection factory and per > ejb-method that could be set just before a connection was enlisted in a > transaction for

RE: [JBoss-user] Specifying isolation level

2002-09-20 Thread Saroj Kumar
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David Jencks Sent: Thursday, September 19, 2002 11:26 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Specifying isolation level You could have a bunch of properties per connection factory and per ejb

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread Dain Sundstrom
Yes. Pete Beck wrote: > On that basis, wouldn't it be possible to configure two datasources, and > just use different datasources for different beans? > > > On Thu, 2002-09-19 at 18:26, Dain Sundstrom wrote: > >>Is this even possible? I don't think it is. Isolation level is an >>attribute o

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread Dain Sundstrom
He means UPDATE WHERE, which we don't support. The better way it to use SELECT FOR UPDATE, which is supported. If all you care about is a sequence generator, just use the one included with JBoss. The CMP example code that comes with the Quick Start Guide uses it. Alternatively, you can use

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread Jim Crossley
Thank you for all your replies, but I'm still a bit confused WRT something Floyd Marinescu writes in his EJB Design Patterns book. In it, he describes the concurrency issues involved in a primary key generation pattern that involves the use of a Sequence CMP bean. I think he's saying that I c

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread Pete Beck
On that basis, wouldn't it be possible to configure two datasources, and just use different datasources for different beans? On Thu, 2002-09-19 at 18:26, Dain Sundstrom wrote: > Is this even possible? I don't think it is. Isolation level is an > attribute of the connections and not the transa

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread David Jencks
You could have a bunch of properties per connection factory and per ejb-method that could be set just before a connection was enlisted in a transaction for the first time. Transaction isolation could be one of these. Weblogic does something like this. I think it would be ridiculously confusing

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread Dain Sundstrom
Is this even possible? I don't think it is. Isolation level is an attribute of the connections and not the transaction, so unless we used a separate connection for each bean we would not be able to have different levels in the same transaction. If we did use different connections for each b

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread David Jencks
Rereading the post you responded to I still think I explained the situation fairly well. This feature has not been requested often (I think twice so far). It's possible, but would require a fair amount of code, would probably be extremely confusing to use, and doesn't seem to be a high priority.

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread Emerson Cargnin - SICREDI Serviços
why there isn't a property at jboss.xml to define the transaction isolation at ejb level, isn't it possible? David Jencks wrote: > You can only specify it per-datasource, not per-bean. Most dbs seem to > commit or throw an error if you try to change the isolation level inside a > transaction.

Re: [JBoss-user] Specifying isolation level

2002-09-19 Thread David Jencks
You can only specify it per-datasource, not per-bean. Most dbs seem to commit or throw an error if you try to change the isolation level inside a transaction. I guess it would be possible to include a tx isolation spec with the method transaction specs, but I think it would be pretty confusing,

[JBoss-user] Specifying isolation level

2002-09-19 Thread Jim Crossley
I hope this isn't too dumb of a question, but how do I specify a READ_COMMITTED isolation level for one of my CMP beans? The QuickStart guide mentions the different isolation levels, but it doesn't tell me how to specify them. Thanks, Jim -