As per this link there is no support mentioned for derby dialect for 4.2 hibernate.
Is Apache Derby not supported by Hibernate?
There are more dialects if you look at the javadoc. As of the time of the latest update to this answer, they are:
DerbyDialect
(deprecated, see HHH-6073), DerbyTenFiveDialect
, DerbyTenSixDialect
, and DerbyTenSevenDialect
.For versions of Derby after 10.7, the DerbyTenSevenDialect
dialect would be the most appropriate, assuming no new Derby dialect classes are added. (But if that happens, it is advisable to pick the "latest" dialect class that is less or equal to the Derby version you are using.)