I have requirement of exporting data to csv file. I am currenly using hibernate to perform normal db operations. My query is, whether I can use hibernate to get 100k records and trasfer them to csv file as per the business requirement.

   I have the feeling that hibernate might not be a good option of such requirment and I shall try using normal jdbc call with resultset object.

Thanks and Regards