Hi Andy,
The best way to accomplish this is at an application level,  setup a
lock table and put your locks in there.  There are many methods for
handling application locks. Choose one that work for you.  With a
database level lock, when the connection terminates the lock is
released.

Persistant connections might be an option, but you can't guarantee
your CGI will get the same connection and be able to release the lock!

Hope this helps,
Ken
----- Original Message ----- 
From: "Andy Ford" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 26, 2004 10:01 PM
Subject: table locking using perl DBI


> I have a perl cgi script that needs to lock the tables.
Unfortunately,
> as HTTP is a one shot protocol, once the cgi script completes
execution,
> the tables are unlocked.
>
> I need it to stay locked until another cgi script unlocks them!
>
> Is there any other way of achieving this!?
>
> Thanks
>
> Andy
>
>
> -- 
>
> perl -e 'print qq^;@) [###]^^qq^z\.MY{eLQ9^'
> in:control developer, Telindus, RG27 9HY
> DDI: +44 1256 709211, GSM: +44 7810 636652
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to