-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 
  Previous topic | Next topic 
Author Message
Syargey
 Post subject: insert problem: hibernate passes null to identity column
PostPosted: Sat Jan 30, 2010 6:36 pm 
Newbie

Joined: Sat Jan 30, 2010 6:17 pm
Posts: 5
Hi all,

I write a small application and encountered a problem with inserting data into table.

Here is a table creation script (HSQLDB);
Code:
CREATE MEMORY TABLE user
(
  user_id  INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 100),
  name     VARCHAR(40),
  password VARCHAR(40),
  CONSTRAINT user_pk PRIMARY KEY ( user_id ),
  CONSTRAINT user_unique1 UNIQUE ( name )
);


Hibernate mapping is defined as follows:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="model.User"
            table="user"
            discriminator-value="u">
           
        <id name="userID"
            type="integer"
            column="user_id"
            unsaved-value="null" >
           
            <generator class="identity"/>
        </id>
               
        <property
            name="name"
            column="name"
            type="java.lang.String" />
           
        <property
            name="password"
            column="password"
            type="java.lang.String" />
       
    </class>
</hibernate-mapping>


The insert code produces exception:
Code:
Hibernate: insert into user (name, password, user_id) values (?, ?, null)
Exception in thread "main" org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [model.User]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [model.User]
   at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:615)
   at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
   at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
   at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
   at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:690)
   at dao.impl.hibernate.UserDAOImpl.save(UserDAOImpl.java:24)
   at service.impl.UserServiceImpl.save(UserServiceImpl.java:30)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy0.save(Unknown Source)
   at LoadUsers.main(LoadUsers.java:51)
Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [model.User]
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1986)
   at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)
   at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
   at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
   at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
   at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
   at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
   at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
   at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
   at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
   at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
   at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:544)
   at org.hibernate.impl.SessionImpl.save(SessionImpl.java:533)
   at org.hibernate.impl.SessionImpl.save(SessionImpl.java:529)
   at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:693)
   at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
   ... 18 more
Caused by: java.sql.SQLException: requires either DEFAULT keyword or OVERRIDING clause
   at org.hsqldb.jdbc.Util.sqlException(Util.java:200)
   at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3870)
   at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:2654)
   at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:482)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:409)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.hibernate.util.GetGeneratedKeysHelper.prepareStatement(GetGeneratedKeysHelper.java:45)
   at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:435)
   at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:93)
   at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1948)
   ... 34 more



What is wrong?
Top
 Profile  
 
Syargey
 Post subject: Re: insert problem: hibernate passes null to identity column
PostPosted: Tue Feb 02, 2010 9:17 am 
Newbie

Joined: Sat Jan 30, 2010 6:17 pm
Posts: 5
I think, Hibernate should not specify a value for id as it is equal to unsaved value "null".
But Hibernate specifies a value.
Top
 Profile  
 
kossmo
 Post subject: Re: insert problem: hibernate passes null to identity column
PostPosted: Tue Feb 02, 2010 10:08 am 
Regular
Regular

Joined: Thu Dec 10, 2009 10:53 am
Posts: 50
When you are trying to insert/save the "user", is it's id still null? This would be the expected behaviour, I think.

Can you show the code how save/insert the "user"?
Top
 Profile  
 
Syargey
 Post subject: Re: insert problem: hibernate passes null to identity column
PostPosted: Tue Feb 02, 2010 2:46 pm 
Newbie

Joined: Sat Jan 30, 2010 6:17 pm
Posts: 5
It is rather complex to put all the code here. But it works like:
Code:
User user = new User( name, password );
session.save( user );


Class User:
Code:
public class User
{
    private Integer userID;
    private String name;
    private String password;
   
    public User( String name, String password )
    {
        this.userID = null;
        this.name = name;
        this.password = password;
    }
}


A passed object has set name and password. userID is null.
Top
 Profile  
 
Syargey
 Post subject: Re: insert problem: hibernate passes null to identity column
PostPosted: Tue Feb 02, 2010 4:23 pm 
Newbie

Joined: Sat Jan 30, 2010 6:17 pm
Posts: 5
I found the cause of the problem: an identity column definition is not correct. So HSQLDB doesn't generate value for the column.

I changed the table definition by replacing GENERATED ALWAYS AS IDENTITY with GENERATED BY DEFAULT AS IDENTITY.

Code:
CREATE MEMORY TABLE user
(
  user_id  INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 100),
  name     VARCHAR(40),
  password VARCHAR(40),
  CONSTRAINT user_pk PRIMARY KEY ( user_id ),
  CONSTRAINT user_unique1 UNIQUE ( name )
);


It fixes the problem.

Anyway thanks for assistance.
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.