Question

explain the difference between these two option concur_updatable and concur_read_only?

Answer 1

The ResultSet concurrency determines whether the ResultSet can be updated, or only read.
A ResultSet can have one of two concurrency levels:
1. ResultSet.CONCUR_READ_ONLY
2. ResultSet.CONCUR_UPDATABLE
CONCUR_READ_ONLY means that the ResultSet can only be read.
CONCUR_UPDATABLE means that the ResultSet can be both read and updated.