Hello everybody,
i want to manage many databases in my application. do i have to create many hibernate.cfg.xml or can i load all database informations in one xml file.

regards

Alif

you'll need more than sessionFactory, built from the Configuration . The Configuration can be built from hibernate.cfg.xml, or programmatically.

You many want to create two Configurations from the same file, and then programmatically change the connection.datasource property of the second one.

Do you have multiple copies of the same database, or many different databases?

If they're actually physically different, you'll want multiple configurations.

Another consideration is how you'll coordinate transactions accross them - if you're modifying different databases and you need transactional consistency accross them, you'll need to use a JTA datasource, or if the interactions are relatively simple devise heuristics to handle the consistency issues that may crop up.