I tested this out with a fresh install of Ignition Maker 8.1.0-final and MySQL 8.0.22 using the mysql-connector-java-8.0.22 JDBC driver. I had no trouble adding a database connection to this DB as well as a DB User Source Profile with automatic mode set. I left the connection properties on the driver as well as the Translator settings as default the way they were installed (and it doesn’t look like these defaults have changed recently). Are you sure your JDBC driver is pointing to the correct translator and the column quote character on that translator is ` and not " ? When I changed my translator’s column quote character to " (double quote) I saw the same exact exception in my logs that you are seeing in yours.
1 Like