Build a table dynamically, if you know there will be
only one resultset (with SP's and multiple result
sets, this can get tricky, but not impossible).
Look at the ResultSetMetaData and from there you can
get the column headings and number of columns. Then
its easy to populate the table from there
logic:iterate should be fine. If the resultset is too
big, then you'll get some serious memory overflow
error anyway.
Consider limiting the ResultSet using the
Statement.setMaxRows(x).
Make it something like 5000 and if the actual returned
ResultSet is bigger, you can warn the user with
something
have a look at www.ibatis.com
The db-layer is a pretty good counterpart to struts and very well documented.
It's worth to look at (I'm not sponsered by ibatis)
cheers Reinhard
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For add
Thanks for that.
So what would be the best way of displaying such data on a JSP page?
Would logic iterate be ok for such large amounts of data?
-Original Message-
From: Mehta, Chirag (IT)
Sent: 07 August 2003 09:49
To: [EMAIL PROTECTED]
Subject: Returning a result set
Hello,
I am de
4 matches
Mail list logo