Re: Get the Transaction ID from JDBC

From: Sam Hwang <samhng_at_gmail.com>
Date: 24 Mar 2007 22:01:07 -0700
Message-ID: <1174798867.528282.227820@y66g2000hsf.googlegroups.com>

Hi Ana,
My intention is get the undo sql from a specific tx, as documented at Oracle docs

SELECT xid, start_scn START, commit_scn COMMIT,

        operation OP, logon_user USER,
        undo_sql FROM flashback_transaction_query
        WHERE xid = HEXTORAW('000200030000002D');

XID               START   COMMIT  OP       USER   UNDO_SQL
----------------  -----   ------  --       ----
---------------------------
000200030000002D  195243  195244  DELETE   HR     insert into

"HR"."EMP"
("EMPNO","EMPNAME","SALARY") values ('111','Mike','655');

000200030000002D 195243 195244 INSERT HR delete from "HR"."DEPT"
where ROWID = 'AAAKD4AABAAAJ3BAAB';

000200030000002D 195243 195244 UPDATE HR update "HR"."EMP" set "SALARY" = '555' where ROWID = 'AAAKD2AABAAAJ29AAA';

000200030000002D 195243 113565 BEGIN HR 4 rows selected

Ana C. Dent wrote:
> "Sam Hwang" <samhng_at_gmail.com> wrote in news:1174797240.237573.57120
> @e65g2000hsc.googlegroups.com:
>
> > Is it possible to get the transaction id from JDBC API?
> >
> >
>
> huh? what do you define as "transaction id"?
Received on Sun Mar 25 2007 - 00:01:07 CDT