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" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
