What -Dconnection.url configuration properties/parameters are recommended when using MySql/MariaDB?

The connection properties mentioned above were used with the MySql driver connection urls. The MariaDB driver also has its own connection string parameters. All though, the examples didn't need any, that may not be the case for your configuration. These properties/parameters are different for each driver class/driver version.

These answers are from the perspective of using these properties to connect to a MySql QIE database. For the JDBC driver specific definitions please refer to the MySql/MariaDB references listed below.

useUnicode=true

Used to turn on support for unicode characters so that QIE can support the full range of characters that may be received in a message. Things like extended characters, international characters, and emojis. For more see: https://en.wikipedia.org/wiki/List_of_Unicode_characters

characterEncoding=UTF-8

Used with the above to specify the unicode character set to use. See: https://en.wikipedia.org/wiki/UTF-8

serverTimezone=[timezone matching your mysql instance]

Used to configure the driver to use the same timezone configured on the database server for transporting dates.

To find the server time zone execute this:

SELECT @@GLOBAL.time_zone, @@SESSION.time_zone, @@system_time_zone;

Note: The timezone configured on the server may need to be transalated to one that is recognized in java. For example if the database server is configured to use MDT then this should be converted to java equivalent America/Denver

See: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones

sslMode=DISABLED ()

Used to tell the driver not to use secure connections. If you need it configured otherwise see the driver and database documentation. If QIE is deployed behind a firewall secure connections are based on your internal requirements.

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.