Re: best solution for updating many objects ?

Sorry, can't help. I'm using Spring Jdbc abstraction to do plain sql calls.

Cheers,
  Vasily

On 4/19/07, Björn Agel <[email protected]> wrote:
> can you give a code example pls ?
>
> im sticking in how to execute plain sql with ojb ...
>
> thank,
> Björn
>
> Vasily Ivanov wrote:
> > 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
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>