JDBC Connections

Add JDBC Driver

Drift Server comes with the H2 database driver pre-installed. For other jdbc drivers you need to add the vendor specific jdbc driver to the lib directory

Add jdbc connection details to systemdescription.yaml

sample yaml snippet

PRODUCTSDB::LOCAL: !<JDBCConnectionDetails>
  
    userName: user1
    password: pwd
    jdbcUrl: jdbc:h2:tcp://localhost/./test2

    tableNames:
    - CUSTOMER
    - PRODUCT
    - SUPPLIER

Do not forget to add

!<JDBCConnectionDetails>

This is used by the jackson yaml parser to resolve the polymorphic type of the connection details.

Testing the connection settings

You can verify the connection settings in the "System Connections" page by clicking "Test" button.

Successfull connectivity test for LOCAL environment

Unsuccesfull connectivity test: wrong password