issue with toracleinput

[_AnonymousUser]

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. 

[Anonymous]

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

[_AnonymousUser]

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

[_AnonymousUser]

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

[_AnonymousUser]

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?

[Anonymous]

Hi aesgs,

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

Best regards
Sabrina

[_AnonymousUser]

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,