I am wondering if there is an elegant way to get Hibernate Dialect property (basically I want to find what type of DB, mysql, ms sql, postgresql, etc. it is using ). Based on the dialect info, I'll write some native SQL to take advantage of DB-specific features using createSQLQuery.
Currently I did not see a good way to do it. Spring did a good job to seal up SessionFactory. I also do not what to use appContext.getBean() for obvious reason.