> For the complete documentation index, see [llms.txt](https://driftserver.gitbook.io/drift-server/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://driftserver.gitbook.io/drift-server/use/get-started/configuration/jdbc-connections.md).

# 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

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

    tableNames:
    - CUSTOMER
    - PRODUCT
    - SUPPLIER
```

{% hint style="info" %}
Do not forget to add

```yaml
!<JDBCConnectionDetails>
```

This is used by the jackson yaml parser to resolve the polymorphic type of the connection details.&#x20;
{% endhint %}

### Testing the connection settings

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

![Successfull connectivity test for LOCAL environment](https://2718803548-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LWAEKm9JcXd3RYhXC5W%2F-LkxE-wX2UJkD85IPuIm%2F-LkxHLTlMtxAdSxkh_5y%2Fsystemconnections.png?alt=media\&token=036d5cc3-428d-44eb-b338-f62c1d704488)

![Unsuccesfull connectivity test: wrong password ](https://2718803548-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LWAEKm9JcXd3RYhXC5W%2F-Ll28RlZIgfvHV1LjD2V%2F-Ll2NX_IjfRfMod1eu2P%2Fsystemconnections-problem.png?alt=media\&token=37523a5f-d18c-4405-af0a-6d9a9e2110c8)