main
Netezza
Overview
org.dbunit.ext.netezza provides IBM Netezza-specific type recognition and
metadata handling for dbUnit.
IDataTypeFactory
NetezzaDataTypeFactory
maps Netezza’s JDBC type codes (its own constants, since several diverge from
java.sql.Types, e.g. BOOLEAN, INTERVAL/TIMETZ as timestamps,
VARFIXEDCHAR/NUCL/PROT as char, INT8 as bigint) onto the matching
DataType constants. Register it via
DatabaseConfig.PROPERTY_DATATYPE_FACTORY — see
Properties and
Connections & Configuration.
IMetadataHandler
NetezzaMetadataHandler accounts for Netezza exposing only a catalog, no schema: it treats the catalog as the schema when matching and looking up columns/tables/primary keys, so dbUnit’s schema-based lookups work against a database that doesn’t have schemas in the JDBC sense.
Connection Preconfiguration Class
None — Netezza has no dedicated IDatabaseConnection subclass. Register
NetezzaDataTypeFactory and NetezzaMetadataHandler directly on a plain
DatabaseConnection’s `DatabaseConfig:
IDatabaseConnection connection = new DatabaseConnection(jdbcConnection, schema);
DatabaseConfig config = connection.getConfig();
config.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new NetezzaDataTypeFactory());
config.setProperty(DatabaseConfig.PROPERTY_METADATA_HANDLER, new NetezzaMetadataHandler());