Re: NOLOCK for multiple tables

[Ra Nala]

Peter thank you for your input.

when i run the same in aqua data studio or mysql work bench then it is working fine 'but' failing when i run using some external ETL tool called as kettle.

Do you know any idea about this error : Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; ??

SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select * from course
go
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ