ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: Ibatis and flat files?
Date Thu, 22 Sep 2005 18:22:35 GMT
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$ SQL has tools
> for importing this sort of data...and i suspect others do, too.
>
> Larry
>
>
> On 9/22/05, Warren Bell <warren@clarksnutrition.com> 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
>> would sure be nice if I could use Ibatis and map the fields in the  
>> flat file
>> to my objects the same way they are maped from tables or say do a  
>> query
>> like:
>>
>> INSERT INTO table SELECT field1, field2 ... FROM flat_file
>>
>> These vendors have no other way to get us our invoices except paper.
>>
>> Thanks,
>>
>> Warren Bell
>>
>>
>>
>


Mime
View raw message