aspose file tools*
The moose likes JDBC and the fly likes JDBC resultset exusted error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC resultset exusted error" Watch "JDBC resultset exusted error" New topic
Author

JDBC resultset exusted error

trupti nigam
Ranch Hand

Joined: Jun 21, 2001
Posts: 613
Hi ALL,

I am having two different environments for development in my company and we connect to two different databases.
The issue I am seeing is, in one environment my query runs fine returning the expected data. But in second environment, even though the query returns the data (when I ran this in Toad SQL window) , the resultSet is not null but it never enters the while loop (i.e. while (resultSet.next() loop). I tried putting debugging statemnets and i found that I get resultset exusted error. What can be the reason that in one environment I don't see any issue with my query and code and in another even though data exists , there are issues like exuated resultset error.

Thanks,
Trupti
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Originally posted by trupti nigam:
even though the query returns the data (when I ran this in Toad SQL window)


If query is returning data in toad, this means database might not be a cause of problem, Can be have a look on code...?

Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC resultset exusted error