hibernate create AuxiliaryDatabaseObject with annotation

Question

I've read this in the latest hibernate document https://docs.jboss.org/hibernate/orm/5.5/userguide/html_single/Hibernate_User_Guide.html#schema-generation-database-objects

However, the document only shows how to create the database object in XML mapping. I think XML is more or less old-style, and currently, I created all entity mapping with annotations, don't want to create an XML just for that. Is it possible to do it with annotation?

user_6813506 · Answer

Hibernate Annotations does not need mapping *.hbm.xml file. Hence, you need to add the auxiliary objects programmatically.

The database object in the given link has 3 things:

Create
Drop
Dialect

As per your needs you can add auxiliary objects like in examples here.
Here, is another example of addAuxiliaryDatabaseObject to Configuration.
You can use AbstractAuxiliaryDatabaseObject class which implements AuxiliaryDatabaseObject interface. Example of appliesToDialect using AbstractAuxiliaryDatabaseObject .
The AuxiliaryDatabaseObject interface has methods like sqlCreateStrings, sqlDropStrings etc. Here, is example usage of these methods.
In the end, these objects needs to be added to the org.hibernate.cfg.Configuration & can be done using addAuxiliaryDatabaseObject API.

hibernate create AuxiliaryDatabaseObject with annotation

1 Answers