having two hibernate.cfg.xml on the same project

[Natalia Lopez]

Hi!
It's possible to have two differents configuration files in the same project
one with tne name hibernate.cfg.xml and the other with the name
userDirectorydb.cfg.xml
I have two diferent Singleton clases to make instance of diferents configuration files with the following method

private static SessionFactory createPersistenceManager()
{
try {
System.out.println("Initializing Hibernate with UserDirectory DataBase");
sessionFactory = new Configuration().configure().buildSessionFactory();

SessionFactory sf = new Configuration()
.configure("/com/users/db/userDirectorydb.cfg.xml")
.buildSessionFactory();
// .configure("/hibernate.cfg.xml")


System.out.println("Finished Initializing Hibernate with Userdirectory DataBase");
}
catch (HibernateException e) {
e.printStackTrace();
}
return sessionFactory;
}
But the Singleton always use the same hibernate.cfg.xml even when I change the line .configure("/hibernate.cfg.xml")
for the line .configure("/com/users/db/userDirectorydb.cfg.xml")

Any Idea ? What's wrong?
King Regards

Natalia

[miguel lisboa]

look here, at the end of the page;
if instead you have HiA, have a look at page 52

let me know if this helps, because as i'm using HibernateUtil i dont see quite clearly as i could easily create a switch between two diferent configurations
[ March 21, 2005: Message edited by: miguel lisboa ]

[Natalia Lopez]

Thanks for the link
The last part of the page where say
"You can pick a different XML configuration file using
SessionFactory sf = new Configuration()
.configure("/my/package/catdb.cfg.xml")
.buildSessionFactory();"
That not work, even when you change the catdb.cfg.xml still the project search for the hibernate.cfg.xml
Only take the hibernate.cfg.xml I try delete this file and replace for other but not work
Any idea?
Regards

Natalia

[miguel lisboa]

hi Natalia

here's what i've found out:
i'm using eclipse; i created a h.cfg.xml file in the same folder where hibernate.cfg.xml is.

then, went to my HibenateUtil.java and passed "/h.cfg.xml" to configure():

 
// Create the initial SessionFactory from the default configuration files
static {
try {
configuration = new Configuration();
sessionFactory = configuration.configure("/h.cfg.xml")
        .buildSessionFactory();// <-- here
// We could also let Hibernate bind it to JNDI:
// configuration.configure().buildSessionFactory()
} catch (Throwable ex) {
// We have to catch Throwable, otherwise we will miss
// NoClassDefFoundError and other subclasses of Error
log.error("Building SessionFactory failed.", ex);
throw new ExceptionInInitializerError(ex);
}
}
 

so far i've no way of checking this besides within my tests: i have a MySql database for real and a Hsqlbd for tests - hence the need of a switch:

if i want to use MySql (defined in hibernate.cfg.xml) i use HibernateUtil with method configure without any param;

if i want to run faster i use the other cfg, having HibernateUtil as i showed and i also add h.cfg.xml to my test:

  public class TestePersistenciaActoMedico extends TestCase {
 
        //
protected void setUp() throws Exception {
s = HibernateUtil.getSession();
dao = new ActoMedicoDao();
hql = "select count(*) from ActoMedico";
}
 
protected void tearDown() throws Exception {
HibernateUtil.closeSession();
}
 
public void testCria() throws HibernateException {
//creat new db
Configuration cfg = new Configuration();
cfg.configure("/h.cfg.xml"); // <-- here
new SchemaExport(cfg).create(false, true);

So if i have dozens of tests (i do) that need database connection i've to switch manually , or else have two diferent configurations in hibernate.cfg.xml, commenting one or another as i need using one or the other database (which is what i actually do)
[ March 22, 2005: Message edited by: miguel lisboa ]

[Natalia Lopez]

Yes you are right with the solution, I finally found the error!!
Your example work perfectly!
Thanks a lot for your self!

Natalia