Hello, All.

I'm having problem with using Informix DB version 7.3, trying to generate sequence. I use "native" as generator and put unsaved-value="0".

In Informix, to generate the ID we have to do INSERT INTO <TABLE> and put '0' in the sequence field and it will automatically assign a sequenced number.

But somehow in Hibernate (version 2.1) I'm getting this error:

org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Cannot insert a null into column (gen_ftp_status.gfs_id).
java.sql.SQLException: Cannot insert a null into column (gen_ftp_status.gfs_id).
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3203)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3517)

Is there any way I can insert a "0" instead of null ?

Following is some snippet of my hbm file:

<class
name="com.bigw.generic.bigwDFTP.hibernate.GenFtpStatus"
table="GEN_FTP_STATUS"
>
<meta attribute="class-description" inherit="false">
@hibernate.class
table="GEN_FTP_STATUS"
</meta>

<id
name="gfsId"
type="java.lang.Long"
column="GFS_ID"
unsaved-value="0"
>
<meta attribute="field-description">
@hibernate.id
generator-class="native"
type="java.lang.Long"
column="GFS_ID"

@hibernate.generator-param
name="native"
value="0"
</meta>
<generator class="native"/>
</id>


Is there anything I did wrong?

Thanks

check your code. Be sure that you are making something like myObject.setId(new Long(0)) before saving a new one.

I actually have solved this problem.

If we defined the column one-by-one apparently we still can let the Informix generate the id automatically.(i.e do set for the columns that we want to fill, as normal setXXX(blah))

So, what I did, I just set all the other columns as normal, without setting the Id. So I didn't set the Id setId(new Long(0)). Because this makes the code becomes un-portable to different database.

Thanks anyway for comments.