neo wrote:

> Hi,
> I have a problem to set a JDBC connection as READ UNCOMMITED.
>
> setTransactionIsolation(Connection.TRANSACTION_REA D_UNCOMMITTED)
>
> This is causing lots of blocking on tables
> and update or insert doesn't work properly.
>
> Does anyone have any idea what I'm missing here?
>
> I asked i-net support and they suggested to call
> setAutoCommit(false) after the above function
> and it didn't work.
> also suggested impltrans = true, and I changed that option on SQL
> and it caused more blocking.
>
> Thanks in advance for any info.

Why are you letting anyone, or any thing, read an uncommited
transaction? If it is not committed ... it doesn't exist.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)