I believe Oracle actually throws an exception if you had an existing
transaction and you tried to fool around with the transaction setting.
Vinay
----- Original Message -----
From: "marc fleury" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 5:19 AM
Subject: RE: [JBoss-dev] High load...
> |I think you missed one of the old messages (way to many today).
> |
> |It appears that if you changes the transaction isolation in the middle of
a
> |transaction the driver can perform an implicit commit (YUCK).
> |
> |So, I don't think we can trust drivers to allows us to change the level
on
> |the fly.
>
> well that is EXCELLENT NEWS... ?
>
> you are saying that I can actually change the isolation level on a jdbc
> connection for a new transaction ? ( I don't want to change in the middle)
> what I want to do is
>
> connection A gets assigned to transaction B
>
> transaction B encompasses bean C
>
> The container gets connection D
>
> Connection D was use with bean E previously
>
> bean C is ISOLATION1 and D is ISOLATION2
>
> my question is can we reconfigure connection D with the new stuff?
>
> you seem to say that yes...because you are aware of problems that arise if
> we do it INSIDE a transaction, when I really don't care about this fine a
> feature...
>
> marcf
>
> |
> |-dain
> |----- Original Message -----
> |From: "marc fleury" <[EMAIL PROTECTED]>
> |To: <[EMAIL PROTECTED]>
> |Sent: Tuesday, June 26, 2001 10:36 PM
> |Subject: RE: [JBoss-dev] High load...
> |
> |
> |> |> Sure, it would be useful to be able to specify different levels per
> |> |> bean, but given the apparent constraints that the databases
> |are putting
> |> |> us under, implementing it against the database isn't feasable.
> |> |>
> |> |
> |> |Just use a freakin' different connection pool for different beans and
> |there
> |> |is no freakin' database constraint.
> |>
> |> oh wait reading old stuff, so you are saying that
> |>
> |> (do jdbc connection support setIsolationlevel on the fly) == false
> |>
> |> shit...
> |>
> |> databases is an UGLY world, you know what??? we can do MUCH better at
the
> |> distributed cache level so screw delegating to the db...
> |>
> |> I am drunk and it is getting tough to think ...
> |>
> |> marcf
> |>
> |>
> |>
> |> _______________________________________________
> |> Jboss-development mailing list
> |> [EMAIL PROTECTED]
> |> http://lists.sourceforge.net/lists/listinfo/jboss-development
> |>
> |
> |
> |_______________________________________________
> |Jboss-development mailing list
> |[EMAIL PROTECTED]
> |http://lists.sourceforge.net/lists/listinfo/jboss-development
>
>
>
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-development
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
