Hell with postgres + hibernate

[Jose Ayerdis]

Hi, i've been mapping using annotation as jpa standard and using hibernate as my orm and session manager. Nevertheless i've been experience a huge problem i got this error when i'm trying to insert or update my class.

Hibernate: insert into tbl_usuario (activo, conectado, contrasenna, no_ip_sesion, nombre, id_sucursal, ultima_sesion, direccion, email, p_apellido, p_nombre, s_apellido, s_nombre, telefono, tipo, id_usuario) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, ?)
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
        at org.paja.group.logica.dao.DAO.commit(DAO.java:46)
        at org.paja.group.logica.dao.DAO.insertar(DAO.java:98)
        at org.paja.group.logica.alfa.usuario.dao.UsuarioDao.main(UsuarioDao.java:61)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into tbl_usuario (activo, conectado, contrasenna, no_ip_sesion, nombre, id_sucursal, ultima_sesion, direccion, email, p_apellido, p_nombre, s_apellido, s_nombre, telefono, tipo, id_usuario) values (0, 0, gayerdis, NULL, gprueba, NULL, NULL, NULL, [e-mail], Ayerdis, Guillermo, NULL, NULL, 6727076, 0, 150) was aborted.  Call getNextException to see the cause.
        at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1328)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:351)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2674)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
        ... 10 more
 

My mappings goes like this.

Class: Usuario
Class: Gerente extends Usuario
but i can't update or insert havent test delete.

I checked my schema and my Hibernate.cfg goes like this:

<?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 name="sesion">
    <property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
    <property name="hibernate.connection.url">jdbc :-P	 ostgresql://192.168.1.20:5432/alfa</property>
    <property name="hibernate.connection.username">alfa</property>
    <property name="hibernate.connection.password">alfa</property>
    <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <property name="hibernate.show_sql">true</property>
    <property name="hibernate.jdbc.use_get_generated_keys">true</property>
    <property name="hibernate.default_schema">public</property>
    <property name="hibernate.transaction.flush_before_completion">true</property>
    <property name="hibernate.jdbc.batch_versioned_data">true</property>
    <mapping class="org.paja.group.logica.alfa.config.Empresa"/>
    <mapping class="org.paja.group.logica.alfa.config.Sucursal"/>
    <mapping class="org.paja.group.logica.alfa.util.Telefono"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.util.Prioridad"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.util.Categoria"/>
    <mapping class="org.paja.group.logica.alfa.usuario.Gerente"/>
    <mapping class="org.paja.group.logica.alfa.usuario.Usuario"/>
    <mapping class="org.paja.group.logica.alfa.usuario.nota.MensajeInstantaneo"/>
    <mapping class="org.paja.group.logica.alfa.usuario.nota.Nota"/>
    <mapping class="org.paja.group.logica.alfa.usuario.GrupoTrabajo"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.Tematica"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.UsuarioTematica"/>
    <mapping class="org.paja.group.logica.alfa.util.Historial"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.HojaEvaluativa"/>
    <mapping class="org.paja.group.logica.alfa.usuario.Logistica"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.Caso"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.Discusion"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.Comunicado"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.MensajeTematica"/>
    <mapping class="org.paja.group.logica.alfa.comunicacion.casos.DatoAdjunto"/>
  </session-factory>
</hibernate-configuration>
 

[Mark Spritzler]

Please post your annotated class that is not inserting, also post your code to do the insert.

Mark