0 Replies Latest reply on Apr 24, 2007 2:12 PM by elikyip

    One SessionFactory for multiple schema

    elikyip

      Long story short:
      In our multi-tenant architecture we cannot afford to create one SessionFactory per schema because of the number of schema's we have. The table structures are identical in ALL the schemas though.

      We are trying to see if we can use ONE SessionFactory for multiple schema without comprimising the second-level cache. We are thinking about creating a cache region for each schema by adding the schema's name to the region's name.

      Has anyone done this before with the cache region name?

      Any idea, clue, hint,....is highly appreciated