Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting Data in the form of CSV files

 
Himanshu Khanna
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic