This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
It's not a secret anymore!