hello,

I need help in that matter. it seems the answer is unreachable :-)

Hibernate version: 3.1
database: mySQL
application server: Jboss 4.0.1

I write an application with JBossAS (mention above) and Hibernate.
I have Reference tables, means tables that can be updated rarely. there are no updates to be made there.
I have two question:

1. How is the best way to work with Ref. tables using Hibernate? i mean, from performance point of view - (using batch fetch, lazy strategy or something else). i want to bring all data of those tables into the cache (so i need to enable the second level cache) - what is the best way to do it?

2. I want to load all the ref data (there are millions of rows) to the cache while jboss startup. how can i do it? i didn't find anything about loaing mass tables while the server is up?

thanks in advance,
Rafi