# Could not validate Neo4j datasource

**URL:** <https://community.siren.io/t/could-not-validate-neo4j-datasource/394>\
**Category:** Siren Platform/Investigate Tech Support Community\
**Created:** [July 11, 2021, 12:19pm UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394 "2021-07-11T12:19:51Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sara\_A](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/sara_a/32/207_2.png) [@Sara\_A](https://community.siren.io/u/Sara_A)\
**Post date:** [July 11, 2021, 12:19pm UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394/1 "2021-07-11T12:19:51Z")

</div>

Hi all,  
I have a problem in connecting siren to Neo4j database.  
When I built datasource, I got this error:

Datasources Configuration Editor: Could not validate datasource [neo4j\_datasource]. {“error”:{“root\_cause”:[{“type”:“exception”,“reason”:“Could not validate datasource [neo4j\_datasource].”}],“type”:“exception”,“reason”:“Could not validate datasource [neo4j\_datasource].”,“caused\_by”:{“type”:“s\_q\_l\_exception”,“reason”:“Some errors occurred : \n[Neo.ClientError.Statement.SyntaxError]:Invalid input ‘START’: expected \r\n “RETURN”\r\n “CREATE”\r\n “DELETE”\r\n “SET”\r\n “REMOVE”\r\n “DETACH”\r\n “MATCH”\r\n “WITH”\r\n “UNWIND”\r\n “USE”\r\n “CALL”\r\n “LOAD”\r\n “FROM”\r\n “FOREACH”\r\n “MERGE”\r\n “OPTIONAL”\r\n “USING” (line 1, column 1 (offset: 0))\r\n"START n=NODE(\*) MATCH (n) RETURN COUNT(n)”\r\n ^\n"}},“status”:500}

Please help me to resolve it.  
Thanks a lot

---

<div class="post-metadata">

**Author:** ![Manu\_Agarwal](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/manu_agarwal/32/120_2.png) [@Manu\_Agarwal](https://community.siren.io/u/Manu_Agarwal)\
**Post date:** [July 12, 2021, 9:25am UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394/2 "2021-07-12T09:25:43Z")

</div>

Hi Sara,

What version of Neo4j are you using? I’d recommend downloading Neo4j JDBC Driver [v3.4.0](https://mvnrepository.com/artifact/org.neo4j/neo4j-jdbc-driver/3.4.0) as stated in our [JDBC driver installation and compatibility](https://docs.support.siren.io/siren-federate-user-guide/20.0/siren-federate/connecting-to-remote.html#siren-federate-jdbc-compat) documentation.

It will good to test the connection as well.

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/siren/original/1X/2c75cdffd8a867371b21575089dff5bf21105548.png)

If this still doesn’t work please provide the details of ES , federate , Investigate version you are using and the Elasticsearch logs.

Regards  
Manu

---

<div class="post-metadata">

**Author:** ![Sara\_A](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/sara_a/32/207_2.png) [@Sara\_A](https://community.siren.io/u/Sara_A)\
**Post date:** [July 12, 2021, 11:36am UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394/3 "2021-07-12T11:36:39Z")

</div>

Thanks Manu,  
If it’s possible, help me about this setting. I can’t find where do I insert them and set them about Neo4j:

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/siren/original/1X/1f3d39b157dd31b978a4812950520090325a67aa.png)

---

<div class="post-metadata">

**Author:** ![Manu\_Agarwal](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/manu_agarwal/32/120_2.png) [@Manu\_Agarwal](https://community.siren.io/u/Manu_Agarwal)\
**Post date:** [July 12, 2021, 3:39pm UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394/4 "2021-07-12T15:39:20Z")

</div>

Hi Sara,

Please use this path to put the jdbc drivers of neo4j

`....elasticsearch/config/jdbc-drivers`

About the **drivers-security** , the file is available at this path:

`....elasticsearch\plugins\siren-federate`

Regards  
Manu

---

<div class="post-metadata">

**Author:** ![Sara\_A](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/sara_a/32/207_2.png) [@Sara\_A](https://community.siren.io/u/Sara_A)\
**Post date:** [July 13, 2021, 5:50am UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394/5 "2021-07-13T05:50:30Z")

</div>

Thanks Manu,  
Please tell me what is the permissions for neo4j:

grant codeBase “${codebase.federate.neo4j-jdbc-3.4.0.jar}” {  
// Permissions for neo4j-jdbc-3.4.0.jar  
}

---

<div class="post-metadata">

**Author:** ![Manu\_Agarwal](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/manu_agarwal/32/120_2.png) [@Manu\_Agarwal](https://community.siren.io/u/Manu_Agarwal)\
**Post date:** [July 14, 2021, 11:37am UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394/6 "2021-07-14T11:37:30Z")

</div>

Hi Sara,

You don’t need to add anything in the security file use the default file of security.

Current supported version of Neo4j by Siren is 3.5.x. Since the query formatter is changed from Neo4j version 4 , that’s why you are getting this error.

Please use these steps:

- Siren Investigate version [11.1.3](https://siren.io/downloads/?product=siren-platform)

- Neo4j JDBC Driver [v3.4.0](https://mvnrepository.com/artifact/org.neo4j/neo4j-jdbc-driver/3.4.0) and place at this location  
`....elasticsearch/config/jdbc-drivers`

- Download the Neo4j 3.5.x.

- Test the connection and create a Data Reflection Jobs

Note: Siren doesn’t support now Virtual Indices although you can use the Data Reflection Jobs

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/siren/original/1X/558c6180372b5d5fde830d7682d7da769cbcc4fc.png)  
 ![image](https://canada1.discourse-cdn.com/flex032/uploads/siren/original/1X/862cd502969a83b1ee4544e362f080cb49ae8eff.png)

Regards  
Manu

---

<div class="post-metadata">

**Author:** ![Sara\_A](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/sara_a/32/207_2.png) [@Sara\_A](https://community.siren.io/u/Sara_A)\
**Post date:** [July 14, 2021, 12:34pm UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394/7 "2021-07-14T12:34:36Z")

</div>

Hi  
Thanks Manu,  
I do this steps but I got this error:

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/siren/original/1X/58af4016f8904923010737518e552f3f727f634b.png)  
How can I resolve it?

---

<div class="post-metadata">

**Author:** ![Manu\_Agarwal](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/manu_agarwal/32/120_2.png) [@Manu\_Agarwal](https://community.siren.io/u/Manu_Agarwal)\
**Post date:** [July 16, 2021, 8:48am UTC](https://community.siren.io/t/could-not-validate-neo4j-datasource/394/8 "2021-07-16T08:48:47Z")

</div>

Hi Sara,

Have you tested the connection what happens at that?

Also please share the ES logs as well when this error comes on investigate.

Regards  
Manu
