Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

After end of result set exception while i execute the SQL query

 
Rajkumar balakrishnan
Ranch Hand
Posts: 445
Android Eclipse IDE Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry for posting the same question in same forum but i can't able to solve it..

When i execute the below code with the MySQL in JSP i got no results, but when i run the same query in MySQL console it works perfect.

At the same time, it also gives me an exception like this one.

java.sql.SQLException: After end of result set


Please help me ranchers....
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Column sequence start with 1 when you access them in resultset.

Thanks,
Shailesh
 
Scott Selikoff
author
Saloon Keeper
Posts: 4010
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yep, ResultSets are one of the few areas of java where 0 is not used as an index. Kind of silly if you ask me, but database designers don't believe in 0 ;)
 
Rajkumar balakrishnan
Ranch Hand
Posts: 445
Android Eclipse IDE Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Scott Selikoff:
Yep, ResultSets are one of the few areas of java where 0 is not used as an index. Kind of silly if you ask me, but database designers don't believe in 0


Yep, thanks Scott.. I change the query and it works now..... Anyway thanks for your time ....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic