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
Joined: Nov 22, 2008
Posts: 18944
posted
0
You are trying to operate on a resultset which is already closed.
Panday Manako
Ranch Hand
Joined: Mar 29, 2001
Posts: 80
posted
0
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
Joined: Nov 22, 2008
Posts: 18944
posted
0
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
Joined: Mar 29, 2001
Posts: 80
posted
0
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
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
