JDBCImporter A consistent mechanism for importing data from a file to a database
Download

JDBCImporter Ranking & Summary

JDBCImporter Tags

database api database API import data extract data JDBCImporter

JDBCImporter Description

A consistent mechanism for importing data from a file to a database 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.jarJDBC ImporterBasic Usage:> java net.sourceforge.jdbcimporter.Importer where :config file : the import config fileplugin file : the (optional) property file that describes the plugins available during the importoptions : two system properties may be set (both are optional) jdbcimporter.engine = The import engine to usejdbcimporter.failonerror = Flag indicating that the import should end if an error occurrs What's New in This Release: · Added header property for CSVDelimiterFormatter to set the initial contents of the csv file · Added BinaryDelimiterParser interface to parse binary files

JDBCImporter Related Software