hi all,

I'm starting a new application upon an existing database with 100 tables.
I'm using spring IOC to configure hibernate dao's SessionFactories.

I'm facing to the choice of SessionFactory strategy.
I would like to know if it's a good approach to have a single SessionFactory for the all DAO.
Or it's a better approach to bind related dao's to a Sessionfactory.

I've read the Chapter 8(Writting Hibernate Application) of Hibernate in Action but there is no answer to my dilemma.

Can someone tells me if there is performance impact beetween the two possibilities.

thanks in advance.

Meissa

You need one SessionFactory for each database, not for each DAO. The DAOs should get injected with a Session from the SessionFactory, if you wire Spring up properly.