I have an application that gets data from multiple databases. All databases have the same schema.
I use multiple SessionFactories to query the data.
There are over 50 database partitions, so I had to use 50 configuration files to get it working.

I would rather have one file, that has multiple session factories. Is this possible?

I have read the documentation and many of the discussions in this forum, but I have yet to find an answer..

Is it possible to configure multiple session factories in one configuration file?

I would really appreciate if anyone can answer that.

If all databases have the same schema, then the only thing changing is your datasource? If so, why not load the configuration file into a DOM tree, and manipulate that for creating the session factories as required? For that matter, I guess it'd be possible to parse a custom xml document containing a set of configurations, taking each configuration and creating a session factory from it.

Alternatively you could build the Hibernate Configuration object programmatically using the Configuration API. This is fairly trivial in most instances.