This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes previous & Last Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "previous & Last" Watch "previous & Last" New topic
Author

previous & Last

Abhay Kumar
Greenhorn

Joined: Jun 03, 2003
Posts: 15
Hi,
Using jdbc API, I tried using these methods:
previous(), next(), last()...
to scroll through the data.
But i am unable to do it.
Does this have to do anything with the drivers?
What can be the probable reason. Sytax is all correct
Help
Renju Philip
Greenhorn

Joined: Oct 28, 2002
Posts: 4
JDK provides us with interfaces. The implementation has to come from the drivers which we use. We need to see whether the driver has implemented these methods
Thanks
renju
Vamshi Krishna
Greenhorn

Joined: Apr 22, 2003
Posts: 4
When you load a JDBC driver, create a connection and then create a statement object with the following syntax,
If "con" is the connection object created.
Statement st= con.createStatement();
This is the default connection type we create. The default parameters internally passed with the create statement are
TYPE_SCROLL_FORWARD AND CONCUR_READ_ONLY
Hence you were uanble to use the JDBC2.0 API.
But to use JDBC2.0 API which provides you with a advantage of dual-moving and updatable result set, you should pass these parameters in the createStatement method to work with JDBC2.0 API.
Please write your create statement as:
Statement st= con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Now try any method in JDBC2.0 API, it works.
Also refer the link below for more information:
http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/cursor.html
Hope the above information will be helpful to you. If you need further help, please contect me. I will help you out it I can.
[ June 17, 2003: Message edited by: Vamshi Krishna ]

Krishi.
Abhay Kumar
Greenhorn

Joined: Jun 03, 2003
Posts: 15
Thank You Vamshi and also philip for your answers.
I cannot change the drivers now. So will try with vamshi's suggestions.
Thanks for the answers
 
jQuery in Action, 2nd edition
 
subject: previous & Last
 
Similar Threads
Resultset with million rows
displaytag should show only previous and next
jdbc previous/last/first/next methods
JTree class
Paging JTable