Tuesday, March 13, 2001 06:12 PM
I have been using the connection pooling provided by weblogic application server ..
In my program i want have to extensively query the database for all the processes .
I have done in two ways ..
1. To store all the data in hashtable
and process it as i needed it ..
2. I open the connection when i needed the result and i close it as soon as i finish the processing ..
keeping in mind i use the
please suggest the best way .. The records may vary from some 500 - 40,000 records ...