This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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
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 ]
Joined: Jun 03, 2003
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