I cannot save my objects to the DB. I can do updates fine, but am having trouble creating a new object and saving it in my database.

My DAO object has the following code:
Session session = openSession();
Transaction tx = null;

try {
tx = session.beginTransaction();
Product p = new Product (new Long(4444),
"Chair",
new Double(1.99));
session.save(p);
tx.commit();
}
catch(...) { ... handle exception ... }

When I turn on show_sql=true I see the following in my log file:

Hibernate: insert into PRODUCT (DESCRIPTION, PRICE, ID) values (?, ?, default)

Are the "?" and the word "default" OK?
Then I receive an error from the DB2 database:

JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -407, SQLState: 23502

JDBCException E net.sf.hibernate.util.JDBCExceptionReporter [IBM][CLI Driver][DB2/NT] SQL0407N
Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=2, COLNO=0" is not allowed. SQLSTATE=23502

Can anyone shed some light on what is going on here?
The DB says my values are NULL, but they are not.

Thanks,
Bill

Please give us your mapping

I just figured it out.

In my mappnig file I have generator="native" and the problem was that since I am using a DB2 database I have to create the table with

create table products(
id integer not null primary key with default (start 0, increment 1)

I did not do that, I just set up the table as:

create table products(
id integer not null primary key)

When Hibernate generated the SQL it looked like:

insert into product (description, id) values (?, default)

The "default" string apparently has special meaning in DB2, and it tells the database to generate the next unique value for this row. Since I didn't tell DB2 how to generate the key when I created the table, it didn't know how to do so it complained that I was trying to insert NULL into a NOT NULL column.

So to sum it up, once I created the table as define above, everything worked.

Thanks
Bill