The solution I've come up is still programmatical but practical enough for my purposes.
I use a HibernateUtil class, as I suspect most people do, to get a Session. In the static initializer I've put this code:
Code:
private static final String JNDI_HIBERNATEDIALECT = "props/HibernateDialect";
static {
String dialect = null;
try {
Context ctx = (Context)new InitialContext().lookup("java:/comp/env");
dialect = (String)ctx.lookup(JNDI_HIBERNATEDIALECT);
} catch (NamingException e) {
log.warn(JNDI_HIBERNATEDIALECT + " not found in JNDI, not configuring hibernate.dialect", e);
}
try {
// Create the SessionFactory
Configuration cfg = new Configuration().configure();
if(dialect != null) {
cfg.setProperty("hibernate.dialect", dialect);
}
sessionFactory = cfg.buildSessionFactory();
} catch (Throwable ex) {
log.error("Initial SessionFactory creation failed.", ex);
throw new ExceptionInInitializerError(ex);
}
}
Now you can configure the "props/HibernateDialect" in your J2EE container. In tomcat you can do this by putting:
Code:
<Environment name="props/HibernateDialect" type="java.lang.String" value="net.sf.hibernate.dialect.MySQLDialect" />
inside the Context configuration in server.xml (or context.xml).
Tomcat does not require you to add a resource-ref in your web.xml, but most J2EE containers do. I think it is a good practice to do so. web.xml:
Code:
<resource-env-ref>
<description>Hibernate Dialect</description>
<resource-env-ref-name>
props/HibernateDialect
</resource-env-ref-name>
<resource-env-ref-type>
java.lang.String
</resource-env-ref-type>
</resource-env-ref>
Now, how do I give myself some credits? :D
Login
FAQ
Search