What I meant was to only remove the file name because you are specifying the key in the key store. So:
Original Message:
Sent: Thu October 09, 2025 03:16 AM
From: Mukes Behera
Subject: Snowflake jdbc connection in webMethods on-prem
Hello @Theo Ezell,
I did try with configuration that you mentioned still getting the same error. but when I added authenticator property as SNOWFLAKE_JWT I am getting invalid private key error.
Configuration :
| Transaction Type | NO_TRANSACTION |
| Driver Group | Default |
| DataSource Class | net.snowflake.client.jdbc.SnowflakeBasicDataSource |
| Server Name | |
| User | |
| Password | |
| Database Name | |
| Port Number | |
| Network Protocol | |
| TrustStore Alias/File Path | |
| TrustStore Password | ****** |
| KeyStore Alias/File Path | FreshSF_Keystore |
| KeyStore Password | ****** |
| Other Properties | keyPairAuthN=true;user=demo_user;account=zercowp-mib82023.snowflakecomputing.com;warehouse=my_warehouse;db=my_database;schema=PUBLIC;role=demo_role;authenticator=SNOWFLAKE_JWT; |
Error :
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource SnowflakeConnector:fresh_sf.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.204] Cannot connect to the database with DataSource class "net.snowflake.client.jdbc.SnowflakeBasicDataSource".Private key provided is invalid or not supported: Use java.security.interfaces.RSAPrivateCrtKey.class for the private key
Note ; I am able to connect to snowflake using the same private key and same jar file from a java program.
Thanks and Regards,
Mukesh
------------------------------
Mukes Behera
Original Message:
Sent: Wed October 08, 2025 09:34 PM
From: Theo Ezell
Subject: Snowflake jdbc connection in webMethods on-prem
The first thing I notice is that you're specifying the key twice. According to the doc, this property should not be set: private_key_file=C:/SoftwareAG/IntegrationServer/conf/privatekey.pem
Configuring Adapter Connection to Use Key Pair Authentication for Snowflake Database - IBM Documentation
I'm not saying that's the answer but removing that param is the first thing I would try.
HTH.
------------------------------
Theo Ezell
Developer Evangelist
IBM
Original Message:
Sent: Wed October 01, 2025 02:28 AM
From: Mukes Behera
Subject: Snowflake jdbc connection in webMethods on-prem
Hello Team,
We are looking to establish jdbc connection with Snowflake with key pair authentication, unfortunately it is not working as expected, we have followed the instruction given in the documentation but still no luck, any one can help here?
Doc ref - Generating a Pair of Key Based Authentication - IBM Documentation
Error - Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Eric_SnowflakeConnector:sf_temp.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.204] Cannot connect to the database with DataSource class "net.snowflake.client.jdbc.SnowflakeBasicDataSource".Cannot create connection because password is missing in DataSource properties.
Below are my current setup :
KeyStore Alias :
user=demo_user;account=zercowp-mib82023.snowflakecomputing.com;warehouse=my_warehouse;db=my_database;schema=PUBLIC;role=demo_role;keyPairAuthN=true;private_key_file=C:/SoftwareAG/IntegrationServer/conf/privatekey.pem;
Note my key doesn't have any passkey and it is not encrypted.
------------------------------
Mukes Behera
------------------------------