topic Re: Can't get a simple query working outside talend's sql builder in Installing and Upgrading https://community.qlik.com/t5/Installing-and-Upgrading/Can-t-get-a-simple-query-working-outside-talend-s-sql-builder/m-p/2380499#M3712 found.<BR />The query can be ended with a ";" in Talend's , not in a job SQL component... Tue, 01 Mar 2011 08:33:49 GMT Anonymous 2011-03-01T08:33:49Z Can't get a simple query working outside talend's sql builder https://community.qlik.com/t5/Installing-and-Upgrading/Can-t-get-a-simple-query-working-outside-talend-s-sql-builder/m-p/2380498#M3711 This query works in Talend's<BR />select FIELD from MACHIN.TRUC;<BR />Returning the correct field <BR />When saved and used within a job I get lot of sql errors (1)<BR />All other queries on the same database work both within talend'd sqlbuilder and within a job.<BR /><BR />Any Idea<BR />---------------<BR />(1)<BR />Exception in component tOracleInput_1<BR />java.sql.SQLSyntaxErrorException: ORA-00911: caractère non valide<BR /> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)<BR /> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)<BR /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)<BR /> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)<BR /> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)<BR /> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)<BR /> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)<BR /> at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)<BR /> at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)<BR /> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)<BR /> at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)<BR /> at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)<BR /> at projetjet.connecteurphotosindividus_0_1.connecteurPhotosIndividus.tOracleInput_1Process(connecteurPhotosIndividus.java:363)<BR /> at projetjet.connecteurphotosindividus_0_1.connecteurPhotosIndividus.runJobInTOS(connecteurPhotosIndividus.java:659)<BR /> at projetjet.connecteurphotosindividus_0_1.connecteurPhotosIndividus.main(connecteurPhotosIndividus.java:530)<BR /> disconnected<BR />Job connecteurPhotosIndividus terminé à 09:01 01/03/2011. Sat, 16 Nov 2024 13:03:57 GMT https://community.qlik.com/t5/Installing-and-Upgrading/Can-t-get-a-simple-query-working-outside-talend-s-sql-builder/m-p/2380498#M3711 Anonymous 2024-11-16T13:03:57Z Re: Can't get a simple query working outside talend's sql builder https://community.qlik.com/t5/Installing-and-Upgrading/Can-t-get-a-simple-query-working-outside-talend-s-sql-builder/m-p/2380499#M3712 found.<BR />The query can be ended with a ";" in Talend's , not in a job SQL component... Tue, 01 Mar 2011 08:33:49 GMT https://community.qlik.com/t5/Installing-and-Upgrading/Can-t-get-a-simple-query-working-outside-talend-s-sql-builder/m-p/2380499#M3712 Anonymous 2011-03-01T08:33:49Z