Hi All,

I am using hibernate mapping in a project in Java and I have an error that I cannot figured out. I have several tables that includes column names all in lower case (e.g. db_id). To use them in Java, in my .hbm.xml file I am mapping them with the following line:



I haven't got any error until now. Even if I use upper case above (column="DB_ID"), mapping was successfull. However, I now get a missing column error when I try to running the project. The error line is like:



When I change the column name from db_id to DB_ID manually in pgAdmin or Navicat(I am using PostgreSQL), this error disappears and the next column name gives error. I have tens of tables and hundreds of column names. I have also many .hbm.xml files for mapping. (This is a part of a big project.) So I do not want to change all column names manually or change the all column attributes in .hbm.xml files.

What can I do to make it case insensitive?

For Hibernate 5.x, you can use a custom physical naming strategy which you provide via the hibernate.physical_naming_strategy configuration property.

What you can do is to come up with your own naming strategy that changes the case of columns:

The problem is solved.

I guess the issue stems from the fact that the language of the operating system or java is not set in English. So I created a setenv.bat file in the apache-tomcat/bin directory and fill it with the following statement



It is solved with this way. I hope this will be helpful for the people who are experiencing the same issue.

I'm glad I could help.