ejb@glassfish.java.net

Re: Isolation Level

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Fri, 23 Feb 2007 20:01:39 +0530

Hi Antonio,

You can set isolation level in the connection pool of GlassFish.
Con.Pool will ensure that the required isolation level is setting when
application requests a connection.
For more information, refer ––isolationlevel, ––isisolationguaranteed
attributes of connection pool.
http://docs.sun.com/app/docs/doc/819-3662/6n5s9hmts?a=view

Note : Before setting your desired isolation-level, ensure that the
jdbc-driver / db-server supports such isolation-level.

To programatically set isolation level :

http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#setTransactionIsolation(int)

Thanks,
-Jagadish

On Fri, 2007-02-23 at 14:09 +0100, Antonio Goncalves wrote:
> Hi everybody,
>
> I just want to be sure I've understood isolation level in the EJB 3.0
> spec by asking you few questions. In my understanding isolation levels
> are not defined in the spec right ? Withing Glassfish this is defined
> when configuring the underlying datasource right ? Is there any
> programmatic way of doing it though ?
>
> Thanks,
>
> Antonio
>