Java jdbc warning when using TYPE_SCROLL_ SENSITIVE -

this quoted oca/ocp java® se 7 programmer & ii study guide (exams 1z0-803 & 1z0-804) book :

for example, suppose mistakenly set result set type type_scroll_ sensitive when creating statement object. not create exception; instead, database handle situation chaining sqlwarning connection object , resetting type type_forward_only (the default) , continue on.

i don't know why setting statement of type type_scroll_ sensitive cause resetting type type_forward_only, missing anything?

as per above code setting type type_forward_only

connection conn = drivermanager.getconnection("jdbc:derby://localhost:1527/booksellerdb", "bookguy", "$3ller"); statement stmt = conn.createstatement(resultset.type_scroll_sensitive, resultset.concur_updatable); string query = "select * book book.format = 'hardcover'"; resultset rs = stmt.executequery(query); 

see here: https://docs.oracle.com/cd/a87860_01/doc/java.817/a83724/resltse2.htm#1018253

to produce scroll-sensitive result set:

• a query cannot use "select *". (but see workaround below.)
• a query can select single table.
• a query cannot use order by.

it continues:

if specified result set type or concurrency type not feasible, oracle jdbc driver uses following rules in choosing alternate types:

• if specified result set type type_scroll_sensitive, jdbc driver cannot fulfill request, driver attempts downgrade type_scroll_insensitive.
• if specified (or downgraded) result set type type_scroll_insensitive, jdbc driver cannot fulfill request, driver attempts downgrade type_forward_only.

ok, oracle database specific, shows example of downgrading.