Can't get a simple query working outside talend's sql builder

One Star

Can't get a simple query working outside talend's sql builder

This query works in Talend's
select FIELD from MACHIN.TRUC;
Returning the correct field
When saved and used within a job I get lot of sql errors (1)
All other queries on the same database work both within talend'd sqlbuilder and within a job.

Any Idea
---------------
(1)
Exception in component tOracleInput_1
java.sql.SQLSyntaxErrorException: ORA-00911: caractère non valide
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
at projetjet.connecteurphotosindividus_0_1.connecteurPhotosIndividus.tOracleInput_1Process(connecteurPhotosIndividus.java:363)
at projetjet.connecteurphotosindividus_0_1.connecteurPhotosIndividus.runJobInTOS(connecteurPhotosIndividus.java:659)
at projetjet.connecteurphotosindividus_0_1.connecteurPhotosIndividus.main(connecteurPhotosIndividus.java:530)
disconnected
Job connecteurPhotosIndividus terminé à 09:01 01/03/2011.
One Star

Re: Can't get a simple query working outside talend's sql builder

found.
The query can be ended with a ";" in Talend's , not in a job SQL component...