I using Seam 2.0 and Hibernate 3.0 with JBoss AS 4.2.2 and deploying an ear with associated datasource (ds.xml) file.
The datasource file is nice because I don't have to go into the ear to change where my database is located. However, there is one deficiency in the fact that in my hibernate.cfg.xml (buried in the ear) I still have to specify the hibernate.dialect.
Does anyone know if there is any way to specify dialect in the ds.xml file outside the ear? I tried specifying as a connection-property but this was not absorbed by Hibernate.