topic Re: issue with toracleinput in Talend Studio

issue with toracleinput

_AnonymousUser — Wed, 26 Aug 2015 10:36:30 GMT

Hi,

i have a toracleinput with a sql query in it and i would like the result to be written to a flat file from the input sqlquery. But it just creates a empty csv or xls file.

Re: issue with toracleinput

Anonymous — Thu, 27 Aug 2015 04:30:46 GMT

Hi b.ram85,

Could you please show us your job design screenshots into forum so that we can address your issue quickly.
What's the sql query in tOralceInput component?

Best regards
Sabrina

Re: issue with toracleinput

_AnonymousUser — Thu, 27 Aug 2015 08:42:04 GMT

Hi Sabrina,
Attached here is the image:

the sql query in toracleinput works fine when it doesnt have a count(*) function used in there. eg: select count(*) from tac_amc doesnt write the data to output file. But if we take out the count(*) function and use individual columns then it write's the data to outputfile. Is there any limitation ?
Regards

Re: issue with toracleinput

_AnonymousUser — Thu, 27 Aug 2015 09:34:12 GMT

xdshi wrote:
Hi b.ram85,

Could you please show us your job design screenshots into forum so that we can address your issue quickly.
What's the sql query in tOralceInput component?

Best regards
Sabrina

Hi Sabrina, thx for the reply. My query had some special characters, after changing them the job ran fine

Re: issue with toracleinput

_AnonymousUser — Thu, 27 Aug 2015 12:10:23 GMT

i have my query as this

"select \"COUNT(*)\"FROM TAC_AMC.flowmetercatcher"

it throws error, but when i use the query with exact column names as below:

"SELECT
TAC_AMC.flowmetercatcher.MOMENT,
TAC_AMC.flowmetercatcher.PID,
TAC_AMC.flowmetercatcher.FATHER_PID,
TAC_AMC.flowmetercatcher.ROOT_PID,
TAC_AMC.flowmetercatcher.SYSTEM_PID,
TAC_AMC.flowmetercatcher.PROJECT,
TAC_AMC.flowmetercatcher.JOB,
TAC_AMC.flowmetercatcher.JOB_REPOSITORY_ID,
TAC_AMC.flowmetercatcher.JOB_VERSION,
TAC_AMC.flowmetercatcher.CONTEXT,
TAC_AMC.flowmetercatcher.ORIGIN,
TAC_AMC.flowmetercatcher.LABEL,
TAC_AMC.flowmetercatcher.\"COUNT\",
TAC_AMC.flowmetercatcher.REFERENCE,
TAC_AMC.flowmetercatcher.THRESHOLDS
FROM TAC_AMC.flowmetercatcher"

what could be the reason?

Re: issue with toracleinput

Anonymous — Fri, 28 Aug 2015 08:57:28 GMT

Hi aesgs,

Can you use SELECT COUNT (*) FROM TAC_AMC.flowmetercatche query to write your data to output file successfully?

Best regards
Sabrina

Re: issue with toracleinput

_AnonymousUser — Fri, 28 Aug 2015 09:13:09 GMT

Hi Sabrina,

I tried using the query you have suggested, but still it doesnt work. Below is the error i see in there

[statistics] connecting to socket on port 4011
[statistics] connected
Exception in component tOracleInput_1
java.sql.SQLException: Invalid column type: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor
at oracle.jdbc.driver.GeneratedAccessor.getTimestamp(GeneratedAccessor.java:748)
at oracle.jdbc.driver.GeneratedStatement.getTimestamp(GeneratedStatement.java:360)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getTimestamp(GeneratedScrollableResultSet.java:1008)
at local.serveralive_0_1.serveralive.tOracleInput_1Process(serveralive.java:1498)
at local.serveralive_0_1.serveralive.runJobInTOS(serveralive.java:2394)
at local.serveralive_0_1.serveralive.main(serveralive.java:2251)
Best Regards,