Oninit cdi / Archive
Talk to an expert →

Isolation level

Posted in 2005

Topics: Transactions, Locking & Isolation

Ricardo Manzo — — source: IIUG Forums & Mailing Lists

Hi Gurus I want to read some Informix tables from Oracle , I have Oracle Transparent Gateway but the Oracle isolation default is dirty read and informix is commited read. When Oracle Transparent Gateway send a select to informix it sends a "commited read" and sometimes I got table locked from Informix. I need that Oracle transparent gateway send a "dirty read" to informix. Do you know where can I configure this issue ? Thanks Ricardo

↪ replying to Ricardo Manzo
Thirugnanam, Kannan — — source: IIUG Forums & Mailing Lists

I am assuming you are sending a SQL from Oracle to Informix. Set isolation to dirty read ; < your SQL > ; Thank you, Kannan Thirugnanam -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Ricardo Manzo Sent: Thursday, March 17, 2005 8:41 AM To: ids@iiug.org Subject: Isolation level [4535] Hi Gurus I want to read some Informix tables from Oracle , I have Oracle Transparent Gateway but the Oracle isolation default is dirty read and informix is commited read. When Oracle Transparent Gateway send a select to informix it sends a "commited read" and sometimes I got table locked from Informix. I need that Oracle transparent gateway send a "dirty read" to informix. Do you know where can I configure this issue ? Thanks Ricardo

Glossary