I guess this is a bit of a digression but since we are on the topic...
IMHO finding multiple statements using semicolons would be less than
ideal, allowing the nesting of insert/update/delete/select tags would
be a more structured way to implement it and would remove the SQL
parsing burden from iBa
CsvBeans looks promising, I will try it out. I am using PostgreSQL and have
heard of the COPY feature, but have not looked into it yet.
Thanks for the sugestions,
> -Original Message-
> From: Alan Hicks [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 22, 2005 11:39 AM
> To: user-jav
I stumbled across a project: www.csvBeans.org . It generates beans from a
CSV file. The mappings are defined using XML.
Worth a look -saved me loads of time.
Alan.
On Thu, 22 Sep 2005 18:57:57 +0100, Warren Bell
<[EMAIL PROTECTED]> wrote:
My company has several vendors who send us invoi
From experience, your best bet is to load the flat file into a staging
table in your database, process the data in that table (convert to upper
case, trim strings, fix dates, etc.) then insert into your "live" tables.
In Data Warehousing, this process is called ETL (extract transfer and
load
Oracle also has a utility called SQL*Loader
http://www.orafaq.com/faqloadr.htm
On Sep 22, 2005, at 12:06 PM, Larry Meadors wrote:
There are jdbc drivers for csv files, that could simplify one end
of the task.
http://tinyurl.com/bwrpn
You may want to look to your db vendor, too - I know M$
There are jdbc drivers for csv files, that could simplify one end of the task.
http://tinyurl.com/bwrpn
You may want to look to your db vendor, too - I know M$ SQL has tools
for importing this sort of data...and i suspect others do, too.
Larry
On 9/22/05, Warren Bell <[EMAIL PROTECTED]> wrote:
My company has several vendors who send us invoices in the form of comma
delimited flat text files via FTP. My question is, is there a way using
Ibatis to pul in the data from the text file and insert it into a table. I
can get the data in manually and use Ibatis to insert into the table, but it
wo
