I want to create session factory which is shared by all system database users. As session factory is heavy component it is not right to create it every time user login to application.
My scenario is that, I have an application which is login by system database users i.e. Mysql database users not by application users. So I need a session factory which can be created only once and used by all system database users.
Is it possible to do that?
Yes, it is possible. you can create a class which have static object of SessionFactory. suppose this class have an static block so that it will execute only once at the time of when the class is loaded into JVM. In that static block you have to initialize SessionFactory and when you want to use sessionFactory you can call getter of sessionFactory object.
public final class SessionFactoryHelper {
private static SessionFactory sysDBUserSessionFactory;
static {
try {
// initialize the sysDBUserSessionFactory object.
} catch (Exception e) {
//exception handling
}
}
public static SessionFactory getsysDBUserSessionFactory() {
return sysDBUserSessionFactory;
}
}
Whenever you want sessionFactory for system database users use :
SessionFactory sessionFactory = SessionFactoryHelper.getsysDBUserSessionFactory();
SessionFactoryHelper is loaded into JVM. so you need not to worry when session factory need to be build it's getting build at application load time.<string,SessionFactory> where key part is username and value is it's respective sessionFactory object. But for this approach you have to sure you will not have large number of DB users otherwise application become so heavy to maintain objects only :)