How to configure hibernate.dialect in my context.xml

Question

this is the relevant part from my context.xml file:

<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="packagesToScan" value="com.netomedia.model"/>  
<property name="jpaProperties">
    <props>
        <prop key="hibernate.hbm2ddl.auto">update</prop>
        <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
    </props>
</property>
<!-- <property name="persistenceUnitName" value="punit"/> -->
<property name="dataSource" ref="dataSource"/>
<property name="jpaDialect">
    <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
</property>
<property name="jpaVendorAdapter">
    <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
        <property name="database" value="MYSQL"/>
        <!-- <property name="databasePlatform" value="${hibernate.dialect}"/> -->
        <property name="showSql" value="false"/>               
        <property name="generateDdl" value="false"/>
        <!-- <property name="databasePlatform" value="org.hibernate.dialect.MySQL5Dialect"/> -->
        <!--  <property name="hibernate.connection.autocommit" value="false"/> -->
    </bean>
</property>
<property name="jpaPropertyMap">
    <map>
        <entry key="hibernate.connection.autocommit" value="false" />
    </map>
</property>

i wanted to know if this is the correct way to configure hibernate.dialect and what is the difference between them:

<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>

or

<property name="databasePlatform" value="org.hibernate.dialect.MySQL5Dialect"/>

thank you!!

user3020494 · Accepted Answer · 2013-11-24 13:56:06Z

2

I am not sure if other is valid syntax, but this works:

<property name="databasePlatform" value="org.hibernate.dialect.MySQL5Dialect"/>

Update: I believe either one of them should work, prop key=hibernate.dilect is hibernate property and property name=databasePlatform is spring property.

you can wish to add one or more hibernate specific properties under < props>...

edited Nov 24, 2013 at 13:56

answered Nov 24, 2013 at 12:45

user3020494

7326 silver badges9 bronze badges

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

1 Comment

lior Over a year ago

thank you! i should delete the <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop> ?

Collectives™ on Stack Overflow

How to configure hibernate.dialect in my context.xml

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related