• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exhausted ResultSet!

 
Panday Manako
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi!
I'm trying to test connection pooling in my program. I'm encountering this error- java.sql.SQLException: Exhausted Resultset. Can anyone please explain this error.
thanks!
panday
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are trying to operate on a resultset which is already closed.
 
Panday Manako
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks! I'm now encountering protocol violation error. Can you please explain that too.
thanks!
[This message has been edited by Panday Manako (edited July 30, 2001).]
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hope your problem is solved.
Create a declaration block in your program and
explicitely call rset.close() for all unused ResultSet's.
Oracle reuses them, and block a Cursor on the DB side for each.
 
Panday Manako
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Dip! I really appreciate your replies. thanks! I'm sorry but I didn't understand your last post. I better explain further what I'm doing. I'm using servlets and I'm trying to incorporate a connection pool. I test my connection pool by using 2 computers to access data simultaneously. Everytime I do this I encounter Exhausted Resultset and protocol violation. Can you please provide a sample code. What I understand about declaration block is that it's a code inside {}.
thanks again
panday
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic