Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle/PowerBuilder dll connection issues

Re: Oracle/PowerBuilder dll connection issues

From: Thomas Kellerer <ESPKLFCTEKVY_at_spammotel.com>
Date: Tue, 12 Sep 2006 20:14:23 +0200
Message-ID: <4mobnvF73r41U1@individual.net>


Frank van Bortel wrote on 12.09.2006 19:46:
> Or even better: drop PowerBuilder; does it still
> generate lock statements?
>

It's been a long time since I worked with PB, but I have never seen PB explicitely lock a record or even a table without being asked for it.

Actually as far as I remember PB's strategy was optimistic locking (basically: when updating the records make sure the content in the DB is still the same as the one that was initially retrieved, if not throw an error) and it was very hard to actually implement pesimistic locking.

Thomas Received on Tue Sep 12 2006 - 13:14:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US