Re: Transaction hanging

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 18 May 2007 08:32:53 -0700
Message-ID: <1179502369.415386@bubbleator.drizzle.com>

fugamo_at_gmail.com wrote:
> Hello,
> I'm facing with hanging transaction in my Oracle 10gR2 database.
> A Jonas server with hibernate layer connect to the Oracle database.
> Driver used: ojdb14: oracle:thin
> Sometimes there are transactions stay open and never commit. this
> implies deadlock afterwards.
> The table locked has Nclob column.
> Is anyone encounter this issue on such table ?
>
> Thanks,
>
>
> Mohamed.

It has nothing to do with your table ... it has everything to do with your design.

Given that you provided no DDL, no DML, and no error message no help is really possible at this time.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri May 18 2007 - 10:32:53 CDT