I just upgraded a customer installation from 2021.1 to 2022.1. Because of problems with the upgrade, I was forced to fully uninstall and reinstall the OL-Connect server.
I have a datamapper, which gets additional data from a mysql database. The relevant part of the script is:
var connectionString = "jdbc:mysql://host:3306/databaseName"; var conn = db.connect(connectionString, user, pass);
This worked for years without a glitch and still works, when I test it directly through the designer.
When I run it through the workflow, I get the following error:
W3001 : Error while executing plugin: HTTP/1.1 500 Internal Server Error - An unspecified error occurred which was caused by LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Wrapped java.sql.SQLException: No suitable driver found for jdbc:mysql://host:3306/databaseName (scriptname#scriptrow) (DM1000031) (SRV000012) (SRV000001)
Any pointers would be helpful!
thanks and best regards