View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:50 PM
neo
 
Posts: n/a
Default 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.
Reply With Quote