Re: oracle.sql.RAW in Oracle table

Tobia Di Pisa ha scritto:
> Hi all,
>  
> I'm working on a Oracle table that has an attribute of type 
> 'oracle.sql.RAW'.
> 
> The write operation on this table is not permitted since the table is 
> considered by GT as read-only.
> 
> In debug I seem to have understood that the reason for this is that GT, 
> unable to map the RAW attribute, set the table as read-only.
> 
> This is the log message:
> 
> AVVERTENZA: Could not find mapping for 'ESP_COMP_COMPARABILE', ignoring 
> the column and setting the feature type read only.
> 
> Can you show me the way to resolve this problem? The use of a 
> 'OracleRawConverterFactory' is the right way forward ?

I see two options, both require some patching:
- we change the store to mark only the column as read only and
   ignore its contents during all updates and inserts
- you create a mapping for that type (I guess, towards byte[]?)
   and setup reading code for it.

For the latter you can get inspiration from the patch
at http://jira.codehaus.org/browse/GEOT-2005 that added
support for LOB data types.

Cheers
Andrea

--

-- 
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first