December 1999
Intermediate to advanced
816 pages
20h 27m
English
There are some other points not specific to a particular technique that you should know and incorporate into your programs. These include limiting ResultSet size and doing your own transaction management.
I said earlier that JDBC 2.0 allows you to get the number of rows in a ResultSet. You should use this information to limit the amount of data you send to a client. Let's say that your middle-tier database access code (tier two is where this code belongs) makes a call and returns 10,000 rows. Realistically (even if your user's system can hold that much data, and you don't mind the download time required to copy it to the client system), the user is not going to read 10,000 rows worth of ...
Read now
Unlock full access