Re: best solution for updating many objects ?

thanks,

thats what i am searching for ;)

regards,
Björn

Armin Waibel wrote:
> Hi Björn,
>
> Björn Agel wrote:
>> can you give a code example pls ?
>>
>> im sticking in how to execute plain sql with ojb ...
>>
>
> you can lookup Statements from the connection and perform the update 
> by your own
> http://db.apache.org/ojb/docu/guides/connection.html#Can+I+directly+obtain+a 
>
>
>
> or you can use OJB service classes:
>
> broker.beginTransaction();
> ClassDescriptor cld = broker.getClassDescriptor(Article.class);***
> int result = broker.serviceJdbcAccess().executeUpdateSQL("UPDATE 
> ARTICLE A0 SET A0.TAX='23' WHERE A0.ID IN ('7','23', '34')", cld);
> broker.commitTransaction();
>
> *** If you execute plain SQL it should work with every 
> class-descriptor, no need to specify the correct one (but I never 
> tried this).
>
> regards,
> Armin
>
>
>> 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]
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>