When you create a stream with the 5.1 version of the JDBC source, you receive a driver error which is in the attached logs. This does not happen with version 3.2.1 of the JDBC application. Below is the stream definition that works without issue for version 3.2.1, but fails in version 5.1:
jdbc --query="select * from Compass.client_lookup;" --spring.datasource.driver-class-name="org.mariadb.jdbc.Driver" --spring.datasource.username=xxxxxxxx --spring.datasource.url="jdbc:mysql://example.com:3306/" --spring.datasource.password="**********" | log
Customer is using SCDF (Spring Cloud Data Flow).
The version of SCDF (Spring Cloud Data Flow) is 2.11.5
Customer added "permitMysqlScheme" to the connection string and then it worked
example: jdbc:mysql:localhost/test?permitMysqlScheme
Reference:
https://mariadb.com/kb/en/mariadb-connector-j-303-release-notes/#jdbcmariadb-scheme