How to pass JDBC connection parameters (not by URL)

Sometimes your JDBC driver has the requirement to pass certain parameters as connection properties rather than via connection URL as below (see 2nd argument of JDBC driver getConnection function).

DriverManager.getConnection ( url , [properties] )

This can be done via the latest version of ZappySys ODBC PowerPack as below (must be v1.8.2 or higher).

  1. Expand Connection Parameters on JDBC Driver UI
  2. Add properties as needed (name and value)
  3. Click OK to save UI

image