Dan, Michael,
Thanks for having reported this problem.
This issue has just been fixed and should be shipped as part of 1.0.1.
In a few words, by default an UPDATE statement is dynamically generated
each time that a CMP needs to be persisted. This statement only updates
the modified fields.
. Januar 2006 19:10
An: user@geronimo.apache.org
Betreff: Re: AW: AW: Geronimo CMP update statements
Michael,
IMO the current SQL generation is not consistent with what I've seen in other
AppServers. I don't have any specific data yet but I know for at least DB2 the
DB2 developers I've talked
We've used CMP a fair amount before at work, and IMO there's no reason
it can't be made to perform well for most cases (you know, not
necessarily for dynamic queries or updating 1000s of rows at once).
But I have to say, the SQL generation in Geronimo is something I've
never seen before, and it's
Aaron Mulder wrote:
We've used CMP a fair amount before at work, and IMO there's no reason
it can't be made to perform well for most cases (you know, not
necessarily for dynamic queries or updating 1000s of rows at once).
But I have to say, the SQL generation in Geronimo is something I've
On 1/28/06, Daniel John Debrunner [EMAIL PROTECTED] wrote:
Why would anyone select the first option, less than optimal single update?
I assume if statement caching was particularly effective for their
database or application. Either at the JDBC level (reusing the same
PreparedStatement) or at
Aaron Mulder wrote:
We've used CMP a fair amount before at work, and IMO there's no reason
it can't be made to perform well for most cases (you know, not
necessarily for dynamic queries or updating 1000s of rows at once).
But I have to say, the SQL generation in Geronimo is something I've
Hello Matt,
yes, this works. Thanks for the hint.
I think geronimo sends a statement like this one to the database
UPDATE table SET col1 = CASE WHEN false THEN null ELSE col1 END, col2 = CASE
WHEN true THEN newValue ELSE col1 END, ...
and Oracle does not know how to handle the boolean values