READ_UNCOMMITTED problem with SQL 2000 and i-net Opta 2000 JDBC 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. |