# \[Neo.ClientError.Statement.SyntaxError

**URL:** <https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421>\
**Category:** Java\
**Created:** [September 16, 2020, 4:29am UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421 "2020-09-16T04:29:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandeep829490](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/sandeep829490/32/13803_2.png) [@sandeep829490](https://community.neo4j.com/u/sandeep829490)\
**Post date:** [September 16, 2020, 4:29am UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421/1 "2020-09-16T04:29:23Z")

</div>

Hi,  
i want to use sql query too load the data from neo4j using bi connector.for that i'm using driver(neo4j-jdbc-driver-3.1.0).i am able to get the data for cipher query but not for sql query.

While running below exception is coming.please guide me so that i can achieve it.  
"java.sql.SQLException: Some errors occurred :  
[Neo.ClientError.Statement.SyntaxError]:Invalid input 'l': expected 't/T' (line 1, column 3 (offset: 2))"

my code:

```auto
public static void main(String[] args) {
	JDBCTest test = new JDBCTest();
	try {
		Connection con = test.connectViaDMa();
		String cypherQuery ="select * from person";
		Statement stmt = (Statement) con.createStatement();
		ResultSet rs = stmt.executeQuery(cypherQuery);
		while (rs.next()) {
			System.out.println(rs.getString("person"));
		}
	} catch (Exception e) {
		e.printStackTrace();
	}
}
private static Connection connectViaDMa() throws Exception {
	Connection connection = null;
	String CONNECTION_URL = "jdbc:neo4j:http://localhost:7474/neo4j";
	
	Driver driver = new Driver();
	DriverManager.registerDriver(driver);
	connection = DriverManager.getConnection(CONNECTION_URL);
	System.out.println(connection.toString());

	return connection;
}

please let me know what i'm missing for this.
i am using neo database version About Neo4j Desktop
Version: 1.3.4

```

---

<div class="post-metadata">

**Author:** ![Cobra](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/cobra/32/35243_2.png) [@Cobra](https://community.neo4j.com/u/Cobra)\
**Post date:** [September 16, 2020, 7:06am UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421/2 "2020-09-16T07:06:11Z")

</div>

Hello @sandeep829490 🙂

```auto
String cypherQuery ="select * from person";

```

Is it normal that you are using an SQL query instead of a Cypher query? The error looks like a syntax error.  
Try:

```auto
MATCH (n) RETURN *

```

Regards,  
Cobra

---

<div class="post-metadata">

**Author:** ![sandeep829490](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/sandeep829490/32/13803_2.png) [@sandeep829490](https://community.neo4j.com/u/sandeep829490)\
**Post date:** [September 16, 2020, 8:24am UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421/3 "2020-09-16T08:24:28Z")

</div>

That i knew but i want to implement bi connector so that i can get the data from neo4j using basic sql query..So please help in that what are the drivers, databases version will be required. So that i can get data using sql query too.

---

<div class="post-metadata">

**Author:** ![sandeep829490](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/sandeep829490/32/13803_2.png) [@sandeep829490](https://community.neo4j.com/u/sandeep829490)\
**Post date:** [September 17, 2020, 9:23am UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421/4 "2020-09-17T09:23:28Z")

</div>

Hello @Cobra,  
Can you please guide me as i want to implement bi connector so that i can get data from neo4j database using sql query.  
For that i ma using simba Neo4jJDBC42 jar(version:1.0.5.1005 ) for bi connector and neo4j database of version 3.5.7 and 4.1.0 but i'm not able to load data using this driver.

Thanks  
Sandeep

---

<div class="post-metadata">

**Author:** ![Cobra](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/cobra/32/35243_2.png) [@Cobra](https://community.neo4j.com/u/Cobra)\
**Post date:** [September 17, 2020, 9:26am UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421/5 "2020-09-17T09:26:44Z")

</div>

Hello @sandeep829490 🙂

I'm afraid I can't help you, I never used BI connector and I didn't know it was possible to use SQL queries as well like this 😕

Regards,  
Cobra

---

<div class="post-metadata">

**Author:** ![sandeep829490](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/sandeep829490/32/13803_2.png) [@sandeep829490](https://community.neo4j.com/u/sandeep829490)\
**Post date:** [September 17, 2020, 10:38am UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421/6 "2020-09-17T10:38:08Z")

</div>

Hello @logan.ripplinger @neo4j_devrel  
@  
Can you please guide me as i want to implement bi connector so that i can get data from neo4j database using sql query.  
For that i ma using simba Neo4jJDBC42 jar(version:1.0.5.1005 ) for bi connector and neo4j database of version 3.5.7 and 4.1.0 but i'm not able to load data using this driver.

Thanks  
Sandeep

---

<div class="post-metadata">

**Author:** ![Joel](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/joel/32/17191_2.png) [@Joel](https://community.neo4j.com/u/Joel)\
**Post date:** [September 22, 2020, 7:27pm UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421/7 "2020-09-22T19:27:29Z")

</div>

Hi Sandeep,

It looks like this JDBC driver is a commercial product by Simba

> **[Magnitude](https://insightsoftware.com/magnitude/)**
>
> Helping enterprises transform data into continuous intelligence and competitive advantage, providing actionable insights to shorten the path from data to decision

have you reached out to the Simba support team to ask about the version pairs (driver versus neo4j) they support? I see that announcement is dated "July 28, 2020", so I imagine not many people have experience with this driver yet.

It sounds interesting, and I'd be curious how they map sql through to cypher (in a useful graph query way).

Regards,  
Joel

---

<div class="post-metadata">

**Author:** ![david\_allen](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/david_allen/32/13090_2.png) [@david\_allen](https://community.neo4j.com/u/david_allen)\
**Post date:** [September 28, 2020, 11:36am UTC](https://community.neo4j.com/t/neo-clienterror-statement-syntaxerror/25421/8 "2020-09-28T11:36:56Z")

</div>

@sandeep829490

Your connection URL is wrong: `jdbc:neo4j:http://localhost:7474/neo4j`

This should be instead `jdbc:neo4j://localhost`

Please consult the documentation for full reference on how to create the connect string with options.