I am new to Hibernate, doing an evaluation for my company. I am using the latest release (3.1) and I generated my mapping files and POJOs using the beta 2 of the tools. My question deals with my company's systems are setup and using Hibernate within this setup. We are an ASP and we have several hundred customers and growing. Each customer has their own database and each database has 300 tables within it that would need to be mapped for use under Hibernate. I quickly run into memory issues when I try to load a SessionFactory/Configuration per customer. I've read in the docs and forums that it is possible to use one SessionFactory/Configuration and pass a JDBC connection to the get a session. Is this the recommded way to handle large numbers of databases with several hundred tables each? Is there a strategy I'm missing that I should be following? Any help would be appreciated.

I'd also like to see some comments on this.