I am reading data from excel and storing it in database..
my excel file contains 50,000 rows..the soon i started uploading it is throwing out of memoryexception..
it will upload 2000 rows without any problem..am using tomcat 5 and oracle10g..pls tell me what will be the problem...is that anything related to coding part or server side (DB)problem.do i need to change anything config in tomcat..?am using jxl jar files for reading data from excel like workbook and sheet.
I have a doubt if my code contains any problem then it should throw error when i upload of file size 1MB..but it does not.....i dont understand how to fix this....i have surfed google abt this and tried to increase the heap size..but no solution.pls tell me one suggestion
thanx in advance