Implementing a NamingStrategy in Hibernate 5 (make autogenerated column names UPPERCASE)

Question

I need to let Hibernate auto generate the database starting from the entities, however I want them all UPPERCASE.

This used to work in the past now I have messed up column names with Upper and Lower case letters.

I enabled the

.setProperty("hibernate.hbm2ddl.auto", "create")

to let Hibernate auto generate the database, and I created an UppercaseNamingStrategy.java extending org.hibernate.cfg.ImprovedNamingStrategy.

According to https://docs.jboss.org/hibernate/orm/5.0/manual/en-US/html_single/#configuration-namingstrategy

Now I should

You can specify a different strategy by calling Configuration.setNamingStrategy() before adding mappings:
SessionFactory sf = new Configuration() .setNamingStrategy(ImprovedNamingStrategy.INSTANCE) .addFile("Item.hbm.xml") .addFile("Bid.hbm.xml") .buildSessionFactory(); 
org.hibernate.cfg.ImprovedNamingStrategy is a built-in strategy that might be a useful starting point for some applications.

Configuration.setNamingStrategy() however seems to be no more in Hibernate 5.0.6.

I would of course like to do it programatically (I don't have .xml configuration files and don't want them).

NOTE:

Using

.setProperty("hibernate.ejb.naming_strategy", "my.project.hibernate.UppercaseNamingStrategy")

doesn't work as well, seems to be ignored altogether...

Try to override this docs.jboss.org/hibernate/orm/5.0/javadocs/org/hibernate/boot/…. — Bilal BBB
– Bilal BBB, Commented Jan 22, 2016 at 19:13
This is another solution stackoverflow.com/questions/32165694/… — Bilal BBB
– Bilal BBB, Commented Jan 22, 2016 at 19:13

v.ladynev · Accepted Answer · 2016-03-16 07:49:16Z

Hibernate 5 uses two new interfaces for name strategies PhysicalNamingStrategy and ImplicitNamingStrategy. You need just implement PhysicalNamingStrategy. It is called by Hibernate after all column names are created for model. So you can just make it uppercase. Hibernate uses by default PhysicalNamingStrategyStandardImpl, that do nothing. You can just extend it

public class UpperCaseNamingStrategy extends PhysicalNamingStrategyStandardImpl { @Override public Identifier toPhysicalColumnName(Identifier name, JdbcEnvironment context) { return context.getIdentifierHelper().toIdentifier( StringUtils.upperCase(name.getText(), Locale.ENGLISH)); } }

You can build session factory with UpperCaseNamingStrategy by this way

 Configuration configuration = new Configuration(); configuration.setPhysicalNamingStrategy(new UpperCaseNamingStrategy()); SessionFactory sessionFactory = configuration.configure().buildSessionFactory();

I am working on a more complex name strategy now. You can refer Hibernate5NamingStrategy if you are interested.

Thankyou, upgrading to Hibernate 5 and extending PhysicalNamingStrategyStandardImpl fixed it.Just a quick rant: why do they have to change the name of methods and classes and leave the documentation unchanged?? Please, keep updating code and leave naming as is.
@sarah.ferguson You are welcome. Looks like, Hibernate always had a poor documentation. It is interesting that there is the ImprovedNamingStrategy class in Hibernate 5, but you can't use it anymore.
Hey @v.ladynev thanks for this information. Just a quick question, what if I wanted to configure my app via persistence.xml?
@Kikin-Sama Sorry, I don't still investigate using the naming strategies with JPA.
@v.ladynev I am not sure if UpperCaseNamingStrategy is doing the same as ImprovedNamingStrategy.INSTANCE I used this solution and it's compiling/building but I can see some errors like org.hibernate.MappingException: An association from the table BON_HISTORY refers to an unmapped class: domain.InstHistory

Collectives™ on Stack Overflow

Implementing a NamingStrategy in Hibernate 5 (make autogenerated column names UPPERCASE)

1 Answer 1

7 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Linked

Related