best solution for updating many objects ?

Björn Agel <[email protected]> Mon, 16 Apr 2007 16:15:57 +0200

Newsgroups	gmane.comp.jakarta.ojb.user
Message-ID	<[email protected]>

hi,

say we have a table, where many thousands objects with about 30 fields 
are stored.
Now I want to update only 1 of these 30 colums for a few hundred objects.

Atm I retrieve every single object, change 1 value and store it ...

What is the best solution for this task ?
Is there anything similar to the "ALTER TABLE" statement ?

with best regards,
BjÃ¶rn Agel