- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2024 02:35 PM
Greetings.
I'm attempting to perform some operations against a MySQL 8.0.33 server. I created a SnapLogic MySQL database account, and uploaded mysql-connector-j-8.0.33.jar to the JDBC driver property of the account configuration popup. Pressing the validate button shows a positive result. I can also confirm a valid connection from the MySQL side.
However, when I use this connection in a MySQL Execute snap, I receive an error: "com.snaplogic.api.ExecutionException: Jar file download failed : NOT FOUND."
There are no network obstructions. The username/password is absolutely correct and validated by multiple means.
Any ideas?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2024 04:31 AM
Yes, I experienced the same behavior.
When running a pipeline, the default action is to look for jar files directly in the project space, even if you selected an alternate location in the GUI when creating and validating the account. In my case, I have the jar file in a shared project space. The fix, it seems, is to provide the full path to the jar file in the account JDBC driver attribute. In my case, it looked like this:
ProductionInstance/IdentityManagement/shared/mysql-connector-j-8.0.33.jar
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-14-2024 09:02 PM
@brianmDid you browse to the driver jar location from the snap property, or did you copy and pasted the file name directly into the account configurations?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2024 03:10 AM
I browsed and uploaded from the snap property a few times. I also tried copy/paste. Same result either way.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2024 01:16 AM
Same issue here, with some interesting timeline:
- We want to connect to our MariaDB Maxscale database load balancer, using cyphered connection. This seems to require the Connector J, so we upload it, select it as JDBC JAR, provide the credentials, Validate the connection: all goes well.
- But then, pipeline fails, with following indication: "failure=Jar file download failed : NOT FOUND".
Now, the weird part:
- Coming back to Account, I remove the custom JAR line; now *validation still works* (when it didn't previously without the custome JAR file.)
- And the pipeline do not fail anymore!
I will open a support ticket on this; @brianm do you experience the same behavior?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2024 02:58 AM
For information, I just created support ticket #64963.
