[dbunit-user] Handling Oracle-specific column types?

[Jacob S. <jh...@MI...>]

I'm using Oracle 10g, and have columns with Type_Name:

TIMESTAMP(6) WITH TIME ZONE
SDO_GEOMETRY

That I would like to use with DbUnit export/import. Currently I get exceptions
(see below). Any thoughts on how I can get these to work? I'm open to hacking
code if necessary, and/or making changes that could be accepted as a patch.

Thanks,

Jacob

org.dbunit.dataset.datatype.TypeCastException: Unable to typecast value
<oracle.sql.TIMESTAMPTZ@ac385a> of type <oracle.sql.TIMESTAMPTZ> to VARCHAR
	at org.dbunit.dataset.datatype.StringDataType.typeCast(StringDataType.java:132)
	at org.dbunit.dataset.datatype.DataType.asString(DataType.java:159)
	at org.dbunit.dataset.xml.FlatXmlWriter.row(FlatXmlWriter.java:185)
	... 7 more

org.dbunit.dataset.datatype.TypeCastException: Unable to typecast value
<oracle.sql.TIMESTAMPTZ@ac385a> of type <oracle.sql.TIMESTAMPTZ> to VARCHAR
	at org.dbunit.dataset.datatype.StringDataType.typeCast(StringDataType.java:132)
	at org.dbunit.dataset.datatype.DataType.asString(DataType.java:159)
	at org.dbunit.dataset.xml.FlatXmlWriter.row(FlatXmlWriter.java:185)
	... 7 more