Five Stars

How to give input to jar file and get output and store them in database

HI ,

I need to give data from Database to Jar file which will output and we need to store that output to database again.How can we do it?

4 REPLIES
Moderator

Re: How to give input to jar file and get output and store them in database

Hello,

Could you please give us more information about your requirement? Here is online document about:TalendHelpCenter:Creating an user routine and call it in a Job.

Feel free to let us know if it is what you are looking for?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: How to give input to jar file and get output and store them in database

Issue here is i created the user routine and added external jar file but the external jar file need to use property file which is available.How can we deal with it?

Five Stars

Re: How to give input to jar file and get output and store them in database

Use DB input component to read the data from Database (preferably row component ex: toraclerow) and pass it your jar file using using tjavarow/tjava flex via input methods defined in the jar files to pass the data and then use the output method to extracts the data from the jar then pass it on to a DB output component.

 

Flow

 

toraclerowinput--> Tjavarow or tjavaflex --> toracleoutput.

 

you may need to use additional component depending on how your jar file accepts/returns data.

 

Thanks

Ashok

    

One Star

Re: How to give input to jar file and get output and store them in database

this will work

tLibraryLoad --onComponenetOk-->tOracleInput--->tJavaFlex--->tOracleOutput