Re: [dbunit-user] oracle.sql.struct not showing up in dataset export

[Federico S. <f.s...@ma...>]

Howdy,
Alex Bonjour wrote:

> Hi all,
>
> I am trying to use dbunit on a database that uses oracle.sql.STRUCT to 
> persist polygon information using the oracle spatial package. 
>
> If I use the default dbunit settings for exporting a table containing 
> spatial data I get no information for the column.  Here is an 
> abreviated table description:
>
Ok, I'm not the best espert but as I've had some problems with db2xml 
datatypes I'll try to answer.
dbUnit seems to relay heavily on JDBC compliance: for me this mean two 
things at least:
1 - the JDBC driver should report a value of Types.OTHER for the sql 
type of a column not in the standard JDBC types set
2 - under the condition above, dbUnit itself should know how to deal 
with that datatype.
As dbUnit doesn't know anything about oracle.sql.STRUCT, it will ignore it.
As work is underway to tackle this issue with customized datatypes, it 
would be fine if you can provide at least the sql data type returned by 
your JDBC driver for the type you want to export ("DATA_TYPE" value of 
the metadata returned by a call to 
connection.getMetaData().getColumns(<CATALOG>, <SCHEMA>, 
ECEF_COLLECTION_PARMS, "polygon")): this will allow to understand which 
part of the code you'll need to hack.
Cheers,
federico