topic Re: how to call a sql inside java routine in Talend Studio

how to call a sql inside java routine

_AnonymousUser — Mon, 16 Jul 2012 14:50:20 GMT

I am writing a java function that computes 4 business days from current date but excludes holidays and weekends.
My date_dim table stores holidays and weekend information. I have sql's to check if it's holiday or if it's
weekend. How to use date_dim information inside my java routine?

Re: how to call a sql inside java routine

Anonymous — Tue, 17 Jul 2012 03:25:08 GMT

Hi
You might get the holidays and weekend information by using DB components. Then save them into an java Array or some other data pattern in tJava and pass them into this java function.
It shouldn't be hard if you are familiar with Java programming.
Regards,
Pedro