Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
JRower: load Oracle tables from flat files (Csv, Excel, Delimited)
12 views
Skip to first unread message
jdono...@gmail.com
Nov 13, 2005, 7:01:21 PM11/13/05
to
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.
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.
GreyBeard
Nov 13, 2005, 8:33:59 PM11/13/05
to
On Sun, 13 Nov 2005 16:01:21 -0800, jdonohue55 wrote:
> JRower is a tool for loading relational database tables from flat
> files. It is useful in situations where your database table undergoes
Loverly - a J2EE alternative to the free Oracle-supplied and
Oracle-supported External Table capability. Well done!
jdono...@gmail.com
Nov 20, 2005, 11:38:45 AM11/20/05
to
True, later versions of Oracle allow you to treat a flat file as a
database, and of course SQLLoader is also available to load flat files.
However, the need JRower was written to address is where you want to
give the end user the ability to "upload" their spreadsheet to a
database through a friendly user interface. The user interface does
some data validation before accepting the data. Additionally there may
be many user's who's spreadsheets may only be a sub-set of the database
rows. In the "Bowling Team" example each team captain uploads only
the data for his team to a database of all teams. The end user can't
replace the entire database at will, but can only execute limited load
logic that has been setup in advance by the programmer or DBA. The
load logic is saved in XML files, that can be added or edited without
deploying new code.
The point of JRower is to give Java programmers, in the words of
another poster, "a SQLLoader-type API", that they can use to create
user interfaces to allow end users to "upload" their spreadsheets.
database, and of course SQLLoader is also available to load flat files.
However, the need JRower was written to address is where you want to
give the end user the ability to "upload" their spreadsheet to a
database through a friendly user interface. The user interface does
some data validation before accepting the data. Additionally there may
be many user's who's spreadsheets may only be a sub-set of the database
rows. In the "Bowling Team" example each team captain uploads only
the data for his team to a database of all teams. The end user can't
replace the entire database at will, but can only execute limited load
logic that has been setup in advance by the programmer or DBA. The
load logic is saved in XML files, that can be added or edited without
deploying new code.
The point of JRower is to give Java programmers, in the words of
another poster, "a SQLLoader-type API", that they can use to create
user interfaces to allow end users to "upload" their spreadsheets.
0 new messages