It seems that MySQL and PostgreSQL act differently if null values are provided for default (defined in the db) columns on insert: the former uses the default whereas the latter inserts the null. This is a problem for reveng-generated classes because a .save() passes all columns to an insert includi…

You could also use @DynamicInsert to address DEFAULT column issues.

Thanks, that looks good, but I can’t find a global setting for it and I can’t see a way to ask reveng to add the annotation to its generated classes?

There’s no such setting. However, you can either add it manually to all entities, or automate the task using the IDE Replace feature or sed.

Thanks. We use reveng as part of our CI build so it can’t be a manual tweak. It doesn’t look to be too hard to add it to the reveng code if this is a thing others might want too? It should not be default though, so where best to put a configuration switch? A meta attribute in hibernate.reveng.xml? …

[image] NeilS: It doesn’t look to be too hard to add it to the reveng code if this is a thing others might want too? You can send a Pull Request with this change in place so we can review it.

OK. Where’s the best place to discuss the right way to do things beforehand? For example, the configuration question. Also, BasicColumnProcessor.java has reading the default value commented out with TODO: only read if have a way to avoid issues with clobs/lobs and similar

Reveng: default columns and insertable=false

Hibernate Tools

vlad May 15, 2018, 12:48pm 8

@Koen_Aers is the right person to discuss this further.

Topic		Replies	Views
Behaviour when column in not mapped and value is not defined in session.save Hibernate ORM	3	2763	October 28, 2021
Insert into a view in Oracle Hibernate ORM	3	127	March 28, 2025
I would like to modify reveng to add some methods Hibernate Tools	2	1353	June 4, 2019
How to set a custom revengStrategy in hibernate-tools-maven? Hibernate Tools	3	953	September 21, 2023
OrderColumn w/o nullable or default? Hibernate ORM	8	5133	February 25, 2019

Reveng: default columns and insertable=false

Related topics