How to add datasource url query parameters as application.properties?

Question

Is it possible to add datasource url parameters as an extra property? Or do I always have to append them directly to the url as query parameters?

Example:

spring.datasource.url=jdbc:mysql://localhost/test?useSSL=false&tinyInt1isBit=false

I'd prefer adding them, pseudocode:

spring.datasource.url.meta.useSSL=false
spring.datasource.url.meta.tinyInt1isBit=false

Possible somehow?

I don't think that's possible. Check this out https://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html find #DATASOURCE section. There are no more options after datasource.url — vanillaSugar, Sep 03 '18 at 13:02
@M.Deinum I'm using most recent `spring-boot` version, and `mysql` as ds. — membersound, Sep 03 '18 at 18:28
Mysql is your database NOT your DataSource. Need to know the implementation as with Hikari you can pass properties with spring.datasource.hikari.datasource-propertie.=value — M. Deinum, Sep 03 '18 at 19:26

score 5 · Accepted Answer · answered Sep 04 '18 at 07:38

5

With the hint of @M. Deinum, the following works:

spring.datasource.hikari.data-source-properties.useSSL=false
spring.datasource.hikari.data-source-properties.tinyInt1isBit=false

answered Sep 04 '18 at 07:38

membersound

1

you can accept your answer to indicate issue got solved – Ori Marko Sep 16 '18 at 13:17

1 Answers1