commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Willie Vu" <willi...@yahoo.com>
Subject RE: [jelly] csv file to database
Date Thu, 30 Jan 2003 03:04:36 GMT
> -----Original Message-----
> From: Gordon [mailto:gordon@zareus.com] 
> Sent: Wednesday, January 29, 2003 12:04
> To: commons-user@jakarta.apache.org
> Subject: [jelly] csv file to database
> 
> 
> Would Jelly be a good tool to import a CSV file into a 
> database? If so what tag would I use to parse the CSV file?
>

The SQL tags can simplify coding JDBC stuff.  Jelly will be a greater help
if you need to marshall data before importing into database.  You will
convert the CSV into XML first and then XSLT it as you see fit.  The missing
part is a CSV tag.  Its implementation should be simple.  Just wrapper
around java.io.StreamTokenizer.  See
http://www-106.ibm.com/developerworks/xml/library/x-xmlexperts-csv/?dwzone=x
ml for an example.

Willie


Mime
View raw message