Vertica Dialect for Hibernate Updated!

Posted January 31, 2019 by Kathy Taylor, Information Technology Developer, Vertica

teammates looking at analytical data
The Vertica dialect for Hibernate, updated for Vertica 9.2 and Hibernate 5.4.1, is now available for download. The dialect enables Hibernate to map Java classes to database tables in Vertica.

Hibernate is an open-source, Object/Relational Mapping (ORM) framework for Java environments. With Hibernate, developers can create an object library that encapsulates object/relational mapping information for use within Java applications.

To use the updated dialect file, you must have:

• JDK 8.0 or later

• Hibernate 5 or later

• Vertica client 9.0 or later

• Vertica server 9.0 or later

To download the updated dialect file (VerticaDialect.jar), follow the instructions in Vertica Integration with Hibernate: Connection Guide. In addition to the download instructions, the guide provides the steps for creating a console-based Hibernate application that connects to Vertica using the Vertica dialect. You can use this application to execute all CRUD (Create, Read, Update, and Delete) operations, including inserts and simple SQL statements.