Information/Help : JDBC importer parameters

[GeethaSravanthi]

Hi,

We 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 we have some questions regarding the database locks that happen during this activity.

1. Can we set transaction isolation type of parameters? If yes can you give me an example.
2. I see the options like "resultset_type" , "resultset_concurrency". Can you please explain them and what each value in them represents?
3. 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,
Geetha.