JRower: load Oracle tables from flat files (Csv, Excel, Delimited)
From: <jdonohue55_at_gmail.com>
Date: 13 Nov 2005 15:59:50 -0800
Message-ID: <1131926390.082530.306070_at_o13g2000cwo.googlegroups.com>
[Quoted] JRower is a tool for loading relational database tables from flat files. It is useful in situations where your database table undergoes periodic refreshes from an Excel spread sheet or other data file. You supply a XML file describing the fields in the file and their mapping to the database table columns and JRower performs the load. The data file can be a text file in CSV, delimited, fixed length, or Excel format. The XML file can also specify validations that the input data must pass before it is inserted to the database. A command line tool for running JRower is provided and also a Servlet for running JRower from a web page. JRower can also be embedded in your own Java program. Currently only Oracle is supported.
Date: 13 Nov 2005 15:59:50 -0800
Message-ID: <1131926390.082530.306070_at_o13g2000cwo.googlegroups.com>
[Quoted] JRower is a tool for loading relational database tables from flat files. It is useful in situations where your database table undergoes periodic refreshes from an Excel spread sheet or other data file. You supply a XML file describing the fields in the file and their mapping to the database table columns and JRower performs the load. The data file can be a text file in CSV, delimited, fixed length, or Excel format. The XML file can also specify validations that the input data must pass before it is inserted to the database. A command line tool for running JRower is provided and also a Servlet for running JRower from a web page. JRower can also be embedded in your own Java program. Currently only Oracle is supported.
See: http://www.jdonohue.com/java/jrower/doc/index.html for more information. Received on Mon Nov 14 2005 - 00:59:50 CET