Overview
CFX_JDataIO allows ColdFusion developers to import and export large amounts of data between flat files and
databases. Java technology is used to handle the processing of the file into data values and also used to
perform the database operations. This tag is compatible with any ODBC compliant database and since it is a
Java based tag is portable over a range of platforms.
How does it work?
The tag has two main modes:
Import Mode
Export Mode
Import Mode :
Import mode reads a flat file from a specified location, parses the file according to rules passed as attributes
to the tag, then inserts/updates a specified database based on SQL statement attributes.
Export Mode :
Essentially the reverse of Import, Export mode performs a query against a specified database and the results
written to a flat file according to rules passed to the tag.
Current Version
The tag is currently in alpha testing. It currently supports import of delimited flat files to ODBC compliant
databases.
Future releases will support the following:
- Export to delimited flat files
- Import/Export between XML files and database
- Use of custom JDBC drivers for accessing databases (Type IV Drivers)
- Microsoft Excel support
System Requirements
The following are the basic requirements for use of the tag. This tag has been tested thus far only on Windows based
operating systems.
- ColdFusion Server 5.0+
- ODBC Compliant database
- Java Standard Edition 1.3.x
|
