Hi,

We are using both Spring and Hibernate in our development. I wanted to ask if it is logical to access the Hibernate Dialect object in our DAO class that extends org.springframework.orm.hibernate3.support.HibernateDaoSupport

Something like:

The reason this was at all raised was since we need to create a Temporary Table (via org.springframework.jdbc.core.JdbcTemplate execute sql method) and we'll be needing to support both Oracle and MS SQL.

I though we could use methods from the Dialect object in order to create the SQL Statement accordingly. Something like the sqlTemporaryTableCreateString method in class org.hibernate.mapping.Table

Any input, comments, alternative suggestion pls.

Thank you in advance,