Need An Advise

I am making a small application where there four batch jobs

which kicks off a particular java class .

Every time this java class is exectuning a select statement on the DB which has say about thousands records, of that 100 records i will pick up and will make a VO of all the records.

so that may happen four times in a day, since i have four batch jobs........

for this do i need to go for connection pooling?..........

please advise

[471 byte] By [java_jamboreea] at [2007-11-27 4:33:45]
# 1
Well if you are only using 1 connection there is not much point really.
YoGeea at 2007-7-12 9:43:37 > top of Java-index,Java Essentials,Java Programming...
# 2
On the other hand, if you are using a persistence framework like Hibernate, switching pooling off and on is trivial: it's part of your config file, so you can change it without editing code or recompiling. I mention this because mightyoak trees from small acorns grow.
Hippolytea at 2007-7-12 9:43:37 > top of Java-index,Java Essentials,Java Programming...