Currently we use connector J to connect to Mysql with the java resultset.
1.) Lots of paging.
2.) Large number of rows returned.
3.) Used for online internet store returning a lot of results and many
4.) Many connections and different DB's on MySql server.
We currently use the resultset to get/iterate through results. I have done
some reading on cachedrowset and rowset's and not sure which is best and
Google'd it but haven't found a clear answer. I was told that cachedrowset
is the best way because it only stays connected to DB very briefly.
resin-interest mailing list