ETL- JDBCOutput error

0

Hi all! 

I have trouble with my JDBC job. I am trying to create job using JDBC items. Job runs fine until it reachs tJDBCOutput. When I run it, system warns me about erors: pstmt_tJDBCOutput_1 cannot be resolved/ cannot be resolved to a variable respectively.  

When I click continue the job will fail with exception: 

Exception in thread "main" java.lang.Error: Unresolved compilation problems: 
pstmt_tJDBCOutput_1 cannot be resolved
pstmt_tJDBCOutput_1 cannot be resolved to a variable
pstmt_tJDBCOutput_1 cannot be resolved
 
at local_project.jdbcjob_0_1.JDBCJOB.tJDBCInput_1Process(JDBCJOB.java:980)
at local_project.jdbcjob_0_1.JDBCJOB.tJDBCConnection_1Process(JDBCJOB.java:726)
at local_project.jdbcjob_0_1.JDBCJOB.runJobInTOS(JDBCJOB.java:4198)
at local_project.jdbcjob_0_1.JDBCJOB.main(JDBCJOB.java:3983)
 
respectively:
Error in the component's properties:pstmt_tJDBCOutput_1 cannot be resolved
pstmt_tJDBCOutput_1 cannot be resolved to a variable
 
 
Do you have any ideas, what could cause this error?
Thank you very much
Filip
filip.guzma's picture
Joined: Aug 18 2015 - 2:47am
Last seen: 3 years 1 month ago

1 Answer:

0

Solved! 

I just had to clean all warnings from previous elements

filip.guzma's picture
Joined: Aug 18 2015 - 2:47am
Last seen: 3 years 1 month ago
Feedback