Hello,

i need to execute this sentence (DB2 sequence):

in hibernate api to set a property. As it isn't the id, I can't use the generator sequence at the mapping.

thanks a lot,
César.

I didn't quite understand what you ment by "in hibernate api to set property" but there's nothing to stop you from accessing the JDBC connection and just executing a SQL statement to retreive the nextval. Since your not strictly speaking querying for a object this seems the most straight forward course of action.

i did it like you told me and it works.


but i wanted to do it with Hibernate, not with JDBC.

any idea???

César.

Hibernate will take care of this for ids but for arbitary columns I don't know of anything. There are a lot of new features in 3.x so perhaps there's something there but I'm not very familiar with 3.x yet.

I'm haven't tried this and I'm not sure if this would work, but you could try creating a named sql query and specify it as a formula attribute in your mapping.

<property name="myPropery" column="myProperty" formula="myNamedQuery"/>

<sql-query name="myNamedQuery">
<return-scalar column="myProperty" type="int"/>
VALUES NEXTVAL FOR SEQ1
</sql-query>

We are having success using a custom DB2 Dialect As follows:

**************************************************

import org.hibernate.dialect.DB2Dialect;

/**
*/
public class DB2CustomDialect extends DB2Dialect {

/*
* @see org.hibernate.dialect.Dialect#getIdentitySelectString()
* Implemenation copied from DB2390Dialect
*/
public String getIdentitySelectString() {
return "select identity_val_local() from sysibm.sysdummy1";
}

/*
* @see org.hibernate.dialect.Dialect#getSequenceNextValString(java.lang.String)
* Added to correct syntax for Z/OS DB2 Full Function Mode
*/
public String getSequenceNextValString(String sequenceName) {
return "select next value for " + sequenceName + " from sysibm.sysdummy1";
}

}