Migrating from Hibernate 2 to Hibernate 3. I have almost completed the migration but after some testing I found out that I am unable to update or delete. Oddly enough I can save, but I don't seem to know why I cannot update or delete.

I tried to see if any errors occured, but none that were visible. It seems to complete the call but nothing gets updated or deleted in the database.

After a lot of testing to see where the error might be, I think I found it but not sure. I am using JBoss so I am packaging my hibernate stuff in a HAR file. When I look at the log when JBoss starts up and Hibernate initializes I see the following:

09:27:15,309 INFO [Configuration] processing association property references
09:27:15,309 INFO [Configuration] processing foreign key constraints
09:27:15,387 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
09:27:15,402 INFO [SettingsFactory] Maximum outer join fetch depth: 2
09:27:15,402 INFO [SettingsFactory] Default batch fetch size: 1
09:27:15,402 INFO [SettingsFactory] Generate SQL with comments: disabled
09:27:15,402 INFO [SettingsFactory] Order SQL updates by primary key: disabled
09:27:15,402 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.AST
QueryTranslatorFactory
09:27:15,418 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
09:27:15,418 INFO [SettingsFactory] Query language substitutions: {}
09:27:15,434 INFO [NamingHelper] JNDI InitialContext properties:{}
09:27:15,434 INFO [DatasourceConnectionProvider] Using datasource: java:/MySqlD
S
09:27:15,746 INFO [SettingsFactory] JDBC batch size: 15
09:27:15,746 INFO [SettingsFactory] JDBC batch updates for versioned data: disa
bled
09:27:15,746 INFO [SettingsFactory] Scrollable result sets: enabled
09:27:15,746 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
09:27:15,746 INFO [TransactionFactoryFactory] Transaction strategy: org.hiberna
te.transaction.JTATransactionFactory
09:27:15,746 INFO [NamingHelper] JNDI InitialContext properties:{}
09:27:15,746 INFO [TransactionManagerLookupFactory] instantiating TransactionMa
nagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
09:27:15,746 INFO [TransactionManagerLookupFactory] instantiated TransactionMan
agerLookup
09:27:15,762 INFO [TransactionManagerLookupFactory] instantiating TransactionMa
nagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
09:27:15,762 INFO [TransactionManagerLookupFactory] instantiated TransactionMan
agerLookup
09:27:15,762 INFO [SettingsFactory] Automatic flush during beforeCompletion():
enabled
09:27:15,762 INFO [SettingsFactory] Automatic session close at end of transacti
on: enabled
09:27:15,762 INFO [SettingsFactory] Cache provider: org.hibernate.cache.TreeCac
heProvider
09:27:15,762 INFO [SettingsFactory] Second-level cache: enabled
09:27:15,762 INFO [SettingsFactory] Optimize cache for minimal puts: enabled
09:27:15,762 INFO [SettingsFactory] Structured second-level cache entries: enab
led
09:27:15,762 INFO [SettingsFactory] Query cache: disabled
09:27:15,762 INFO [SettingsFactory] Statistics: disabled
09:27:15,762 INFO [SettingsFactory] Deleted entity synthetic identifier rollbac
k: disabled

I presume the statement of "Order SQL updates by primary key: disabled" disables the update.