JDBC Importer / News: Recent posts

This release adds the BinaryDelimiterParser interface to parse binary files

This release fixes a bug with csv delimiter parser

This release adds an interface to modify rows during import and fixes a bug in export

This release adds an attribute called 'encoding' to the 'entity' element (that specifies the character set encoding)

This release adds the ability to generate column values during import and specify the element names for the XML Delimiter Formatter.

This release adds the capability to reference source data in a file or the database when generating rows. Also, a flag has been added to terminate the import if an error occurrs.

This release fixes the BeanInfo for the CSVDelimiterParser.

This release includes a fix for the way strings containing whitespace are handled with respect to parsing numbers and dates. Also, several new features were added : the ability to specify a file of sql statements that are executed before or after the import, the ability to specify a custom export engine per entity and the option to trim whitespace before and after a column value (before it is passed to the import engine)

This release includes a fix for the way schema and catalogs are handled and a new Database Aware Column Translator interface.

This release includes a fix for Delimiter Formatters, more options to parsing of csv files, and an option to specify an Import Engine per entity being importerd.

This release includes a fix for the CSV Column Delimiter Parser and support for binary and inputstreams to be imported/exported from the database.

This release moves the column translator definition into a 'translator' tag inside the 'column' tag and allows for properties to be set on the column translator. The old way of specifying the column translator is still available.
Also, all the column translators, column generators, delimiter parsers, delimiter formatters and connection definitions have default prefices.

This release fixes a bug and added boolean support. Two column translators have been created to convert values between boolean and integers.

This release includes new attributes for the csv delimiter formatter/parser and fixed delimiter formatter/parser. A new delimiter formatter/parser has been added that uses a pattern to format/parse a line.

This release fixes several bugs in parsing config xml attributes and attributes applied in Ant. Also, junit tests and JNDI connection (with web test) has been added.

The current release includes a couple of new tutorials for the Data Generator

A new version of JDBCImporter has been released that includes fixes to the UpdateEngine and Logger.

A new version of JDBCImporter has been released that includes tutorials for JDBCExporter and I have optimized a little bit of the data generator.

A new version of JDBCImporter has been released that adds logging (thru Apache Commons Logging) and fixes several problems with batch mode.

A new JDBCImporter has been released that adds an event listener that can be used to monitor the status of the import

I've released a new version of JDBCImporter with the folowing changes:

- entity elements can now have properties (which can be used by Import Engines)
- UpdateEngine now looks for 'selectPostfix' property on an entity whose value it will append at the end of the select sql statement it generates.
- JDK 1.3 level api

I've checked in code that adds the following features:

- A property element can be specified under a column element. this property is a key/value pair of strings that can be used by a delimiter parser, column translator and import engine
- The Update Engine (net.sourceforge.jdbcimporter.engine.UpdateEngine) now looks for the following properties on a column :
- name = 'primaryKey', value = 'true' : this will indicate that the column is part of the primary key
- name = 'updateExpression', value = '<expression>' : this will replace the normal '?' in the set part of update statement with the expression. the expression must have only one '?'
- Added 'batchCount' attribute to import element that specifies how many rows to import before committing or executing a batch update... read more