I have an issue with Informix SERIAL ids as well, but it seems to be a bit different than what is discussed in the threads I have seen so far:
When I create a new object and save it, the insert sql hibernate creates does not include the primary key value in the insert. Even if I manually set the primary key value to zero to trigger the SERIAL auto-increment, the zero value never gets inserted to affect the informix id generator. As a result the insert results in a null value for the primary key (not sure what that says about informix since I have NOT NULL in the table definiton...)
Is there a way to include the primary key value in the insert sql on the initial save call? Or do I have to hack that with a manual series of calls such as
- initial save
-manual update call with id value zero
- one more update call get the generated value into the object's id member ( or worse a manual "select first 1 dbinfo('sqlca.sqlerrd1') from systables" call...)
I sure hope not as that's ugly :(
Thanks for the help.
My config, create table sql, bean and test code:
--------------------------------------------------------------------------------------
config
--------------------------------------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<class name="org.vaneyk.utilities.hibernate.informix.Prototype" table="table_prototype_hibernate">
<!-- primary key -->
<id name="id" column="id" type="java.lang.Long">
<generator class="native"/>
</id>
<!-- properties -->
<property name="a" column="a" type="integer"/>
<property name="b" column="b" type="integer"/>
<property name="c" column="c" type="integer"/>
<!-- associations -->
<!-- none -->
</class>
<!-- named queries -->
<!-- <query name="">...</query> -->
</hibernate-mapping>
--------------------------------------------------------------------------------------
create table sql
--------------------------------------------------------------------------------------
create table table_prototype_hibernate
(
id serial8 not null,
a integer,
b integer,
c integer
);
--------------------------------------------------------------------------------------
bean method
--------------------------------------------------------------------------------------
package org.vaneyk.utilities.hibernate.informix;
import java.io.Serializable;
import org.apache.commons.lang.builder.ToStringBuilder;
/** @author Hibernate CodeGenerator */
public class Prototype implements Serializable {
/** identifier field */
private Long id;
/** nullable persistent field */
private Integer a;
/** nullable persistent field */
private Integer b;
/** nullable persistent field */
private Integer c;
/** full constructor */
public Prototype(Integer a, Integer b, Integer c) {
// informix hack for SERIAL8 auto-increment
id = new Long( 0 );
this.a = a;
this.b = b;
this.c = c;
}
/** default constructor */
public Prototype() {
// informix hack for SERIAL8 auto-increment
id = new Long( 0 );
}
public Long getId() {
return this.id;
}
public void setId(Long id) {
this.id = id;
}
public Integer getA() {
return this.a;
}
public void setA(Integer a) {
this.a = a;
}
public Integer getB() {
return this.b;
}
public void setB(Integer b) {
this.b = b;
}
public Integer getC() {
return this.c;
}
public void setC(Integer c) {
this.c = c;
}
public String toString() {
return new ToStringBuilder(this)
.append("id", getId())
.toString();
}
}
--------------------------------------------------------------------------------------
test method
--------------------------------------------------------------------------------------
public void testPrototypeIntegerIntegerInteger()
{
Session session;
try
{
// create prototype
factory.beginTransaction();
session = factory.getSession();
Prototype prototype = new Prototype( a, b, c );
prototype.setId( new Long( 0 ) );
session.save( prototype );
session.flush();
// test
if ( prototype == null )
{
failed( "Contstructor returned null." );
}
else if (
( a.intValue() == prototype.getA().intValue() ) &&
( b.intValue() == prototype.getB().intValue() ) &&
( c.intValue() == prototype.getC().intValue() )
)
{
passed();
}
else
{
failed( "Constructor failed to process parameters correctly." );
}
// clean up
session.delete( prototype );
session.flush();
factory.commitTransaction();
}
catch( HibernateException he )
{
he.printStackTrace( System.err );
failed( he.getLocalizedMessage() );
}
}
-------------------------------------------------------------------------------------
results:
-------------------------------------------------------------------------------------
Hibernate: insert into table_prototype_hibernate (a, b, c) values (?, ?, ?)
Hibernate: select first 1 dbinfo('sqlca.sqlerrd1') from systables
test: pass
Hibernate: delete from table_prototype_hibernate where id=?
net.sf.hibernate.HibernateException: SQL insert, update or delete failed (row not found)
[edited rest of stack trace out...]
SQL insert, update or delete failed (row not found)
test: fail
Login
FAQ
Search
