Hi.

What's the proper way to retrieve the Dialect at runtime. The main idea is that I want to get the next value for a database sequence by creating a query independent of the Dialect used. For this I need the Dialect so that I can call getSequenceNextValString() on it.

I first tried to get the dialect from the Environment's properties and by calling Dialect.getDialect() method but in both cases I got a null reference.

Is it ok to cast the sessionFactory object to the SessionFactoryImplementor?

Thanks a lot.