Hello,

I'm using stateless session EJB which uses DAO class for data manipulating.
The question is should I get DB Connection object from EJB and give it for
DAO
class to be used or is it better idea that DAO class would open Connection
object itself and
use it for data manipulating in database?

Or does it matter which one is getting the Connection object?

I read somewhere that EJB's passivate and activate method should close nad
repeopen
Connection when those methods are called.

So, which one is better place to open Connection from Datasource EJB or DAO?

Cheers!