From: Federico S. <f.s...@ma...> - 2003-06-20 06:33:55
|
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 |