Hi all,

I need a bit of advise of best practice on using the SQL pod. When should we use the SqlConn.close and Statement.close? Does calling Statement.close will close the SqlConn?

Thanks.

Those calls map directly to the JDBC Connection.close and Statement.close. I would recommend always closing inside finally block since it potentially holds open state/connections in the underlying driver to the db.

Thanks Brian. So I better read up on JDBC.