Board index » delphi » Concurrency Problem - Database Networking Application using BDE (Paradox)

Concurrency Problem - Database Networking Application using BDE (Paradox)

Hi there,
Current Setting...
2 computers using Peer to Peer Network with one of them acting as 'Server'
Both Application and Data reside in 'Server'
Each computer has a BDE engine with NetDir pointing to the same Pdoxusr.Net
at 'Server'

Problems
Everything works fine except that when both computers edit the same record,
there is NOT 'Table Busy' which I should expect. As a result, there is
concurrency problem.

I would really appreciate very much if anyone out there could provide some
suggestions.

regards,

Jonathan Yeo

rj...@mbox3.singnet.com.sg

 

Re:Concurrency Problem - Database Networking Application using BDE (Paradox)


There is a problem with the windows caching the harddrive.  When you get a
record lock on the the first computer that computer does not write back the
updated locked to the system.  The second computer will never see the
record lock.  With our BDE engine (Apollo) there was a command to write
back the cache right away.

-Mark

 Jonathan Yeo wrote in article <01bc9aa5$029dab20$c6b415a5@p166>...

Quote
>Hi there,
>Current Setting...
>2 computers using Peer to Peer Network with one of them acting as
'Server'
>Both Application and Data reside in 'Server'
>Each computer has a BDE engine with NetDir pointing to the same
Pdoxusr.Net
>at 'Server'

>Problems
>Everything works fine except that when both computers edit the same
record,
>there is NOT 'Table Busy' which I should expect. As a result, there is
>concurrency problem.

>I would really appreciate very much if anyone out there could provide
some
>suggestions.

>regards,

>Jonathan Yeo

>rj...@mbox3.singnet.com.sg

Other Threads