topic Re: Neo4j Input configuration in Talend Studio

Neo4j Input configuration

Anonymous — Sat, 16 Nov 2024 10:09:38 GMT

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

Re: Neo4j Input configuration

Anonymous — Tue, 10 Jan 2017 03:25:02 GMT

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

Re: Neo4j Input configuration

Anonymous — Tue, 10 Jan 2017 15:51:11 GMT

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.

Re: Neo4j Input configuration

Anonymous — Wed, 11 Jan 2017 13:29:30 GMT

May be it's better with a screenshot

Re: Neo4j Input configuration

Anonymous — Mon, 16 Jan 2017 07:43:12 GMT

Hello,
Seems that nobody have an answer to my problem ?

Re: Neo4j Input configuration

Anonymous — Tue, 17 Jan 2017 10:05:31 GMT

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

Re: Neo4j Input configuration

Anonymous — Tue, 17 Jan 2017 12:56:47 GMT

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.

The error code is "toto cannot be resolved to a variable".
Regards,
Carlos

Re: Neo4j Input configuration

Anonymous — Wed, 18 Jan 2017 15:00:18 GMT

Re: Neo4j Input configuration

Anonymous — Thu, 19 Jan 2017 08:27:12 GMT

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.
TalendHelpCenterupported systems databases and business applications by Talend components.
Best regards
Sabrina

Re: Neo4j Input configuration

Anonymous — Thu, 19 Jan 2017 09:36:49 GMT

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.

Re: Neo4j Input configuration

Anonymous — Mon, 23 Jan 2017 13:28:19 GMT

Hi
I still have the problem:
Failed to instantiate SLF4J LoggerFactory
Reported exception:
java.lang.NoClassDefFoundError: org/slf4j/spi/LoggerFactoryBinder
    at java.lang.ClassLoader.defineClass1(Native Method)
    at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
    at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
    at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:411)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    at org.slf4j.LoggerFactory.bind(LoggerFactory.java:141)
    at org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:120)
disconnected
    at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:331)
    at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:283)
    at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:304)
I tried to download different drivers for but it stille doesn't work.
Where can i search more details because there is no problem for the module view ?
Thanks