I'm trying to use the HQL console and keep getting: "hibernate.dialect must be set when no Connection available" from all queries.
How do I set the hibernate.dialect for the configured datasources? We normally configure this in an external properties file, the hibernate.cfg.xml file does not hold these values as we use different DB vendors in dev, test and prod. So when I'm looking at a particular dataSource how to I map this dialect value and where?
The persistence tool menus only appears to let me configure naming strategies and datasources. The datasource has not dialect - but this would be the wrong level. The hibernate facet also appears not to have any dialect mappings (which would change with datasource anyway) ? what am I missing?
I'm also wondering why I need to set it when the datasource knows what the DB vendor is, and via that the version. Hibernate should be able to make a pretty good guess at the dialect (is this not automatic?) - what is making us define it?