mySQL has the locking table you need . It depends of the version of the
server you are testing.

LOCK TABLES yourtable lockmode;
http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html

----- Original Message -----
From: "Ben Souther" <bsouther@(protected)>
To: "Tomcat Users List" <tomcat-user@(protected)>
Sent: Wednesday, May 19, 2004 4:28 PM
Subject: Re: Database backups initiated from Tomcat


I'm not sure if getRuntime().exec(String cmdline) is synchronous or not.
Also I don't know if mySql makes any provisions for locking a table during a
dump.

Those are the questions I would want answered before going ahead.


On Wednesday 19 May 2004 10:15 am, Frank Burns wrote:
> So you think running Runtime.getRuntime().exec(String cmdline) from within
> a Servlet is viable?
>
>
> Can you think of any potential issues with using this solution?
>
>
> I'm just trying fathom, as quickly as possible, whether there are any
"show
> stoppers" in taking this route.

--
Ben Souther


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)