Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1069122434.507152@yasure>...
> 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.

This function sets dirty-read enable.
So even though there is blocking,
with this connection, data can still be read. That's what I want.