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]
