Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.2

Full stack trace of any exception that occurs:

Name and version of the database you are using:Oracle 10g R2

I would like to fetch UI labels (which are displayed on the browser) from the RDBMS.

The tables have been designed in the following fashion.

LABEL_M
label_id long pkey,
label_key NVarchar unique key

and

LABLE_VALUE_M
value_id long pkey,
label_id long fkey references Label_M(labelid)
label_value NVarchar
language NVarchar (references the language master table)


The idea is to fetch all the labels (for a particular language) at once during system startup and put it in the 'application' scope.
Using objects mapping to each of these objects seems to be an expensive way of storing these objects in memory.

Can I possibly have a HashMap which would store for a particular language the following details:

EngMap
key maps to 'label_key'
value maps to 'label_value'

Also, please let me know if this thinking is in the right direction, or am I missing the plot entirely.

Cheers