Re: Get the Transaction ID from JDBC

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 25 Mar 2007 05:27:51 GMT
Message-ID: <rLnNh.75473$7g3.59291@newsfe14.phx>

"Sam Hwang" <samhng_at_gmail.com> wrote in news: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"?

>
>

Hmm....
Interesting qustion.
Prior to this post I always thought SCN was only "assigned" upon COMMIT. Now I need to go do som tests. Received on Sun Mar 25 2007 - 00:27:51 CDT