AppletTalk.com

Stefan Siegl · Guest

Hello group,

We discussed in a database lecture about SQLJ and saw the iterator
design which can be used if a query returns more than just one record. I
am wondering about the design of this iterator. I mean using the syntax
of SQLJ I define a name and this name can afterwards be used as a class.
So if I say:

#sql iterator MyIterator [...]

I can use the newly created class "MyIterator" afterwards. Isn't it a
bit of slow and difficult to create a class, that the programmer can
give a name? I mean wouldn't it be better to offer a class called
"ResultSet" which contains a List of Record objects which will store the
values (as it is done in JDBC).

Does anyone know why they choose this design? I mean it would be much
more straight forward to use the ResultSet as I have described it. Are
there any benefits in performance?

Thanks in advance,
Stefan