Its possibile to access to DB Conncection from org.hibernate.Session ?
I want to pass to another System the connection info that i have in db.cfg.xml .

Thanks,
Luca

session.connection() returns the underlying DB-connection.

Session.connection() but it has been deprecated and will be removed in 4.x.

I have found the method Connection().
This is only way for take the Connection info???

you can get all the stuff from the SessionFactory

chirs its possibile one example?
thanks for reply

cast it to SessionFactoryImpl and use

getSettings().getConnectionProvider().getConnection()

What kind of info do you need? Do you need to use an actual Connection object or only information about the database url, user name, password, etc?
Why not just read it from the 'db.cfg.xml' that you mentioned in your first post?

Because i have the an application that call remote Ejb and the info are in remote jar. For this reason i want to pass the object Connection.

I have treid with:
SessionFactoryImpl session = (SessionFactoryImpl) getSession().getSessionFactory();
return session.getSettings().getConnectionProvider().getConnection();

in jsp i take the connection, execute the query and build the list.
after i can't do nothing because i have this exception:

javax.servlet.ServletException: com.XXXX.utils.ejb.DaoException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a3c0225:95e4:499d2bf1:3c2 status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a3c0225:95e4:499d2bf1:3c2 status: ActionStatus.ABORT_ONLY >))

My idea is similar to:
Session sess=sf.openSession();
Statement st=sess.connection().createStatement(); //connection is deprecated
String sql="select * from foo";
st.executeQuery(sql);

i wait new helps...
thanks to all