Ask Your Question

Do the JDBC Lookup and JDBC producer support Oracle bind variables?

asked 2019-11-18 08:15:53 -0500

Rahul061204 gravatar image

updated 2019-11-18 13:03:00 -0500

jeff gravatar image

We are having a requirement to use oracle bind variable to run any queries onto oracle Database, it will skip the query parsing and planning and improve the performance. I have checked but didn't find anything , Please help if it is feasible in StreamSets.

edit retag flag offensive close merge delete


I noticed you already opened the Jira here.

jeff gravatar imagejeff ( 2019-11-18 13:04:20 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2019-11-20 11:57:19 -0500

Tarun Kumar gravatar image

updated 2019-11-20 18:44:18 -0500

iamontheinet gravatar image

StreamSets internally uses bind variables when we use oracle jdbc producer to publish records. Enable debug mode to see queries generated by streamsets which are being fired on oracle db.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-18 08:15:53 -0500

Seen: 88 times

Last updated: Nov 20 '19