PreparedStatement and Hibernate session

[Tshegofatsom]

Hi, I want to retrieve a Preparedstatement object from a hibernate Session but now that the connection() method of hibernate Session has been Deprecated, how do I do it.
I want to achieve same result which could be achieved by the the below code:

SessionFactory sessionFactory
sessionFactory = new Configuration().configure().buildSessionFactory();
private Session session =sessionFactory.openSession();
PreparedStatement st = session.connection().prepareStatement("{update DMETERS dm set dm.shape = ? where dm.objectid = ?}");

st.setString(1,"value for shape" );
st.setString(2, objectid);
st.execute();

The problem with the above code is that the "st" object is null when it executes since the connection method has been Deprecated...I may be wrong....any ideas, referrals would be appreciated.

[Tshegofatsom]

Hi
I have found a work around after spending an hour studying the Hibernate documentation. This seems to work just fine:

ConnectionProvider cp = impl.getConnectionProvider();
Connection conn = cp.getConnection();
String sqlString = "update CE_DOMESTIC_METERS dm set dm.shape = ? where objectid = ?";
PreparedStatement st = conn.prepareStatement(sqlString);

[adas]

What is impl. here?

Could you please code the complete code please?

Aslos how do you manage closing the commenction?

Thanks,

[literallyjer]

If you are not tied down to using PreparedStatement, you could use Hibernate's SQLQuery.

int userId = 5;
String sql = "select * from your_table as yt where user_id = :user_id";
SQLQuery query = session.createSQLQuery(sql);
query.setInteger("user_id", userId);
List<?> yourStuff = query.list();

[Tshegofatsom]

Hi, here is the complete code.

import org.hibernate.engine.SessionFactoryImplementor;
import org.hibernate.persister.entity.SingleTableEntityPersister;

 try {
            // Create the SessionFactory from standard (hibernate.cfg.xml) config file.
            sessionFactory = new Configuration().configure().buildSessionFactory();
            session = sessionFactory.openSession();
        } catch (Throwable ex) {
            // Log the exception.
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }

SessionFactoryImplementor impl = (SessionFactoryImplementor)sessionFactory;
ConnectionProvider cp = impl.getConnectionProvider();
Connection conn = cp.getConnection();
String sqlString = "query in here";
PreparedStatement st = conn.prepareStatement(sqlString);
st.setInt(1, domMeters.getObjectid())
int results = st.executeUpdate();
conn.commit();
st.close();