When using the current version 5.1 of the JDBC stream application, receive driver error
search cancel

When using the current version 5.1 of the JDBC stream application, receive driver error

book

Article ID: 395789

calendar_today

Updated On:

Products

VMware Tanzu Spring Runtime

Issue/Introduction

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

Environment

Customer is using SCDF (Spring Cloud Data Flow).
The version of SCDF (Spring Cloud Data Flow) is 2.11.5

Resolution

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