openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject Re: Update by query and MySQL
Date Thu, 29 Nov 2007 08:24:14 GMT

I don't have access to source right now, but you might be able to do
something with a setter on Select, which I believe is responsible for
creating the string (well, the SQLBuffer) for the WHERE and FROM
clauses. (As you may have noticed, the Select interface has evolved
into something more like a Statement interface.)

For example, a method called
omitTableAliasForSingleTableStatements(boolean) could do the trick.


On 11/28/07, Gokhan Ergul <> wrote:
> Gokhan Ergul wrote:
> > This will force openjpa to revert to in-memory bulk operation. Be
> > warned that it'll be grossly inefficient for anything beyond a few
> > rows, as openjpa will select the rows matching your where clause and
> > then issue a separate delete statement for each row.
> Oops, that should read update or delete, depending on the type of bulk
> operation.

Patrick Linskey
202 669 5907

View raw message