Win a copy of Get Programming with Java (MEAP only) this week in the Beginning Java forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Liutauras Vilda
Sheriffs:
  • Tim Cooke
  • Devaka Cooray
  • Paul Clapham
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Ron McLeod
  • Ganesh Patekar
  • salvin francis
Bartenders:
  • Tim Holloway
  • Carey Brown
  • Stephan van Hulst

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

 
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....
 
Ranch Hand
Posts: 1085
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
 
author
Posts: 4098
21
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 ....
 
I'm gonna teach you a lesson! Start by looking at this tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database
https://coderanch.com/t/704633/RavenDB-Open-Source-NoSQL-Database
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!