Hi. I followed the examples from the recent thread on the issue and have found limited success. I can get the java to run commands such as mkdir, rmdir and ls, but when trying to execute a shell script or create a file via "echo hello >> steven.out" it fails.

When I call the java class from the OS, the shell script runs fine.

I have assigned read, write and execute permissions on the shell script and the /usr/bin directory. I have assigned writeFilePermissions as well. Please could you have a quick look over what I have done and possibly suggest what I have forgotten or done wrong?

Java Class:

import java.io.*;

public class ExecCommand
{
public ExecCommand()
{
}

static public int runCommand(String cmd) throws IOException
{
// start command running
Process proc = Runtime.getRuntime().exec(cmd);

// wait for command to terminate
try
{
proc.waitFor();
}
catch (InterruptedException e)
{
System.err.println("process was interrupted");
return -1;
}

// check its exit value
if (proc.exitValue() != 0)
{
System.err.println("exit value was non-zero");
return -2;
}

// return success
return 0;
}

public static void main(String args[]) throws IOException
{
String cmdString = args[0];
System.out.println("command string is: " + cmdString);

try
{
//run a command
int retVal = runCommand(cmdString);

System.out.println("return value is: " + retVal);
}
catch (IOException e)
{
System.err.println(e);
}
}
}

** Note: when the call fails, it is always a -2 returned.

Procedure in the Database:

CREATE OR REPLACE FUNCTION Exec_Command(Command IN STRING)
RETURN NUMBER IS
LANGUAGE JAVA
NAME 'ExecCommand.runCommand(java.lang.String) return int';
/

The code:

DECLARE
RetVal NUMBER;

BEGIN
RetVal := SOSSIX.EXEC_COMMAND ( '/usr/bin/mkdir /home/stevenh/extracts/mydir' );
END;

-- creates a directory OK.

The code:

DECLARE
RetVal NUMBER;

BEGIN
RetVal := SOSSIX.EXEC_COMMAND ( '/usr/bin/sh /home/stevenh/extracts/post_files.sh c' );
END;

-- does not produce anything. A log file should be created when the shell script is run. The value c is a required parameter.

The following grants have been issued:

exec dbms_java.grant_permission('SOSSIX','java.io.FilePermission','/home/stevenh/extracts/-','read');
exec dbms_java.grant_permission('SOSSIX','java.io.FilePermission','/home/stevenh/extracts/-','execute');
exec dbms_java.grant_permission('SOSSIX','java.io.FilePermission','/home/stevenh/extracts/-','write');
exec dbms_java.grant_permission('SOSSIX','java.io.FilePermission','/usr/bin/*','execute');
exec dbms_java.grant_permission('SOSSIX','java.io.FilePermission','/tmp/sh*','read,execute');
exec dbms_java.grant_permission('SOSSIX','java.lang.RuntimePermission','*','writeFileDescriptor');
exec dbms_java.grant_permission('SOSSIX','java.lang.RuntimePermission','*','readFileDescriptor');

GRANT JAVADEBUGPRIV TO SOSSIX;
GRANT JAVAIDPRIV TO SOSSIX;
GRANT JAVASYSPRIV TO SOSSIX;
GRANT JAVAUSERPRIV TO SOSSIX;
GRANT JAVA_ADMIN TO SOSSIX;
GRANT JAVA_DEPLOY TO SOSSIX;


If I am on the AIX system, I can run:

java ExecCommand "sh post_files.sh c"

The shell script runs and the log file is created. Return code is 0.

Many thanks for any help given.

Steven.