Saturday, May 31, 2008

Difference between Client-side & Server-side DB cursors?

Question: Difference between client side and server side DB cursors?

There is nothing like client side DB cursor. What you may think of a clinet side DB cursor is actually the current row of either the ResultSet in case of JDBC or the Result in case of ODBC. DB cursor is only a server side entity and it resides and runs only on the server. Read about DB Cursors in this article - Life Cycle of Cursors, Implicit vs Explicit, Static vs Dynamic >>


No comments: