Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Neo4j Input configuration

Hi,

TOS BD 3.0
OS: several (Unbutu, Mac Os and Windows)
Neo4j 3.0

I'm trying to retrieve some data from NEO4j.
The job is easy:
Start Neo4j Connection => Neo4j Input => csv => close connection
I'm working with TOS DI with JDBC's driver 3.0 and it works fine using the same workflow but with JDBC connectors.

Developpers are starting to work with TOS BD as they only work with Neo4j db.
They have installed drivers for Neo4j as it is recommanded in TOS BD (drivers 2.3).
It doesn't work due to the column name.
The select is
MATCH (n:dailyHistory) RETURN n.date LIMIT 25
The schema is

Colonne => retourdate
Db column => date
Type => String

Where did they do wrong ? Are the 2.3 Neo4j drivers compatible with 3.0 database ?
Thanks for your feedback.
Regards,
Carlos
Labels (3)
10 Replies
Anonymous
Not applicable
Author

Hi,
What's the error message you are getting? Are you using talend bigdata V 6.3?
Best regards
Sabrina
Anonymous
Not applicable
Author

Here it is:
Exécution en erreur :Erreurs de compilation du Job
Au moins le Job "hopmedia_test_1" a des erreurs de compilation, réparez et réexportez.
Ligne en erreur: 801
Message détaillé: retourdate cannot be resolved to a variable
Il peut y avoir d'autres erreurs causées par la compatibilité avec la JVM. Vérifiez que les paramètres de votre JVM sont les mêmes que dans le studio.
In french sorry.
Anonymous
Not applicable
Author

May be it's better with a screenshot
0683p000009MCbl.png
Anonymous
Not applicable
Author

Hello,
Seems that nobody have an answer to my problem ?
Anonymous
Not applicable
Author

Hi,
There is compile error in your job. When you get some compile errors, please check your "Code" tab in your job. There will be your compile error highlighted in red line.
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi,
It's a input problem.
If i change the query to
MATCH (n:dailyHistory) RETURN n.date AS toto
AND change the mapping creating column and parameter to "toto", it still doesn't work.
0683p000009MCvK.png
The error code is "toto cannot be resolved to a variable".
Regards,
Carlos
Anonymous
Not applicable
Author

0683p000009MCvP.png
Anonymous
Not applicable
Author

Hi,
Is a simple query without " toto" parameter Ok with you? 
So far, talend bigdata support for Neo4j  1.X.X  2.X.X/2.2.X/2.3. Not sure that this issue is caused by this situation  3.0 database, 2.3   Neo4j drivers.
TalendHelpCenter0683p000009M9p6.pngupported systems databases and business applications by Talend components.
Best regards
Sabrina
Anonymous
Not applicable
Author

Thanks Sabrina for your reply.
Got a answer for my problem.
It was my fault because i had to write the return parameter with "".
Now i have another problem with drivers:
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.