Hi,
I've realized a simple application with tomcat 6 and hibernate on one single server, I mean the DB server and tomcat and the application runs on the same machine. It works happily.
My question is, is it possible to have the DB server on dedicated machine (M1) and two different web applications with tomcat that both needs to use the same DB (on M1) on machines M2 and M3 respectively?
I think the answer would be yes, but in this case should I have the same hibernate.cfg.xml file on both M2 and M3?
Same session factory name, same c3p0 settings for both?

Many thanks in advance