• Post Reply Bookmark Topic Watch Topic
  • New Topic

Getting Data in the form of CSV files

Himanshu Khanna
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 ??
Hey! Wanna see my flashlight? It looks like this tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!