<id name="id" column="ID">
			<generator class="sequence">
				<param name="sequence">CONSUMER_SEQUENCE</param>
			</generator>
        </id>

        <id name="id"  column="CON_PEND_ITEMS_ID">
            <generator class="com.domain.model.TriggerGenerator">
	            <param name="sequence">seq_con_pend_items_id</param>
            </generator>
        </id>

 public   class  TriggerGenerator  extends  AbstractPostInsertGenerator  implements  Configurable
{
     private  String selectSequenceCurrentValString;
     private  Type idType;

     public   void  configure(Type type, Properties params, Dialect dialect)  throws  MappingException
    {
        String sequenceName = PropertiesHelper.getString(SequenceGenerator.SEQUENCE, params, "hibernate_sequence");
        selectSequenceCurrentValString = dialect.getSelectSequenceNextValString(sequenceName).replace("nextval", "currval");
         this .idType = type;
    }
    
     protected  String getSQL(PostInsertIdentityPersister persister)
    {
        String selectByUniqueKeyString = persister.getSelectByUniqueKeyString(selectSequenceCurrentValString);
         return  selectByUniqueKeyString;
    }

     protected  Serializable getResult(SessionImplementor session, ResultSet rs, Object object, PostInsertIdentityPersister persister)  throws  SQLException
    {
         if  ( !rs.next() ) 
        {
             throw   new  IdentifierGenerationException( "can't locate last inserted id");
        }
         return  (Serializable) idType.nullSafeGet(rs, persister.getRootTableKeyColumnNames(), session, object);
    }
}