Dirty Read

giggio Mar 6, 2003 10:01 AM

I'm using JBoss 3.0.2 and Informix 9.2. I'm using informix-xa-service.xml to datasource configuration.

I configured the TransactionIsolation attribute as:
TRANSACTION_READ_UNCOMMITTED
because I need set the isolation level to DIRTY READ.

However, when I execute "onstat -g sql", I observe that all SELECT, UPDATE, INSERT statements are executed as COMMITTED READ.

This situation is causing many problems in my application because when a SELECT statement is executed, an error is returned.

Is there a manner to execute these SQL Statements as DIRTY READ?

Thank you.

Giovanni.

1. Re: Dirty Read

hormati Mar 6, 2003 11:25 AM (in response to giggio)

I don't know exact answer of your question ,
But I know that some drivers , for example oracle thin driver, does not support some levels of Transaction Isolation [Oracle drivers support only TRANSACTION_SERIALIZED and TRANSACTION_READ_COMMITED]

so read your database driver documents or find another driver.

I hope you get your answer.
Actions