Execute windows shell command from eBase?

[EDekker]

Hello,

Would it be possible to execute a windows shell command from an eBase script? I'm looking for a way to use Sox ( http://sox.sourceforge.net/ ) to convert .wav files.

Thanks,
Ed

[jig]

Hi Ed,

You can do this by creating and invoking your own Java class (which in-turn executes the cmd/shell command) from an Ebase script.

You have two options for invoking your Java class depending on your Ebase version.

Option 1) Via 'Ebase JavaScript':
a: Import your Java class in Ebase JavaScript and invoke it directly.
OR
b: Create Ebase Custom Resource (Java class) and invoke the same from Ebase JavaScript.

Option 2) Via 'Ebase FPL':
a: Create Ebase Custom Resource (Java class) and invoke the same from Ebase JavaScript.

Hope this helps!

Regards
Jignesh

[Jon]

You can do this with the Java Runtime class using Javascript on the server. Here is an example of a script that runs the Windows ver command.

Code: Select all

var p = java.lang.Runtime.getRuntime().exec("cmd /C ver");
var stdInput = new java.io.BufferedReader(new java.io.InputStreamReader(p.getInputStream()),8*1024);
var stdError = new java.io.BufferedReader(new java.io.InputStreamReader(p.getErrorStream()));

// read the output from the command
var s = null;
while ((s = stdInput.readLine()) != null)
{ 
	log(s);
}

I got this from StackOverflow via Google. You can convert pretty much any Java code so it can be executed in Javascript. Here's what the original Java code looks like:

Code: Select all

Process p = Runtime.getRuntime().exec("cmd /C ver");
BufferedReader stdInput = new BufferedReader(new InputStreamReader(p.getInputStream()),8*1024);
BufferedReader stdError = new BufferedReader(new InputStreamReader(p.getErrorStream()));

// read the output from the command
String s = null;
while ((s = stdInput.readLine()) != null)
{ 
   System.out.println(s);
}

To convert to Javascript, you need to:

o Replace the Java object names on the left-hand side of any assignment statements with Javascript "var".
o Add the fully qualified names of all Java classes (or use importPackage statements).
o Change any try/catch statements to Javascript format (there aren't any in this example).

I've also changed the System.out.println() statement to log() to see the output, but this is not a requirement to get it working.

You can use this approach to run pretty much all Java code.

Regards
Jon

[EDekker]

Thanks!