Yes it is the same issue.
But the solution is proposed according to me does not solve the problem or if it solves, it is still a wrong url.
The syntax of JDBC URL is
jdbc:mysql://[host1][:port1][,[host2][:port2]]...[/[database]] »
[?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]
Or
jdbc:mysql://address=(key1=value)[(key2=value)]...[,address=(key3=value)[(key4=value)]...]...[/[database]]»
[?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]
https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html
Proposed one is jdbc:mysql://localhost:3306/@DBNAME@?autoReconnect=true&sessionVariables= <mysql://localhost:3306/@DBNAME@?autoReconnect=true&sessionVariables=default_storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8>default_storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8 <mysql://localhost:3306/@DBNAME@?autoReconnect=true&sessionVariables=default_storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8>
https://github.com/openmrs/openmrs-core/pull/1625/commits/35180edc9e3664ed6549ab58cdd8419ca8f8aaf2
You realize that session variables is a different property from storage engine, so & sign is supposed to separate each property which is not the case with proposed url
Also the default_storage_engine is not a session variable, but innoDB is a storage engine.
I suggest you remove sessionVariables property since it always empty, because based on mysql documentation, sessionVariables is supposed to be key_value pair separated by comma.
