SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-15-2008, 11:53 PM
| ||||
| ||||
 error note Lacking a better place to send this, it turns out that the error message org.postgresql.util.PSQLException: This ResultSet is closed. in JSP's may mean that you uses a Statement, return a resultset from that same statement, then (without finishing with the resultset) you re-use the statement (which re-sets the resultset) then try to re-use the resultset ( i.e. be careful with using the same statement over and over). Just a note for those who run into this. Thanks. -Roger -- Love is the only force that can erase the differences between people, that can heal relationships shattered by bitterness.      |
|
04-15-2008, 11:54 PM
| ||||
| ||||
| Re: error note Roger Pack <roger.byucougar 'at' gmail.com> writes: > Lacking a better place to send this, it turns out that the error message > org.postgresql.util.PSQLException: This ResultSet is closed. > in JSP's may mean that you uses a Statement, return a resultset from that > same statement, then (without finishing with the resultset) you re-use the > statement (which re-sets the resultset) then try to re-use the resultset ( > i.e. be careful with using the same statement over and over). > Just a note for those who run into this. Per Sun documentation. "A ResultSet object is automatically closed when the Statement object that generated it is closed, re-executed, or used to retrieve the next result from a sequence of multiple results." http://java.sun.com/j2se/1.4.2/docs/...ResultSet.html -- Guillaume Cottenceau ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
Linear Mode
