# JDBC connection to SQL database

**URL:** <https://community.siren.io/t/jdbc-connection-to-sql-database/71>\
**Category:** Siren Platform/Investigate Tech Support Community\
**Created:** [June 19, 2019, 9:01am UTC](https://community.siren.io/t/jdbc-connection-to-sql-database/71 "2019-06-19T09:01:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michele\_CamTv](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@Michele\_CamTv](https://community.siren.io/u/Michele_CamTv)\
**Post date:** [June 19, 2019, 9:01am UTC](https://community.siren.io/t/jdbc-connection-to-sql-database/71/1 "2019-06-19T09:01:59Z")

</div>

Dear all,

I am writing you to enquire about a problem I have with Siren Platform: I need to connect Siren to a MariaDB SQL database using a JDBC connection. However, apparently Siren is unable to connect to the SQL database as it doesn’t recognise any node: when I try to configure a JDBC datasource, I get the following error message:

Datasources Configuration Editor: There are no connector nodes with JDBC enabled that can process the request at this time. {“error”:{“root\_cause”:[{“type”:“exception”,“reason”:“There are no connector nodes with JDBC enabled that can process the request at this time.”}],“type”:“exception”,“reason”:“There are no connector nodes with JDBC enabled that can process the request at this time.”},“status”:500}

I was wondering whether I may ask your help in solving this problem? In case you need more information, I installed ‘siren-platform-no-data-no-security:10.2.1’ on a Windows machine.

Many thanks in advance for any hint.

All the best,  
Michele

---

<div class="post-metadata">

**Author:** ![ekeller](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/ekeller/32/40_2.png) [@ekeller](https://community.siren.io/u/ekeller)\
**Post date:** [June 19, 2019, 11:40am UTC](https://community.siren.io/t/jdbc-connection-to-sql-database/71/2 "2019-06-19T11:40:51Z")

</div>

Hi Michele,

Did you already enable JDBC on an ElasticSearch node ?

On the current version, the JDBC connector is not enabled by default.

To enable it, you have to add this setting in your elasticsearch.yml configuration file and restart the node:

```
node.attr.connector.jdbc: true

```

You will find additional information in our documentation:

[https://docs.support.siren.io/10.2.2/platform/en/siren-federate/connecting-to-jdbc-datasources/settings.html](https://docs.support.siren.io/10.2.2/platform/en/siren-federate/connecting-to-jdbc-datasources/settings.html)

Best,  
Emmanuel

---

<div class="post-metadata">

**Author:** ![Michele\_CamTv](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@Michele\_CamTv](https://community.siren.io/u/Michele_CamTv)\
**Post date:** [June 19, 2019, 12:58pm UTC](https://community.siren.io/t/jdbc-connection-to-sql-database/71/3 "2019-06-19T12:58:12Z")

</div>

Dear Emmanuel,

Many thanks for your kind reply.

That solved the problem! I enabled JDBC on the node following your suggestion, and that allowed me to configure the datasource.

Many thanks for taking the time to help me - I really appreciate it.

All the best,  
Michele