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