Re: best solution for updating many objects ?

"Vasily Ivanov" <[email protected]> Wed, 18 Apr 2007 10:13:51 +1000

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

Hi Björn,

I usually do retrieve list of IDs via OJB's
getReportQueryIteratorByQuery and then run simple plain SQL to bulk
update one field in each record by id.

Cheers,
  Vasily

On 4/17/07, Björn Agel <[email protected]> wrote:
> 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