id is not set after getSession().save()

iririr · **Joined:** Thu Mar 19, 2009 8:19 pm **Posts:** 12

I was wondering if anyone could help me with a hibernate problem:

The problem is that the id of the object is not set after save. For instance:

Code:

AreaType areaType = new AreaType(null, "AREA"); //i initiall set the id to null
databaseManager.save(areaType);
areaType.getId() is null! //but the object is saved in database with an id.

Here is how the id is defined in AreaType.hbm.xml

Code:

<id name="id" type="java.lang.Integer" unsaved-value="null" column="id">
         <generator class="sequence">
            <param name="sequence">area_type_seq</param>
         </generator>
</id>

I also tried using using my own SequenceGenerator but it didn't help.

Code:

public Serializable save(Object entity) throws NamingException,
      HibernateException
  {
    return getCurrentSession().save(entity);
  }

I am using Hibernate 3, Postgresql 8.3

Any ideas?

saikrrishna.ch · **Joined:** Tue May 12, 2009 2:53 am **Posts:** 8

call "flush" on the session(getSession().flush()) and then try to get the object from the DB.

iririr · **Joined:** Thu Mar 19, 2009 8:19 pm **Posts:** 12

Thanks for your replay,

but I have already tried that and it doesn't work.

Any other ideas?

CDillinger · **Joined:** Tue Oct 28, 2008 10:39 am **Posts:** 196

Are you sure your insert is executed und commited => show_sql? Can you see the row with a databasetool like PgAdmin?

saikrrishna.ch · **Joined:** Tue May 12, 2009 2:53 am **Posts:** 8

If you could see the new tuple(that you have updated through the code) in the DB ,then definitely "flush" should work..

The exact code snippet will be
**********************
AreaType areaType = new AreaType(null, "AREA"); //i initiall set the id to null
databaseManager.save(areaType);
databaseManager.flush(); // i'm assuming that "databaseManager" is an instance of Session
areaType.getId()
**********************

iririr · **Joined:** Thu Mar 19, 2009 8:19 pm **Posts:** 12

That's exactly what happens:

When I call databaseManager.save() followed by flush(), i see the the following in the log:

09:11:31,588 INFO [STDOUT] Hibernate: select nextval ('public.area_type_seq')
09:11:31,604 INFO [STDOUT] Hibernate: insert into public.area_type (name, id) values (?, ?)

the id and name is set in the table,

but still the id is null, after areaType.getId()

Do I have to call areaType.getId() in another transaction or does that matter?

I also tried this (thought that maybe setting the id to null through the constructor is the cause but no luck):

Code:

 AreaType areaType = new AreaType();
 areaType.setName("name");
 databaseManager.save(areaType);
databaseManager.flush();

mazhar · **Posted:** Wed May 13, 2009 12:59 pm

very strange problem indeed....
If you can see the Id in the DB then it means only 1 thing, the Id is not cached (which is strange as this is the "id" column).
Is there a chance that you are using a CacheMode other than CacheMode.NORMAL?
Just a shot in the dark!

iririr · **Joined:** Thu Mar 19, 2009 8:19 pm **Posts:** 12

Not sure where to find that information

here is my hibernate settings:

Code:

   <mbean code="org.jboss.hibernate.jmx.Hibernate" name="jboss.har:service=Hibernate">
      <attribute name="DatasourceName">java:/PostgresDS</attribute>
      <attribute name="Dialect">org.hibernatespatial.postgis.PostgisDialect
      </attribute>
      <attribute name="DefaultSchema">public</attribute>
      <attribute name="SessionFactoryName">
         java:/hibernate/SessionFactory
      </attribute>
      <attribute name="CacheProviderClass">org.hibernate.cache.HashtableCacheProvider
      </attribute>
      <attribute name="ShowSqlEnabled">true</attribute>
      <attribute name="MaxFetchDepth">5</attribute>

      
   </mbean>

iririr · **Joined:** Thu Mar 19, 2009 8:19 pm **Posts:** 12

I also set the CacheMode to CacheMode.NORMAL but it didn't help.

Any other ideas?

java.abid@gmail.com · **Joined:** Thu Jan 15, 2009 9:54 am **Posts:** 12

Even i have the same problem.

can any body guess it why ??

here is my code.

getHibernateTemplate().save( cabRequestDTO ) ;
System.out.println(cabRequestDTO.getRequestId());

output is 0.

database is updated with a new record but not able to get the generated ID

mazhar · **Posted:** Thu May 14, 2009 6:06 am

At the moment all I can think of is, give org.hibernate.cache.NoCacheProvider a try instead of org.hibernate.cache.HashtableCacheProvider.
There are several articles on HashtableCacheProvider not being the best for production use, but that's a different issue.
Try with NoCacheProvider (or with no CacheProvider attribute at all, default was EhCache was the default prior to v 3.2).
All the best!

iririr · **Joined:** Thu Mar 19, 2009 8:19 pm **Posts:** 12

Well finally, I figured out why it's happening,

I perform the save from inside an ejb, and the id is set as soon as the save call is made.

however as soon as I leave the ejb (back to the client ), the id disappears!!

Here is the scenario:

unit test calls ejb to save an object.
id is set inside ejb.

unit test checks if the id is null or not.
id is null.

Now that's some weird magic...i guess it has to do with how RMI works, but don't have a clue how to get the id to stay.

littypreethkr · **Posted:** Wed May 20, 2009 1:17 am

If its an RMI call then the areaType object inside the EBJ is a different object than the one in the calling method. So as you are not returning the saved areaType from the EJB and assigning it to the areaType of calling method, the id field change will not be reflected.

Code:

AreaType areaType = new AreaType(null, "AREA"); //i initiall set the id to null
areaType = databaseManager.save(areaType);
areaType.getId()

iririr · **Joined:** Thu Mar 19, 2009 8:19 pm **Posts:** 12

Thanks littypreethkr, but I am still trying to figure out if there is a way to resolve this issue perhaps using
ejb annotation or configuration?

I noticed calling databaseManager from another ejb will result in the same behavior, i.e. the id disappears:

Here is the code for databaseManagerEjb and another ejb calling databaseManagerEjb :

Code:

@Stateless
@Remote(IDatabaseManager.class)
@TransactionManagement(javax.ejb.TransactionManagementType.CONTAINER)
@TransactionAttribute(javax.ejb.TransactionAttributeType.MANDATORY)
@RemoteBinding(jndiBinding = ServiceNames.AC_DATABASE_MANAGER)
public class DatabaseManagerEjb implements IDatabaseManager
{
  /**
   * @param entity
   * @return
   * @throws NamingException
   * @throws HibernateException
   */
  public Serializable save(Object entity) throws NamingException,
      HibernateException
  {
     return getCurrentSession().save(entity);
  }

/**
   * @return
   */
  public Session getCurrentSession() throws NamingException, HibernateException
  {
    Session hsession = null;
    SessionFactory factory = getSessionFactory();
    try
    {
      hsession = factory.getCurrentSession();
    }
    catch (Exception e)
    {

      e.printStackTrace();
      logger.info(e.getMessage());
      if (hsession == null)
      {
        hsession = factory.openSession();

      }
    }

    return hsession;
  }

  public SessionFactory getSessionFactory() throws NamingException,
      HibernateException
  {
    SessionFactory factory = null;
    try
    {
      InitialContext ctx = new InitialContext();
      factory = (SessionFactory) ctx
          .lookup(ServiceNames.HIBERNATE_SESSION_FACTORY);
    }
    catch (Exception e)
    {
      e.printStackTrace();
      logger.info(e.getMessage());
    }

    return factory;
  }

}

Other ejb

Code:

@Stateless
@Remote(IAreaManager.class)
@TransactionManagement(javax.ejb.TransactionManagementType.CONTAINER)
@TransactionAttribute(javax.ejb.TransactionAttributeType.REQUIRES_NEW)
@RemoteBinding(jndiBinding = ServiceNames.AC_AREA_MANAGER)
public class AreaManagerEjb implements IAreaManager
{
public Area createArea(Date creationTime, Date modificationTime,
      Geometry geometry)
  {
    
    Area area = new Area(null, creationTime, modificationTime, geometry);
    try
    {
      databaseManager.save(area);
      //area.getId() is null
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
    return area;
  }

}

mazhar · **Posted:** Wed Jun 03, 2009 9:00 am

Does the AreaType object implement Serializable?