Hi everybody.

In my code. I need to connect multi databases at same time. I readed Hibernate manual. for only one db. I need to create a Hibernate.cfg.xml and a class to get a SessionFactory type object.

but for multi database. I think the most simple way is like this.

public class HibernateSessionUtil {
private static SessionFactory sessionFactory1;
private static SessionFactory sessionFactory2;
private static SessionFactory sessionFactory3;


public static Session currentSession(String fileName)
throws HibernateException {
if (filename == "filename1" ) {create sessionFactory1};
else if (filename == "filename2" ) {create sessionFactory2};
else if (filename == "filename3" ) {create sessionFactory3};
else return null;
}
}

but I don't think it is a good way. because it is ugly.
who can give me some ideas make those code flexible and clean.

Thanks

Joey

Unfortunately, according to the Advanced User's FAQ "You must configure multiple SessionFactory instances" to use multiple DBs.

The way you have described is one way of implementing it (however, I'm not sure why you're 'creating' a sessionFactory and returning it when you're getting a Session). I had the same problem myself once and I ended up making a registry (a map with key = classname and value = sessionFactory (I had each SessionFactory in it's own Class implementing an interface so I can call SessionFactory.getSession() without having to reference a specific SessionFactory)). With this way, you can see if the Object is-a classname and if it is, use the SessionFactory mapped to it.

Hope this helps,
-B

Hi BLudkiewicz:

Thanks for your reply.

Joey