Java Question

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Thu, 19 Oct 2006 10:30:38 -0400
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D46A72A@miaexc01.kanbay.com>

    First off, I'm pretty novice at Java so this could be a bit rudimentary but please bear with me. I've found and adapted the Java procedure on Ask Tom to run OS commands on Unix. Works rather well from Sql*Plus, but I want to bury calls to the procedure into some procedural code that needs to make decisions based on the output. The code I've got looks like:  

create or replace and compile
java source named "Util" as
import java.io.*;
import java.lang.*;
public class Util extends Object
{

   public static int RunThis(String args)    { Runtime rt = Runtime.getRuntime();

     int rc = 0;
     try


     { Process p = rt.exec(args);

       int bufSize = 4096;
       BufferedInputStream bis = new
BufferedInputStream(p.getInputStream(), bufSize);
       int len;
       byte buffer[] = new byte[bufSize];
       // Echo back what the program spit out
       while ((len = bis.read(buffer, 0, bufSize)) != -1)
       System.out.write(buffer, 0, len);
       rc = p.waitFor();
     }
     catch (Exception e)


     { e.printStackTrace();

       rc = -1; 
     } 
     finally


     { return rc;

     }

    }
}
/

In Sql*plus I get this displayed on the screen:  

Filesystem            kbytes    used   avail capacity  Mounted on
/dev/md/dsk/d2       12397228 3936915 8336341    33%    /
 

Now the procedure does return a 0, meaning that the Java executed normally and I am passing a 'df -k <mount_point>' to the prodecure (Solaris9). What I'd like the procedure to return is the available disk space remaining or 8336341. Anybody got any ideas??     

Dick Goulet, Senior Oracle DBA

45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795

RGoulet_at_kanbay.com
: POWERING TRANSFORMATION  

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 19 2006 - 09:30:38 CDT