Hibernate version: 2.1.4

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
Informix Dynamic Server 7.24

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Some of our legacy database tables have primary keys which have some business meaning. And the application should be able to modify these keys. Hibernate doesn't allow modifying the primary keys. When I do that, I get key column value modified exception. Is there a way to handle this? Changing the table structure is not an option for me, since my application has to co-exist with the legacy application.

it's not possible, do it in a DAO method implemented using jdbc
but be carefull with first and second level caches

Just another thought, though not a portable solution. If I define the rowid column as a primary key instead of the actual primary key of the column, can I update the keys?

read all about identities and key definition in hibernate in action, be sure to understand all this.
This is the most important part of the mapped object.

I am using a Stateless Session Bean in my application. And, retrieving the POJO in one EJB method and passing it on directly to the web-tier. The web-tier updates the POJO and sends it back to another EJB method, which would persist the object to database.

If I don't enable 2nd level cache for this POJO class, I guess Hibernate won't try to cache it. So, I have to only worry about the 1st level cache, which happens only at the Session level. For the Session cache, I could evict() the object after its use in the EJB. I guess this will take care of the caching issue. Am I missing anything?


Another related question:

Before I update the row using JDBC, I want to lock the row. Can I use the Hibernate's Session.load(Class, key, LockMode.UPGRADE) to lock the row and then use JDBC to update the same row in my EJB method?

What about changing the DB schema to have a real surogate primary key. But maybe this isn't an option for you.

HTH
Ernst