tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Iván Rodríguez <i...@interd4u.com>
Subject Re: Database backups initiated from Tomcat
Date Wed, 19 May 2004 14:40:32 GMT
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@fwdco.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
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@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message