aspose file tools*
The moose likes JDBC and the fly likes After end of result set exception while i execute the SQL query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "After end of result set exception while i execute the SQL query" Watch "After end of result set exception while i execute the SQL query" New topic
Author

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

Rajkumar balakrishnan
Ranch Hand

Joined: May 29, 2008
Posts: 445

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....


Never try to be a hard-worker. Be a smart-worker.
My Blog
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081



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

Thanks,
Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716
    
    5

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 ;)


My Blog: Down Home Country Coding with Scott Selikoff
Rajkumar balakrishnan
Ranch Hand

Joined: May 29, 2008
Posts: 445

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 agree. Here's the link: http://aspose.com/file-tools
 
subject: After end of result set exception while i execute the SQL query