• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to run/access Unix scripting reports from a webserver using Java  RSS feed

 
Jack Bush
Ranch Hand
Posts: 235
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am wondering whether it is possible to run some Unix (Solaris 10 - Korne,Cshell, AWK) scripting reports (third-party proprietary SQLs) in Java and have them available on a webserver? These scripts are currently being run through the old ASCII Wy60 Terminal Emulation which prompts for selections such as start-date and end-date to narrow down the search.

Runtime.exec() and ProcessBuilder class can achieve some of this objective but not sure whether it is the best way to do this.

I am wondering whether it would be easier to do it on Java EE 5 platform where we could use JPA to store these criteria and associate them to the correct report?

This question has been posted on http://forums.sun.com/thread.jspa?threadID=5383411 for nearly a week but received no response.

Any suggestion would be appreciated.

Thanks,

Jack
 
Henry Wong
author
Sheriff
Posts: 23295
125
C++ Chrome Eclipse IDE Firefox Browser Java jQuery Linux VI Editor Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

My preference would be to modify the original script to take the dates as parameters, instead of prompting for them -- this way, you can write a new script that can easily automate everything.

If modifying the original script is not an option, then using "expect" in the new script would work great (admittingly, I am a fan of "expect", so my view may be tainted).

With this new script, Runtime.exec() would be easy.

Henry
 
Jack Bush
Ranch Hand
Posts: 235
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Henry,

Both of your suggestions are good. I will experiment on which one is most suitable to my organization as the project unfold.

Much appreciated for your comment,

Jack
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!