I got this error before but somehow it stopped. Now I'm getting it on a page. Here it is:
I open a connection to an oracle db. I get a resultset from a bean and it works fine. Now I need 2 more querys (resultset). What happens is this. The first resultset I open I just use after opening the other 2. The information in this 2 gets shown perfectly. But then the page doesn't complete and I get a "flow has been closed" java.sql.exception. I'm translating the exception from Portuguese, so I don't know if this is exactly it!! I've checked the html generated and at some point it just stops the html and starts the one from my error page!! (Note that it doesn't stop at any logic point, just at the middle of a form tag). If I get this two resultsets out all works fine... I can't figure out why this is happening. I've tried closing the resultsets in the correct places, with the same result. Is there some kind of restrition when getting resultsets? The way I'm doing is open a connection and create from this a different statement for each query I need!! The bean is the same for the 3 querys, and each function I call for the querys is returning a resultset... Any help?? Thanks in advance... =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
