Hi guys,

Has anyone tried Hibernate with DB2 for z/OS. I tried both drivers for DB2 that come with Hibernate and they didnt seem to work. What bothers me is that the version that we have (and I read in the Internet that this is so in all version of DB2 for z/OS), I need to perform commit after every operation on the DB, inluding selects. The other issue is that when a change in the data occurs (with update or insert) the DB2 sends SQLCODE with the value 0 and another message with the actual changed rows. Something like that:

DSNE615I NUMBER OF ROWS AFFECTED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0

Hibernate assumes that the affected rows are 0 and brings an error.

Your help will be appreciated.
Cheers
Emil

Anyone?

I work on DB2/400, so we can maybe share some experience.

But in your post everything seems right :



1 row affected, SQLCODE is 0 (so no error).

Can you provide some more info on the (eventual) error you receive ?

Giulio