JDBC Importer

Contents of this Release

README   - text version of this file

lgpl.txt - license

build.xml, build.properties - Ant build script

lib/
  jdbcimporter.jar           - JDBC Importer framework
  jdbcimporter-anttask.jar   - JDBC Importer Ant tasks
  jdbcimporter-unittests.jar - JDBC Importer unit tests
  jdbcimporter-webtest.war   - JDBC Importer web test (see tests/webtest/README)
  commons-logging.jar        - Apache Commons Logging 1.0.2 (see commons-logging.license.txt)
  
docs/           - architecture and tutorial documents
  api           - javadoc

src/            - java source code  

samples/        - sample data and jdbcimporter xml configs

tests/          - additional tests

Installation

Below are the installation steps for installing JDBC Importer:

1. unzip the jdbcimporter.zip file
2. add jdbcimporter.jar and commons-logging.jar to the CLASSPATH.
   For example: set CLASSPATH=%CLASSPATH%;INSTALL_DIR\lib\jdbcimporter.jar;INSTALL_DIR\lib\commons-logging.jar

JDBC Importer

Basic Usage:

> java [options] net.sourceforge.jdbcimporter.Importer <config file> [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

Extending:

There are 5 ways to extend JDBC Importer:

1. creating a custom delimiter parser
2. creating a custom row translator
3. creating a custom column translator
4. creating a custom connection definition
5. creating a custom import engine

Please see the tutorials and architecture document for more details.

JDBC Exporter

Basic Usage:

> java [options] net.sourceforge.jdbcexporter.Exporter <config file> [plugin file] 

where :

• config file : the export config file
• plugin file : the (optional) property file that describes the plugins available during the export
• options : one system properties may be set (optional)
  jdbcexporter.engine = The export engine to use

Extending:

There are 4 ways to extend JDBC Exporter:

1. creating a custom delimiter formatter
2. creating a custom column translator
3. creating a custom connection definition
4. creating a custom export engine

Data Generator

Basic Usage:

> java net.sourceforge.datagenerator.DataGenerator <config file> [plugin file] 

where :

• config file : the generate config file
• plugin file : the (optional) property file that describes the plugins available during the data generation

Extending:

There are 2 ways to extend Data Generator:

1. creating a custom delimiter formatter
2. creating a custom column value generator