How to Add Custom Parameters to a JDBC String

Goal

This article describes how custom parameters may be added to a JDBC connection in Datameer. For example, this technique could be used to enable the "tinybit" property in MySQL or to define username and password for MSSQL. 

Learn

In general, custom properties for JDBC may be added using the following designation

?property=value

Example 1

If one wanted to activate the tinybit as true in MySQL, the property to add would be as follows

?tinybit=1

Based on this property and the default MySQL JDBC connection pattern, here is the full connection pattern to use

jdbc:mysql://%host%:%port%/%database%?tinybit=1

Example 2

If one wanted to define the username and password for MSSQL, the property to add would be as follows

username=<user>;password=<pass>;

Based on this property and the default MSSQL JDBC connection pattern, here is the full connection pattern to use

jdbc:sqlserver://<host>:<port>;instance=MSSQLSERVER;DatabaseName=<database>;username=<user>;password=<pass>;