Answer / sangeeta

There are 3 types of result sets in JDBC 3.0
1)forward-only
2)scroll-sensitive
3)scroll-insensitive

Answer / a.srinivas rao

there are three tyesof result sets in jdbc
1.resultset 1.0
2.resultset 2.0
3.rowset (resultset3.0 )

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

Can I use JDBC to execute non-standard features that my DBMS provides?

0 Answers  

---

Explain what should be done when a SQL exception is raised?

0 Answers  

---

Differentiate between a statement and a preparedstatement.

0 Answers  

---

What do you mean by two phase commits?

0 Answers  

---

What is batch processing and how to perform batch processing in jdbc?

0 Answers  

---

---

Does jdbctemplate use prepared statements?

0 Answers  

---

Statement, PrepareStatement and Callable all these are interfaces. Thought it is a interface how come we are creating objects and calling methods("preparestatement()") in it. In which class this method is defined. Please let me know. Thanks in advance. example: PreparedStatement pre = con.prepareStatement( "UPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ?");

2 Answers  

---

What is data source in java?

0 Answers  

---

What is the difference between executing, executequery, executeupdate in jdbc?

0 Answers  

---

Which interface handles transaction management in jdbc?

0 Answers  

---

How to update a resultset programmatically?

0 Answers  

---

What is com mysql jdbc driver?

0 Answers  

---