Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Execute Process Task to execute a .jar Expand / Collapse
Posted Tuesday, May 21, 2013 12:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 2, 2013 11:57 AM
Points: 1, Visits: 13
I'm trying to run an Execute Process Task that initiates a java program. The error I receive when I run it in debug mode is: [Execute Process Task] Error: An error occurred with the following error message : “The specified executable is not a valid application for this OS platform.”. The Process fields in the Execute Process Task are filled out as follows:
RequireFullFileName = True
Executable = C:\Users\john.doe.corp\Desktop\Calc\rollupcalc.jar
Arguments = java -classpath .;rollupcalc.jar co.corp.Application filename.csv 12
WorkingDirectory = C:\Users\john.doe.corp\Desktop\Calc

All other fields are left at the default value.

Any and all help will be greatly appreciated.

Post #1455155
Posted Monday, May 27, 2013 8:19 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:15 AM
Points: 79, Visits: 243
I do not come from a Java background. I do not even know the suggestion below might help you or not but still putting my thought here.

I assume that you are running a Java Program. Can you run this Java Program using Command Prompt or simply by putting the program name(jar) and arguments in RUN window. If so I think you are on track.

Why not you create a batch file and put all the program name, arguments, working direcotry into it. Run that batch file from SSIS (Execute Process Task).

Vikash Kumar Singh ||
Post #1457111
Posted Thursday, May 30, 2013 4:45 AM



Group: General Forum Members
Last Login: Today @ 4:44 PM
Points: 7,933, Visits: 14,356
Windows does not know what to do with a file with a .jar extension by default. You will need to pass the path to the .jar into the JRE using a fully qualified path to the runtime (e.g. C:\Program Files\...etc...\java.exe) in your Execute Process Task and making the reference to the .jar file a command line argument.

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1458119
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse