This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
A question, is it OK to pass my SQL into a DB_Bean that gets the connection and passes back the resultSet, what about closing the connection, will this happen automatically when the method returns or is this just a bad practice
if you are not using the DBCP, then you should get the connection when required and close it after use. Moreover you should take care of thread-safety. [ December 13, 2004: Message edited by: Adeel Ansari ]