Hello, not sure if anybody can help me with this but thought i'd try. I have an application that was originally written in Powerbuilder versio 7.0 years ago and has been runningsince about 1999. I converted it to Powerbuilder version 12.5 awhile back. The application uses an Oracle Database running on a Linux server. The application also currently calls a perl script running on the same server as the database. It calls the Perl script by calling a stored procedure on the database which then makes a system call and executes a shell script which then executes the Perl script.
Now, I need to move everything to new server(s). The database will be on a dedicated linux based database server. The Perl script will be on a different Linux server. The Perl script has also been rewritten as a Java program/class. So, I have two options, continue to run the Perl or try to call the Java version from Powerbuilder. To run the existing Perl it seems I will have to run it as a CGI script. To do this i'll need to run it from Powerbuilder by building a URL in Powerbuidler and calling it. My other option is to try and call the Java Class from Powerbuilder.
First of all is either of these ways possible and if so which would be the easiest/best way to do it. Are there any other better alternatives? Running it as a CGI will be more complicated because it will involve installing Perl on the server. The Perl script is very large and so far i'm getting Perl errors when trying to run it manually due to missing perl modules etc. I'm working with several things i'm not very familiar with on this app, the Perl and the Powerbuilder.
I'm thinking running it as a Java class will be better but I have no idea how to do something like this in Powerbuilder I'm not a Powerbuilder programmer and have only made minor changes in the past. If it's possible to call it as a Java class can someone please tell me how it's done. Would the java class file need to be in the directory with the Powerbuilder executable and runtime files etc. etc.?
I'm not sure if any of this made sense but any help anyone can give me would be greatly appreciated.