Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem with scrolling the data of resultset

 
khurram mirza
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i fetch record from database in resultset object.i've to go to last record,so when i use resultset.last() it throws SQL exception saying resultset is TYPE_FORWARD_ONLY.i tried to change this attribute using setFetchDirection(ResultSet.Unknown_Direction) but same exception appears.please help me how can i directly get to last record.
khurram mirza
 
Bosun Bello
Ranch Hand
Posts: 1510
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In your createStatement() method, did you specify that you would like to scroll in both directions? Also, does your JDBC driver even support it?
Bosun
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic