Re: Transaction hanging

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 18 May 2007 13:00:54 +0200
Message-ID: <f2k109$n1b$1@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

fugamo_at_gmail.com schreef:
> 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.
>

Deadlocks (almost always) are programming and/or design errors. I doubt this has something to do with the data type.

Yes - I know applications that have had so many programmers working on them, that deadlocks occur. Now, with Java, and "db independent programming", application defined locking mechanisms appear - Oracle has a very fine locking mechanism, that never*) requires custom handling.

The DBA usually ends up killing one of the sessions.

-- Regards, Frank van Bortel *) Never say never :) Top-posting is one way to shut me up... -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGTYdmLw8L4IAs830RApMwAJ4o0MbHo+IiMuSjPfmmObHCgW/QbgCglLrc meVYjpuDJCeJf2BmZbFaOyo=
=gJfQ
-----END PGP SIGNATURE----- Received on Fri May 18 2007 - 06:00:54 CDT