I would like to use elastic jdbc importer for pulling data from our traditional rdbms to elastic and search on it.
I was able to do that successfully but have some questions regarding the database locks that happen during this activity.
- Can we set transaction isolation type of parameters? If yes can you give me an example.
- I see the options like "resultset_type" , "resultset_concurrency". Can you please explain them and what each value in them represents?
- I would like to use Uncommitted ReaD(UR) or Cursor Statbility(CS) isolation level on db while using this. Let me know the exact steps please.
Thanks and Regards,