«

I have a large application which has a number of cases where certain
constants exist as both java "static final int" and in a database table of
the general form (id, shortname, longdescription...), where the id should
correspond with the java constant. Unfortunately, because things have to be
maintained in two places, and people are not perfect (damn them!), things
can get out of sync.

I'm looking for a way to unify the two somehow so there is a single point of
maintenance - the database.

I have one or two ideas of my own, but I would like to know if there are
useful techniques for this already documented.

TIA

Jim Smith

"JIm Smith" <> wrote in message
news:...
> I have a large application which has a number of cases where certain
> constants exist as both java "static final int" and in a database table of
> the general form (id, shortname, longdescription...), where the id should
> correspond with the java constant. Unfortunately, because things have to
be
> maintained in two places, and people are not perfect (damn them!), things
> can get out of sync.
>
> I'm looking for a way to unify the two somehow so there is a single point
of
> maintenance - the database.
>
> I have one or two ideas of my own, but I would like to know if there are
> useful techniques for this already documented.

A class that maps to your contstant table, instantiating the rows at start
up?

--
Mike W