> [mailto:[EMAIL PROTECTED]]On Behalf Of Richard Monson-Haefel
> Sent: Friday, September 07, 2001 11:59 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Concurrency in Entity beans
>
>
> I assume that the isolation levels you are referring to are used by the
> WebLogic container to configure the JDBC connection to indicate which
> isolation level to use while accessing the database. This is completely
> consistent with what I said earlier, as the reasonability of concurrency
> is pushed to the database.
Richard,
Setting jdbc driver isolation levels alone does not guarantee
that concurrency is pushed to the database (someone correct me
if I am wrong). With some database vendors such as Microsoft's
SQL Server and Sybase(?), setting the jdbc driver's isolation
level to "Serializable" will result in the concurrency being
pushed to the database.
However with db vendors such as Oracle, you need to use the
"SELECT ... FOR UPDATE" syntax to achieve Serializable
isolation. Simply setting the isolation level on the jdbc
driver for (say) Oracle will not have the desired effect of
pushing concurrency to the database.
-krish
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
