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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
