JDBCImporter 0.71 review

JDBCImporter provides a consistent mechanism for importing data from a file to a database, exporting data from a database to a file,

License: LGPL (GNU Lesser General Public License) File size: 0K Developer: Chris Nagy

0

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.

JDBCImporter API 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.

Installation:

Below are the installation steps for installing JDBC Importer:

unzip the jdbcimporter.zip file
add jdbcimporter.jar and commons-logging.jar to the CLASSPATH.

For example: set CLASSPATH=%CLASSPATH%;INSTALL_DIRlibjdbcimporter.jar;INSTALL_DIRlibcommons-logging.jar
JDBC Importer

Basic Usage:

> java [options] net.sourceforge.jdbcimporter.Importer [plugin file]

where :

config file : the import config file
plugin file : the (optional) property file that describes the plugins available during the import
options : two system properties may be set (both are optional)
jdbcimporter.engine = The import engine to use
jdbcimporter.failonerror = Flag indicating that the import should end if an error occurrs

What's New in This Release:
Added new attribute on entity element called 'encoding'
Added sample export engine that uses an entity property for the select statement