Hi everyone,
I'm trying to get a session without putting in hibernate.cfg.xml the connection parameters, because i don't have them.
The only thing i have accesible is a Connection object, that i get in any moment, but i can't extract the params in order to use Configuration.setProperty().

The problem is that a session (i think) can only be retrieved using a SessionFactory, and a SessionFactory can only be created using a Configuration. At the moment i request to the Configuration to buildSessionFactory(), it goes to the configuration xml and throws an error.

What i want, is to use "session = sessionFactory.openSession(MyConnectionObject);

Anyone knows by a chance how could i get it working??? I't would be very usefull.

Thanx in advance, and sorry about my english.

Regards, Andres

You can implement org.hibernate.connection.ConnectionProvider and set the value of hibernate.connection.provider_class in your hibernate.cfg.xml file, or set it in code on the Configuration object if you need to do some initialization. Google "hibernate ConnectionProvider" and you'll find some examples.

Thanx! I'll try tomorrow at work! Now it's 24:30 here,but i promise feedback and some code!

Regards!!!

I'm trying now, and the option i need is setting it in the code.
I made a CustomConnectionProvider, and in case i put the class in the hibernate.cf.xml in hibernate.connection.provider_class property, it throws that can't instantiate the class. And in the other side, if I remove all the properties in the xml, it crashes because it is asking for them....

I don't know how i could tell hibernate to ignore the xml....

my main() is only a system.out.println!!! i don't know why is trying to initialize all the BD stuff.

I don't know what you mean by BD stuff, but hibernate expects your connection provider to have a no-args constructor. Did you look at this example?
http://www.javalobby.org/java/forums/t18406.html

Sorry, i mean DB stuff, not BD (in spanish Base de Datos, in english DataBase).

In that example, he pass several DB arguments:



And my big problem is that i don't know any of them before the execution. The connection is given from other source, and i don't have either url or user/password. The only thing i have is a Connection object.

So, my main procedure, has in the first line:



and, in order to doing tests, i have commented the rest of the actions, but hibernate is still trying to connect to the database:



What i really need, is that the hibernate initialization actions, don't get executed until i tell him... it's that posible?

Thanx again, and sorry about all of this...

Regards

You need to read the whole article. Just a few lines after what you quoted he writes

Maybe neither of those [jndi or connection pool] are options [that] will work for you.

And he then goes on to describe how to provide connections to hibernate in a legacy environment.

Sorry, buy i finally realised what was happening. I had the code correct, but at the execution time eclipse was not updating the binaries, so i was executing always the old version....

Thanx anyway, it's working!!!