Read Uncommitted

[bugg_tb]

Hi Guys,

Im not using SQL Explorer(JDBC) but Kettle when setting up a connection or running a query I can't for the life of me work out how to set the transaction read uncommitted.
I've tried
SET TRANSACTION ISOLATION LEVEL UNCOMMITTED READ
and the
@TRANSACTIONISOLATION 0

but neither have worked. How do you do this using the jdbc drivers but not with SQL explorer?

Cheers

Tom

Progress 9.1D

 

[tamhas]

I typically do it in the ODBC definition of the connection.

 

[bugg_tb]

Yeah, but if you're not using ODBC thats out the window

 

[Casper]

Did you make a typo?
It should be:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
and not uncommitted read.

Casper.

 

[plus_marca]

Hi.

Try using the numeric value insted.

Connection conn = DriverManager.getConnection"jdbc:jdbcprogress:T:hostort:db","login", "password");
conn.setTransactionIsolation(0);

 

[bugg_tb]

Did you make a typo?
It should be:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
and not uncommitted read.

Casper.

I've tried this in SQL using Progress 9.1D and I get fed a syntax error, is it possible to set the isolation level in pure sql or do I _have_ to set it in jdbc driver settings?

Cheers

Tom