Hibernate version:
Core: 3.2.4.sp1
Entity Manager: 3.3.1.GA
Annotations: 3.3.0.GA

Name and version of the database you are using:
MySQL 5

I need to be able to add a custom SQLFunction but the only way to do this that I'm aware of is by calling Configuration.addSqlFunction(). Ejb3Configuration instantiates the hibernate Configuration and builds a SessionFactory from it but, as far as I can see, provides no hooks to add SQLFunctions. Unfortunately, creating a patched build of hibernate and altering the MySQLDialect is not an option for me.

Thanks

Couldn't you just subclass MySQL5Dialect and change the dialect property in the persistence settings to be your subclass?

Yup, that worked a treat, thanks.

Glad it worked for you. Feel free to rate the response as helpful :-).