I'm restoring my MySQL database from java code.
I use Process for running a batch file and i need to roleback if there were any exceptions.
How can I track the exceptions?
Is there any way doing it with jdbc "Statements"?
The Problem is that The Procces can be successful because it ran the command but I can't know wether the command ran well.
Oh, now I see the point.
Wel, it depends on batchfile and the process. What exactly does the batchfile? Is there any output from the batchfile? Does the process exit with -1 if there is any error? Etcetera.
I realy prefer using Java Statements if there is any way doing that, and control the exceptuions with JDBC instead of Procces
At the moment the command I run is:
mysql -h localhost -u Username -pPassword db_name < dump_file_name.sql
