Hi .
			

			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
			connection pool
			please suggest the best way .. The records may vary from some 500 - 40,000 records ...