topic Re: How to pass a database connection to a routine? in Talend Studio

How to pass a database connection to a routine?

Anonymous — Mon, 09 Dec 2013 09:00:37 GMT

Hi,
I would like to make a java routine that takes a database connection as a parameter.
How can I do that?
Sebastien

Re: How to pass a database connection to a routine?

Anonymous — Mon, 09 Dec 2013 09:23:59 GMT

Hi Sebastien
Use a txxxxConnection such as tMysqlConenction to create a DB connection in the job, and the pass this connection as a paramater to the routine like this:

YourRoutineName.methodName((java.sql.Connection) globalMap
						.get("conn_tMysqlConnection_1"))

The routine is defined as below, for example:

  public static void methodName(java.sql.Connection parameterName) {
        java.sql.Connection conn=parameterName;
       ...
    }

Shong

Re: How to pass a database connection to a routine?

Anonymous — Sun, 31 Aug 2014 17:55:25 GMT

Hello,
I would like to create a routine which would call a database stored function. Then I would use the routine in a tMap.
I have written the routine but the performance is very poor as a jdbc database connection is created for every call to the routine. I am aware about connection pooling in J2EE but do not know how to achieve that in Talend
What would be the best strategy to speed up the stored procedure call ?
Thanks for your ideas.
Lalaina

Re: How to pass a database connection to a routine?

Anonymous — Mon, 01 Sep 2014 19:08:35 GMT

Hi Irako,
it is not necessary to create a Connection for every record. This is a problem of your job design and not an issue of the solution shong provided. You could post your job design as screenshot, so we could make some suggestions.

Re: How to pass a database connection to a routine?

Anonymous — Wed, 16 Sep 2015 04:39:14 GMT

Hi Lalaina,
Would you mind attaching your job design screenshots into forum?
Feel free to let us know if there is any problem to upload screenshot.
Best regards
Sabrina