>Actually, to answer my own question, I think that if I call the close() >method for the passed JDBC recordset after I've done with using it in other >methods then this should do the trick. Am I right?
>Actually, to answer my own question, I think that if I call the close() >method for the passed JDBC recordset after I've done with using it in other >methods then this should do the trick. Am I right? I would consider converting the resultset into a CF query object, and returning a query from the function instead. Also check your function local variables. I do not think all of them are properly VAR scoped. BTW, are you connecting using a datasource or making a direct connection to a database? IIRC opening and closing database connections manually can often be more expensive than using a fixed datasource (with connection pooling enabled). When connection pooling is enabled, queries just grab an already open connection from the pool, rather than opening and closing them each time a statement is executed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
