Ask Your Question
0

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

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

Rahul061204 gravatar image

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

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

Comments

I noticed you already opened the Jira https://issues.streamsets.com/browse/SDC-12943 here.

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

1 Answer

Sort by ยป oldest newest most voted
0

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

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

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

Stats

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

Seen: 51 times

Last updated: Nov 20