Hibernate version: 3.2

Name and version of the database you are using: DB2 8

Pardon my newbieness! I'm working with 3.2 Core (no annotations), using mappings, DOA's, and a session factory automatically generated by MyEclipse 6.5.

I'm trying to build a internal web app for maintaining some small sets of data. The kink is that this admin tool can be pointed at one of multiple datasources (I'd like to use a pull-down list on the login page)... and we'd like to connect to the datasource with the credentials supplied on the login page.

What I have tried to do is modify the session factory class generated by MyEclipse... to include static member variables for the JDBC connection url, the username, and the password. Then, I modified the method which instantiates the session factory, to look like this:

configuration.configure(configFile); // "/hibernate.cfg.xml"
configuration.setProperty("connection.url", jdbcURL);
configuration.setProperty("connection.username", jdbcUsername);
configuration.setProperty("connection.password", jdbcPassword);
sessionFactory = configuration.buildSessionFactory();

Unfortunately, from playing around in the debugger, it looks like this first line (which was there originally) causes Hibernate to go out and hit the database to setup the various mappings. Since the URL, username, and password haven't been set yet, it bombs at that point. So I'm in a bit of a Catch-22, in that I cannot add my custom properties to the Configuration... because they need to be there when instantiating the Configuration.

Is there something obvious I'm missing, or a better approach I should be using? I imagine that it wouldn't be that uncommon to dynamically set JDBC url's or credentials at runtime. Thanks in advance!

We are using a similar approach in our project. We are calling the methods in another order, and doesn't specify a file in the call to configure().

Ahh... that did the trick. Thanks!

i'm trying to do the same thing, but can't get it to work as you've described.

i've commented out the connection values in my hibernate.cfg.xml and then run with the following:


when this is run i get the following warning, meaning the setProperty calls have had no effect

then when the connection is tested, it fails.


any ideas?

sorry, solved it - we had the same error in all of our examples = the properties need to be prefixed with 'hibernate.'

so



i'm sure i've run into this before!