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.
