Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issues with neo4j on graphenedb

I'm trying to connect to a neo4j database held with graphenedb via qlik.

I've setup the jdbc drivers and have the following statement but getting rejected due to an unrecognized token if I use http rest, and failed to establist SSLconnection when connecting with bolt.

Can anyone help with this please?

HTTP Rest:

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:neo4j:https://hobby-xxxx.dbs.graphenedb.com:24780/db/data/;XUserId=xxxx;XPassword=xxxx;";

sql match(n) return n

Custom connector error

Connector reply error: java.sql.SQLException: java.sql.SQLException: com.fasterxml.jackson.core.JsonParseException: Unrecognized token 'Invalid': was expecting 'null', 'true', 'false' or NaN
at [Source: org.apache.http.conn.EofSensorInputStream@7f831352; line: 1, column: 9]
at org.neo4j.jdbc.http.driver.CypherExecutor.executeHttpRequest(CypherExecutor.java:344)
at org.neo4j.jdbc.http.driver.CypherExecutor.executeQueries(CypherExecutor.java:152)
at org.neo4j.jdbc.http.driver.CypherExecutor.executeQuery(CypherExecutor.java:163)
at org.neo4j.jdbc.http.HttpConnection.executeQuery(HttpConnection.java:92)
at org.neo4j.jdbc.http.HttpStatement.execute(HttpStatement.java:58)
at org.neo4j.jdbc.http.HttpStatement.executeQuery(HttpStatement.java:45)
Caused by: java.sql.SQLException: com.fasterxml.jackson.core.JsonParseException: Unrecognized token 'Invalid': was expecting 'null', 'true', 'false' or NaN
at [Source: org.apache.http.conn.EofSensorInputStream@7f831352; line: 1, column: 9]
at org.neo4j.jdbc.http.driver.Neo4jResponse.<init>(Neo4jResponse.java:105)
at org.neo4j.jdbc.http.driver.CypherExecutor.executeHttpRequest(CypherExecutor.java:333)
... 5 more
Caused by: com.fasterxml.jackson.core.JsonParseException: Unrecognized token 'Invalid': was expecting 'null', 'true', 'false' or NaN
at [Source: org.apache.http.conn.EofSensorInputStream@7f831352; line: 1, column: 9]
at com.fasterxml.jackson.core.JsonParser._constructError(JsonParser.java:1586)
at com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(ParserMinimalBase.java:521)
at com.fasterxml.jackson.core.json.UTF8StreamJsonParser._reportInvalidToken(UTF8StreamJsonParser.java:3466)
at com.fasterxml.jackson.core.json.UTF8StreamJsonParser._reportInvalidToken(UTF8StreamJsonParser.java:3444)
at com.fasterxml.jackson.core.json.UTF8StreamJsonParser._matchToken(UTF8StreamJsonParser.java:2765)
at com.fasterxml.jackson.core.json.UTF8StreamJsonParser._handleUnexpectedValue(UTF8StreamJsonParser.java:2609)
at com.fasterxml.jackson.core.json.UTF8StreamJsonParser._nextTokenNotInObject(UTF8StreamJsonParser.java:854)
at com.fasterxml.jackson.core.json.UTF8StreamJsonParser.nextToken(UTF8StreamJsonParser.java:748)
at com.fasterxml.jackson.databind.ObjectMapper._initForReading(ObjectMapper.java:3828)
at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:3773)
at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2849)
at org.neo4j.jdbc.http.driver.Neo4jResponse.<init>(Neo4jResponse.java:80)
... 6 more

BOLT:

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:neo4j:bolt://hobby-xxxx.dbs.graphenedb.com:24786;XUserId=xxxx;XPassword=xxxx;";

sql match(n) return n

Custom connector error

Connector reply error: java.sql.SQLException: N/A: Failed to establish SSL socket connection.
at org.neo4j.jdbc.bolt.BoltStatement.wrapException(BoltStatement.java:91)
at org.neo4j.jdbc.bolt.BoltStatement.executeQuery(BoltStatement.java:86)
Caused by: org.neo4j.driver.v1.exceptions.ClientException: Failed to establish SSL socket connection.
at org.neo4j.driver.internal.connector.socket.TLSSocketChannel.unwrap(TLSSocketChannel.java:179)
at org.neo4j.driver.internal.connector.socket.TLSSocketChannel.read(TLSSocketChannel.java:374)
at org.neo4j.driver.internal.connector.socket.BufferingChunkedInput.readNextPacket(BufferingChunkedInput.java:408)
at org.neo4j.driver.internal.connector.socket.BufferingChunkedInput.readChunkSize(BufferingChunkedInput.java:344)
at org.neo4j.driver.internal.connector.socket.BufferingChunkedInput.read(BufferingChunkedInput.java:246)
at org.neo4j.driver.internal.connector.socket.BufferingChunkedInput.fillScratchBuffer(BufferingChunkedInput.java:215)
at org.neo4j.driver.internal.connector.socket.BufferingChunkedInput.readByte(BufferingChunkedInput.java:109)
at org.neo4j.driver.internal.packstream.PackStream$Unpacker.unpackStructHeader(PackStream.java:441)
at org.neo4j.driver.internal.messaging.PackStreamMessageFormatV1$Reader.read(PackStreamMessageFormatV1.java:397)
at org.neo4j.driver.internal.connector.socket.SocketClient.receiveOne(SocketClient.java:129)
at org.neo4j.driver.internal.connector.socket.SocketClient.receiveAll(SocketClient.java:123)
at org.neo4j.driver.internal.connector.socket.SocketConnection.receiveAll(SocketConnection.java:121)
at org.neo4j.driver.internal.connector.socket.SocketConnection.sync(SocketConnection.java:100)
at org.neo4j.driver.internal.connector.ConcurrencyGuardingConnection.sync(ConcurrencyGuardingConnection.java:122)
at org.neo4j.driver.internal.pool.PooledConnection.sync(PooledConnection.java:116)
at org.neo4j.driver.internal.InternalTransaction.close(InternalTransaction.java:110)
at org.neo4j.jdbc.bolt.BoltStatement.executeInternal(BoltStatement.java:68)
at org.neo4j.jdbc.bolt.BoltStatement.executeQuery(BoltStatement.java:80)

0 Replies