Resultset types in JDBC - posted by Nishant
What are different types of resultset in JDBC?
Answer
Resultset contains results of the SQL query. There are 3 basic types
of resultset.
Forward-only
As name suggest, this type can only move forward and are non-scrollable.
Scroll-insensitive
This type is scrollable which means the cursor can move in any direction. It is
insensitive which means any change to the database will not show change in the
resultset while it open.
Scroll-sensitive
This type allows cursor to move in any direction and also propagates the
changes done to the database.
Resultset types in JDBC - posted by Vidya Sagar
Explain the different types of resultset in JDBC.
The result of a SQL query is available in Resultset object. Resultsets are of 3
types.
Forward-only
This type of result set can make the traversal for rows only in the forward
direction and non-scrollable.
Scroll-insensitive
Scroll-insensitive result set are not capable for scrolling. That means the
cursor can move in only one direction. When the result set is open, any change
to the database table will not reflect.
Scroll-sensitive
Unlike Scroll-insensitive, the Scroll-sensitive result set is capable to move
the cursor in bidirectional. It also enables the changes done to the database
tables when open.
More JDBC Links
Answer - If you execute a query at time T1 and re-execute it at
time T2, additional rows may have.....
Answer - Businesses can continue to use their installed
databases and access.....
Answer - When you have loaded a driver, it is available for
making a connection with a DBMS......
Answer - The values are defined in the class
java.sql.Connection and are: ......
|
