Can't set dialect

g.tomassoni · **Posted:** Thu Jun 01, 2006 10:10 am

Hibernate version: 3.1.3

Mapping documents: annotated

Name and version of the database you are using: PostgreSQL 8.1

I'm using EJB3 with the following META-INF/persistence.xml:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<persistence>
   <persistence-unit name="caspedDatabase" transaction-type="JTA">
      <provider>org.hibernate.ejb.HibernatePersistence</provider>
      <jta-data-source>java:CaspedDS</jta-data-source>
      <jar-file/>
      <properties>
         <property name="jboss.entity.manager.factory.jndi.name"
          value="java:caspedDatabase"
         />

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

         <property name="hibernate.connection.isolation" value="8" />

         <property name="hibernate.transaction.manager_lookup_class"
          value="org.hibernate.transaction.JBossTransactionManagerLookup"
         />

         <property name="hibernate.default_schema" value="public"/>

         <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
         <property name="hibernate.show_sql" value="false"/>
      </properties>
   </persistence-unit>
</persistence>

I'm defining the dialect as org.hibernate.dialect.PostgreSQLDialect, but nonetheless I get the following message during configuration:

Quote:

INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect

How does it came?

Regards,

giampaolo

nikhilji · **Joined:** Fri Feb 24, 2006 2:00 pm **Posts:** 4

check the locations in your classpath to make sure you don't have any other configuration files out there overridding the values in the one you're working on. my guess would be that the dialect is getting set to Postgres, but perhaps another configuration file is being read later that's setting it to HSQL.

hope that helps,
nikhil

emmanuel · **Posted:** Thu Jun 01, 2006 1:21 pm

Works fine for me.
What is your environment / HEM version?

g.tomassoni · **Posted:** Thu Jun 01, 2006 1:50 pm

emmanuel wrote:

What is your environment / HEM version?

JBoss 4.0.4 GA + HEM 3.2.0.CR1.

The EJB3 is the one shipped with that JBoss.

g.tomassoni · **Posted:** Fri Jun 02, 2006 8:50 am

I had to switch to mixed annotation + .hbm.xml mappings and now the correct dialect seems to be detected.

Is it possible the problem is somehow restricted to annotation-only setups?

emmanuel · **Posted:** Sun Jul 09, 2006 6:10 am

No the dialect is unrelated to annotations / hbm