geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Neil Gray" <nabg_h...@hotmail.com>
Subject Problem with CMP-update code and Oracle
Date Mon, 21 Nov 2005 22:13:59 GMT
When I tried setting up a connection to Oracle 10g (10.1.0.x) for an entity 
bean I got
SQL errors from the update statements that were generated for the beans.
The SQL code generated is of the form:
update mytable set balance = case when ?  then ? else balance end where 
customername = ?

Oracle complains of an invalid relational operator; it doesn't seem to like 
"when ? then" where the "?" parameter just gets assigned a true/false value.

Is there any extra parameter that modifies the generated CMP code by 
database type?

_________________________________________________________________
Start something musical - 15 free ninemsn Music downloads! 
http://ninemsn.com.au/share/redir/adTrack.asp?mode=click&clientID=667&referral=HotmailTaglineNov&URL=http://www.ninemsn.com.au/startsomething


Mime
View raw message