Hi guys,

I am new to Hibernate and have done a search on this but have found loads of other (useful) tips and advice but not for what I need.

Basically I was wondering if it's possible to specify another location for the hibernate.cfg.xml file rather than the main class path of the project.

The reason is, when I compile up my code and export it as a jar file, I have the hib xml file in there - with all the settings for the specifc environment I'm working on (i.e., UAT or SIT or DEV or PRD). I really hate having to manually alter the hib xml for a specific region and re-exporting the compiled code. I'd much rather have the hib xml file external in a common /config dir and edit it externally.

But all my attempts at trying to manually specify the hib xml file in a place of my choice fail with the exceptions complaining it cannot find the hib xml file.

At the moment I am using the following which works fine - but I have to keep my hib xml file in the default project path:



Is what I want possible? If so, does someone have a working example of code they could post?

Or if I am reiterating a dead topic could someone please point me in the right thread direction?

Many thanks and apologies if this is an old subject.

Did you try passing the path as an argument to the configure() method

Yes I did - I passed in, for example "c:\\myapp\\config\\hibernate.cfg.xml" but it complained not only that it couldn't find the hibernate.properties file but then threw up majorly when it came to locating the hib xml file.

I tried adding a new File("blah blah") object in there.. I think i tried a load of different approaches.

At the moment it's not a "critical" issue for me - it's just a bit annoying that I need to have 3 different hibernate.cfg.xml files in my project root:



And depending on which env I deploy the code to, have to first rename the appropriate xml file for the right place.

Out of curiousity, what would you do?

IMHO you should use programmatic configuration of the session, not via hibernate.cfg.xml + configure(). You can add every mapping to the session programmaticaly, set every property. In may case, I do not have hibernate.cfg.xml at all and use this approach to connect to 2 different dbs with the same structure and same set of hbm.xml mappings.

Cheers!

Ahhhhh - I can't believe I didn't think of that!

I just realized that I even have test code that set all the req'd properties programatically when I couldn't get the XML loaded! Sheesh!

Thanks Mike!

May be I would put these cfg files for different environments together and depending on the environment programatically choose the appropriate config file.
Chapter 3 of the reference documentation has some details.

By the way did you try relative file paths for the config files.