hi can any one please tell me the maximum number of data result set can carry at a time and how he handles with that data say number of data is around 1 million.
It depends on (1) the underline JDBC impl provider and (2) how much memory your app server has. You can break it down to several chunks and process one chunk ( or several chunks) at a time.
