使用Process调用Linux下的mysql命令，却执行不了

先看代码：

try { String mysqlQuery = "/usr/local/mysql/bin/mysql -h " + GlobalParam.HOST + " -u " + GlobalParam.USER + " -p/"" + GlobalParam.PASSWORD + "/"" + " --database=" + GlobalParam.DATABASENAME + " -e /"delete from " + tableName + " where "+ tableColumnName +" < /'"+deadLineTime+"/'/""; logger.info("Mysql command:" + mysqlQuery); String[] cmdArray = {"sh", "-c", mysqlQuery}; Runtime runTime = Runtime.getRuntime(); Process process = runTime.exec(cmdArray); Thread eThread = new RuntimeStreamOutput(process.getErrorStream()); Thread iThread = new RuntimeStreamOutput(process.getInputStream()); eThread.start(); iThread.start(); process.waitFor(); } catch(Exception e) { logger.error("Execute mysql command error:",e); e.printStackTrace(); }

RuntimeStreamOutput.java

public class RuntimeStreamOutput extends Thread { private static Logger logger = Logger.getLogger(RuntimeStreamOutput.class); private InputStream is; public RuntimeStreamOutput(InputStream is) { this.is = is; } public void run() { try { BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(is)); String ls; while((ls = bufferedReader.readLine())!=null) { logger.info("Process information:"+ls); } } catch(Exception e) { logger.error("Proccess Error:", e); } } }

从网上查找到的信息都是关于process产生的数据流造成了阻塞导致执行不下去的情况。我这里已经对这些流做了处理，可以正常跑完，但是mysql命令没有生效，不知为何，先记下，有结果再更新。

那位有什么建议请提供给我做做参考：）

 

补充说明一下，我在测试机器上做过测试，mysql中的数据是可以正常删除的。