Skip to main content

which dialect have we specify in hibernate.cfg.xml?

  • May 12, 2016
  • 1 reply
  • 9 views

otis

We want to use in a java project hibernate. To use hibernate we must specify in hibernate.cfg.xml the option dialect.

Which value may taken dialect atribute to connect java project with hp vertica 7.1?

Could you confirm please if is correct use hibernate in java project to work with hp vertica database 7.1

 

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
<property name="hibernate.bytecode.use_reflection_optimizer">false</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.password">password</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mkyong</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<mapping resource="com/mkyong/common/Stock.hbm.xml"></mapping>
</session-factory>
</hibernate-configuration>

1 reply

eli_revach
Forum|alt.badge.img+2
  • Participating Frequently
  • May 12, 2016
Hi ,
You should use postges dialect.

Thanks