what are the types of result sets in JDBC 3.0 ?
Answers were Sorted based on User's Feedback
Answer / sangeeta
There are 3 types of result sets in JDBC 3.0
1)forward-only
2)scroll-sensitive
3)scroll-insensitive
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / a.srinivas rao
there are three tyesof result sets in jdbc
1.resultset 1.0
2.resultset 2.0
3.rowset (resultset3.0 )
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / bawa
I think the first answer is correct. The type of a ResultSet object determines the level of its functionality in two areas: the ways in which the cursor can be manipulated, and how concurrent changes made to the underlying data source are reflected by the ResultSet object. Considering this factor, the sensitivity of the ResultSet object is determined by one of three different ResultSet types: TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE. View the Suns's official doc at http://java.sun.com/docs/books/tutorial/jdbc/basics/retrieving.html
Is This Answer Correct ? | 1 Yes | 0 No |
What is com mysql jdbc driver?
Write an sql to find all records having all upper case alphanumeric characters in a field ?
Explain some new features available in jdbc 4.0?
What are the main components of JDBC ?
How to set the attribute concurrency in resultset?
What do you mean by database connection pooling?
How can you use preparedstatement in jdbc?
What class.forname does, while loading the drivers?
What is jdbc driver manager?
What is savepoint in jdbc?
java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?