Generated column and table names in hibernate with underscore

Question

how do I force hibernate to generate db schema such that it converts CamelCase into Underscores (using HBM)? Eg. I have:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="cz.csas.pdb.be.model.product.passive">

    <class name="foo.BarBaz">

        <id name="barBazId">
            <generator class="sequence"/>
        </id>

        <property name="extractContactType"/>
        <!-- ... -->
    </class>
</hibernate-mapping>

And I want hibernate to create table like this (oracle):

CREATE TABLE "BAR_BAZ"
  (
    "BAR_BAZ_ID"               NUMBER(19,0) NOT NULL ENABLE,
    "EXTRACT_CONTACT_TYPE"     VARCHAR2(512 CHAR),
    -- PK etc...
  )

I know I can use table/column name in the hbm.xml file, but I want to set it globally (both to save time and prevent errors).

axtavt · Accepted Answer · 2011-03-09 09:35:49Z

7

ImprovedNamingStrategy should do exactly what you want. See 3.6. Implementing a NamingStrategy.

answered Mar 9, 2011 at 9:35

axtavt

243k42 gold badges518 silver badges486 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ondrej Skalicka Over a year ago

It looks like it should work ok, but I get an exception Caused by: org.hibernate.MappingException: Same logical column name referenced by different physical ones: account_charge.PASSIVEACCOUNT => 'passive_account' and 'passiveaccount'; for a simple many-to-one (accountCharge HBM has "<many-to-one name="passiveAccount"/>").

Andrea Ligios · Accepted Answer · 2015-09-18 13:34:53Z

6

In JPA 2 (Hibernate 4), it is even more easier, just add:

<property name="hibernate.ejb.naming_strategy"
         value="org.hibernate.cfg.ImprovedNamingStrategy" />

to your persistence.xml.

edited Sep 18, 2015 at 13:34

answered Oct 18, 2013 at 16:43

Andrea Ligios

50.4k29 gold badges127 silver badges256 bronze badges

2 Comments

user152468 Over a year ago

Sounds good, but I get a SAX-Parse-Exception which says that the attribute 'value' must be defined. Probably I have some old DTD or Schema for hibernate.cfg.xml. Using hibernate 4.3.5-Final.

edur Over a year ago

It's working flawlessly, allowed me to use camelCase on entities and snake_case on the database (postgresql), I'm using 4.3.8-Final

Collectives™ on Stack Overflow

Generated column and table names in hibernate with underscore

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related