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.
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)
