> > Just had to get rid of my manual PreparedStatement pooling. I just > > didn't know about JDBC statement pooling :) > > Neither I did. Is there something like this? IMHO, it's just that "A > ResultSet object is automatically closed when the Statement object > that generated it is closed, re-executed, or...".
I read about it from here: http://www.ibm.com/developerworks/java/library/j-jdbcnew/ Previously I was caching PreparedStatements for reuse The problem was that sometimes I was reusing a PreparedStatement when its ResultSet was not finished. Turns out that JDBC does similar kind of caching under the hood, so that when I do several times: prepareStatement(sql) then only first time the query needs to be is compiled. Aivar -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
