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.
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.
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?
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.
07-29-2024 01:16 AM
Same issue here, with some interesting timeline:
Now, the weird part:
I will open a support ticket on this; @brianm do you experience the same behavior?
07-29-2024 02:58 AM
For information, I just created support ticket #64963.