Re: oracle JDBC - how to detect uncommitted work on an open Connection ?

mcstock wrote:

>i can't think of any default way to find out about open transactions, but
>you could create a view (either owned by SYS or by a user that has
>privileges granted by SYS like this:
>
>CREATE OR REPLACE VIEW MY_TRANSACTION ( SID,
>START_SCNB, START_SCNW ) AS select
>s.sid
>, t.start_scnb
>, t.start_scnw
>from
> v$session s
>, v$transaction t
>where
>s.saddr = t.ses_addr
>and
>s.AUDSID = USERENV('SESSIONID')
>
>then create a public synonym and grant select to public -- selecting from
>the view will then show if there is an open transaction.
>
>-- mcs
>
>"Edoardo" <e.comar.no.spam_at_no.spam.btinternet.com> wrote in message
>news:bns3dh$ckk$2_at_hercules.btinternet.com...
>
>
>>Hi
>>
>>is there a way, using Oracle's JDBC drivers to find out if a given
>>java.sql.Connection has uncommitted work pending on it ???
>>
>>the reason is, close() will commit work if there is any - while if the
>>close happens as a cleanup action after an error, it would be desirable
>>to rollback (but I don't want to rollback always before close).
>>
>>TIA.
>>Edoardo Comar
>>www.choreology.com
>>
>>
>>
I take exception to any advice telling someone to create an object as SYS.

If all someone wants is open transactions there are a boatload of V_$ magic views that
provide all of that information.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)