Menu
As per this link there is no support mentioned for derby dialect for 4.2 hibernate.
Is Apache Derby not supported by Hibernate?
585
Dialect is a class that acts as a bridge between Java JDBC types and SQL types, which contains the mapping between java language data type and database datatype. Dialect allows Hibernate to generate SQL optimized for a particular relational database.
The core of the technology, Derby's database engine, is a full-functioned relational embedded database-engine, supporting JDBC and SQL as programming APIs. It uses IBM Db2 SQL syntax.
Some key features include: Derby has a small footprint -- about 3.5 megabytes for the base engine and embedded JDBC driver. Derby is based on the Java, JDBC, and SQL standards. Derby provides an embedded JDBC driver that lets you embed Derby in any Java-based solution.
Apache Derby is a full-featured, open-source relational database management system (RDBMS) implemented in Java and as the name suggests it is developed by Apache Software Foundations. It is based on Java, JDBC and SQL standards. Derby is easy to install, deploy, and use.
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.)
144
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
