I have to cache the oracle table in
java, the table has information such as user name,first name, last name and the size of the table is 1,50000 rows. We need to use
JDBC to query the table for 500 records and subsequently firing next 500 record for the same. We are planning to use java Hashmap , where the key would be user name and the value would be the Value Object say UserInfoVO. The UserInfoVO will have all the user information. It would be like Map<
String, UserInfoVO>. Please suggest us the pseudo code for fetching 500 records and next 500 record until the entire table is cached in the HashMap.