aspose file tools*
The moose likes JDBC and the fly likes Getting Data in the form of CSV files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Getting Data in the form of CSV files" Watch "Getting Data in the form of CSV files" New topic
Author

Getting Data in the form of CSV files

Himanshu Khanna
Greenhorn

Joined: Aug 15, 2001
Posts: 29
Hello All,
My application is supposed to receive data in the form of CSV files and I need to break the files , perform certain validations on the received data ( both data level and DBase level validations) , store the valid data & return back the error data .
Performance is an issue here .
I was thinking of implementing everything in Java (breaking , validations etc.) , get a connection & then save the data .
But I somebody advised me to go in for Stored Procedures as they are faster. I wanted to ask wether I can pass a CSV file or a collection object to a Stored Procedure directly ??
Moreover , can anybody please supply me the code for parsing a CSV file ??
Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Getting Data in the form of CSV files