How does the Transaction should be implemented in a project that don�t use EJB? Is the DAO's responsability to manage the transaction? Is the DAO methods caller (a "session bean like") responsability?
I would say in this case, you could still have a manager class which deals with some logic surrounding the result set. This manager could manage the connections to the database. i.e manager->initialise DAO->work with result set... and so on..