Netezza Connection

[Anonymous]

I am trying to connect to a Netezza DB and just do a simple query.
I am getting a successful connection in my tNetezzaInput component, because when I click the Table Name selector, I can choose my table from the database.
When I click "Guess Schema" it spins for a second and then I get an error "Failed to Generate Code".
If I put in my own query: "SELECT COL1 FROM RS_TEST2" and try and run the job, I get an error:
Execution failed : Failed to generate code.


------------------
Any help would be much appreciated!
Frank

[Anonymous]

Here is the output component.

[Anonymous]

Port number is integer column and not a string... remove double quotes
Is there any specific reason for having double quotes around col1??
Can you bring a query on single line and test again?

[Anonymous]

Removed double quotes from port number.
Removed double quotes from COL1 and put all all same line.
I still get the same error message.

[Anonymous]

Is Talend BD compatible with Java JRE 1.8?

[Anonymous]

See if instructions in following post helps you.
https://community.talend.com/t5/Installing-and-Upgrading/resolved-W8-installation-demo-priorTest-fai...
Vaibhav

[Anonymous]

The simple answer for anyone else following...
Talend BD is not compatible with Java 1.8. Uninstall all other versions of Java and Re-install 1.7 and this now works fine.
Frank

[Anonymous]

Thanks for BIG conclusion Frank.