JDBCImporter

JDBCImporter provides a consistent mechanism for importing data from a file to a database, exporting data from a database to a file, and generating data. It can run from the command line using an XML config file or from inside an Ant build script. It works with CSV, fixed data, and XML files and supports numbers, strings, and date/times as database column types. Custom classes can be used to parse different file formats, format column values into different file formats, translate column values before importing or after exporting, or allocate or release JDBC connections.