Hi.
you have to options how to solve this
1) go to modules\org\hibernate\main\ and add your jar with custom dialect there and add it into module.xml in that same folder
2) create new module https://docs.jboss.org/author/display/MODULES/Defining+a+module and then add dependancy to it from org.hibernate module
--
tomaz