Re: How to specify property IGNORE_SPACE in URL

[Filipe Silva]

Hi Prashant,

Try setting the URL as jdbc:mysql://localhost:3306/mydb?sessionVariables=SQL_MODE=IGNORE_SPACE.

Note that you have two errors in the URL:
1. You must use a `?` between the database name and properties sections, instead of `&`.
2. You must use the connection option `sessionVariables` to pass through any session settings - https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html

Mind that by setting this option explicitly you override other SQL_MODE options that are set by default and you may still need them. In order to avoid this you'll have to set all SQL_MODE options you need in the URL.

IHTH