Neo4j Input configuration

One Star

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
Moderator

Re: Neo4j Input configuration

Hi,
What's the error message you are getting? Are you using talend bigdata V 6.3?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Neo4j Input configuration

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.
One Star

Re: Neo4j Input configuration

May be it's better with a screenshot
One Star

Re: Neo4j Input configuration

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

Re: Neo4j Input configuration

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Neo4j Input configuration

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
One Star

Re: Neo4j Input configuration

Moderator

Re: Neo4j Input configuration

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.
TalendHelpCenterSmiley Frustratedupported systems databases and business applications by Talend components.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Neo4j Input configuration

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.
One Star

Re: Neo4j Input configuration

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