Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC resultset exusted error

 
trupti nigam
Ranch Hand
Posts: 625
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic