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]
