1. 在java code中调用以下代码:
Process process = Runtime.getRuntime().exec(new String[] { "/bin/csh", "-c","zip -P "+alarmKey+" "+zipName+" "+fileName });
2. 在PLSQL环境下:
2.1.在PLSQL code中可以先创建以下Store Procedure去调用java source code:
CREATE OR REPLACE PROCEDURE host_command (p_command IN VARCHAR2)
AUTHID Current_User
AS LANGUAGE JAVA
NAME 'Host.executeCommand (java.lang.String)';
2.2.在数据库中定义以下java source code:
import java.io.*;
public class Host {
public static void executeCommand(String command) {
try {
String[] finalCommand;
if (isWindows()) {
finalCommand = new String[4];
// Use the appropriate path for your windows version.
finalCommand[0] = "C:\\windows\\system32\\cmd.exe"; // Windows XP/2003
//finalCommand[0] = "C:\\winnt\\system32\\cmd.exe"; // Windows NT/2000
finalCommand[1] = "/y";
finalCommand[2] = "/c";
finalCommand[3] = command;
}
else {
finalCommand = new String[3];
finalCommand[0] = "/bin/sh";
finalCommand[1] = "-c";
finalCommand[2] = command;
}
final Process pr = Runtime.getRuntime().exec(finalCommand);
pr.waitFor();
new Thread(new Runnable(){
public void run() {
BufferedReader br_in = null;
try {
br_in = new BufferedReader(new InputStreamReader(pr.getInputStream()));
String buff = null;
while ((buff = br_in.readLine()) != null) {
System.out.println("Process out :" + buff);
try {Thread.sleep(100); } catch(Exception e) {}
}
br_in.close();
}
catch (IOException ioe) {
System.out.println("Exception caught printing process output.");
ioe.printStackTrace();
}
finally {
try {
br_in.close();
} catch (Exception ex) {}
}
}
}).start();
new Thread(new Runnable(){
public void run() {
BufferedReader br_err = null;
try {
br_err = new BufferedReader(new InputStreamReader(pr.getErrorStream()));
String buff = null;
while ((buff = br_err.readLine()) != null) {
System.out.println("Process err :" + buff);
try {Thread.sleep(100); } catch(Exception e) {}
}
br_err.close();
}
catch (IOException ioe) {
System.out.println("Exception caught printing process error.");
ioe.printStackTrace();
}
finally {
try {
br_err.close();
} catch (Exception ex) {}
}
}
}).start();
}
catch (Exception ex) {
System.out.println(ex.getLocalizedMessage());
}
}
public static boolean isWindows() {
if (System.getProperty("os.name").toLowerCase().indexOf("windows") != -1)
return true;
else
return false;
}
};
2.3.在Store Procedure中调用:
-- The following command Use for HK site.
--host_command (p_command => '/usr/bin/zip -P ' || v_RPT_PWD || ' -j ' || v_directory_path || v_zip_file_name || ' '|| v_directory_path || v_data_file_name );
-- The following command Use for testing.
host_command (p_command => 'zip -j '|| v_directory_path || v_zip_file_name || ' '|| v_directory_path || v_data_file_name );