Ask Your Question
1

Is it possible do a INSERT/UPDATE/DELETE in JDBC lookup processor

asked 2019-12-25 02:18:51 -0500

Dean Han gravatar image

updated 2020-01-07 10:53:54 -0500

metadaddy gravatar image

Hi ,

Is it possible do a INSERT/UPDATE/DELETE in JDBC lookup processor? As tested, I got the error as below:

Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.base.OnRecordErrorException: JDBC_02 - Exception executing query: ' insert into t_table2(id,stamp)values(22,null); insert into t_table2(id,stamp)values(23,null); ' - 'No results were returned by the query.'

Is there a solution to avoid this error?

Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2020-01-07 03:38:36 -0500

shixinbao gravatar image

jdbc lookup processor only supports select,jdbc producer processor can meet your needs

edit flag offensive delete link more

Comments

Thanks, you mean JDBC Tee? But I need to insert many records in one transaction one time. How to do with that?

Dean Han gravatar imageDean Han ( 2020-01-07 20:28:12 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-25 02:18:51 -0500

Seen: 67 times

Last updated: Jan 07