Talend - Snowflake and MySQL tSetKeystore issue

LisaHourmand — Thu, 27 Mar 2025 15:03:19 GMT

Hi,

In Talend Cloud, I have a job with a connection to two databases:

Snowflake connection using key pair authentication
MySQL connection using user and password authentication

Technical details:

I'm using a tSetKeystore component to store the private key file in the prejob
The current configuration causes connection issues when components are ordered as: tSetKeystore -> tDBConnection (Snowflake) -> tDBConnection (MySQL)
When I change the order to: tDBConnection (MySQL) -> tSetKeystore -> tDBConnection (Snowflake) The job works successfully.

My hypothesis is that the tSetKeystore component modifies JVM parameters, which interferes with the MySQL connection. To validate this:

If I isolate the connections in separate subjobs, the connection fails
Clicking "Use an independent process to run subJob" resolves the issue by resetting JVM parameters

Questions:

Can you provide a solid explanation for why JVM parameters affect the MySQL connection?
Is there a clean way to launch the job without changing the component order?

The current workaround is suboptimal, as it would require establishing a MySQL connection at the job's beginning, potentially maintaining an unnecessary long-running database connection.

Would you like me to make any further modifications to the request?

Re: Talend - Snowflake and MySQL tSetKeystore issue

quentin-vigne — Tue, 01 Apr 2025 08:26:48 GMT

Hello @LisaHourmand

My guess is that since tSetKeyStore sets values for javax.net.ssl properties, it affects the components that follow.

Most recent MySQL versions use SSL connections by default.

Since the Java SSL environment has been modified, the MySQL JDBC driver inherits these changes from tSetKeyStore, which can impact the connection.

If possible, try adding the following parameter to the Additional Parameters section:

useSSL=false

This will disable SSL if your connection allows it.

Have a great day!

- Quentin

topic Talend - Snowflake and MySQL tSetKeystore issue in Talend Cloud

Talend - Snowflake and MySQL tSetKeystore issue

Re: Talend - Snowflake and MySQL tSetKeystore issue