B4J Question jSQL - How to set TransactionIsolation

[Dominik Böhm]

Hi,

i need to set the Transaction Isolation Level. Is this possible to access this field on the connection object?

Progress Customer Community

knowledgebase.progress.com

Connection (Java Platform SE 7 )

docs.oracle.com

sqlConnSession = (Connection) testLwPool.getConn();
sqlConnSession.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

...
Try
  SQL1 = Pool.GetConnection
Catch
  LOG(LastException.Message)
End Try
...

thanks

 

[Erel]

Dim connection As JavaObject = SQL1
connection = connection.GetField("connection")
connection.RunMethod("setTransactionIsolation", Array(2)) 'TRANSACTION_READ_COMMITTED