It is possible to customize XMLType updates handling. But as you need to
modify SQL semantics that goes beyond JDBC, just installing an
ExtendedType is not enough. As Joe suggested, you need to tap into update
query translation/execution phase.
So you should probably customize UpdateBatchQueryBuilder (within DataNode
in 1.1 or within SQLAction in 1.2).
Andrus
> Cayenne doesn't have any support for this. We have successfully used
> XMLType mapping to a CLOB, but it is only read only. For us, this is
> fine... We only use XMLType for bringing back reports suitable for an
> XSL transform.
>
> I'm really not sure how you would get what you need done. I assume by
> updating with an XMLType, you're talking about updating a series of
> fields and/or tables, and not just an individual field?
>
> If you just want to update a single field as an atomic XMLType field,
> you are on the right track with adding an extended type.
>
> Cris
>
>> And how will Cayenne know about how to update the XMLType
>> field if i modify
>> it ? Since it needs to generate SQL like "update a set
>> a.b=XMLTYPE(?)" ...
>>
>> Regards
>> René
>>
This archive was generated by hypermail 2.0.0 : Fri Mar 04 2005 - 10:54:36 EST