topic Re: Do we have to close the database connection explicitly? in Talend Studio

Do we have to close the database connection explicitly?

mgchong — Sat, 16 Nov 2024 10:09:52 GMT

Hi Guys,
I am using mysql database. The connection property is defined via Repository. Do we need to close the database connection explicitly? If yes, how can we achieve that? Thanks.

Re: Do we have to close the database connection explicitly?

Anonymous — Fri, 06 Jan 2017 10:39:16 GMT

Hi,
Do you want to mask your DB connection parameters? If you have defined you database connection in Metadata then you can use the "Export as Context" button in the DB connection page to create an initial context group to mask your info.
Please take a look at my screenshots
Best regards
Sabrina

Re: Do we have to close the database connection explicitly?

mgchong — Sun, 08 Jan 2017 04:43:03 GMT

Hi Sabrina,
Yes, I am using metadata. My question was do we need to close database connection in the process e.g using tmysqlclose or tmysqlcommit? Thanks.
Regards,
MG