permaculture playing cards*
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 Android Security Essentials Live Lessons this week in the Android 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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Getting Data in the form of CSV files
 
Similar Threads
How to download a csv file through java without using input and output streams
Writing csv files
Can POI read CSV files
Web Application Configuration Question
populate data from csv into oracle