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 Java 8 in Action this week in the Java 8 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

Getting Data in the form of CSV files

Himanshu Khanna

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 ??
I agree. Here's the link:
subject: Getting Data in the form of CSV files
Similar Threads
Writing csv files
populate data from csv into oracle
Web Application Configuration Question
How to download a csv file through java without using input and output streams
Can POI read CSV files