malachii wrote:
Hmm, if I can do that with HQL, then I would consider my problem solved. Can you point me in the right direction on where to look? I thought HQL was centered around correct mapping between the primary cache level in memory and the database, which as you point out, would be out of sync ( I think so anyhow! ).
Thanks,
Mal.
nope. HQL is a SQL abstraction language. You can write HQL queries just like SQL queries.
Hibernate requires however that you create mapping files for the tables in your database.
If all you're doing is updating tables, then Hibernate is not the correct tool for you. Basic JDBC would suffice.
link to configuration, mapping file, and HQL
http://www.hibernate.org/hib_docs/v3/reference/en/html/