Title: RE: Applet-servlet doPost using ObjectStreams and MS Personal Webserver
you can use "rownum" in your query
 
 
 
 
zulfi
Keep Smiling. It does improve your face value. :-)
----- Original Message -----
Sent: Thursday, April 20, 2000 2:25 AM
Subject: Re: Applet-servlet doPost using ObjectStreams and MS Personal Web server

Which we did. When we query the database and receive the resultset, we
create an instance of the home made class TableContent, which contains an
array of object (Object[][]) which contains the rows and columns of the
resultset.

However, to create this table, we have to count the records in the result
set. In JDBC 1.0, there are no methods to count the records so we have to
perform the query twice. But we are now working a way to avoid this. But
that conversion is very long. Actually, just going through the resultset
takes a long time.

When transmitting data, we try to keep it to the TableContent instance, plus
a Hashtable containig additionnal info. All the keys in the hashtable are
strings as well as most of the values (sometimes a Boolean or an Integer).

This data is kept in an instance we call ParamData, which inherits from
ParamlessData (contains only a return code) which inherits from GenericData
(Abstract class).

In C++, using Abstract classes is very slow. In Java, is does not matter,
however, dos it matter for Serialization ?

Max.

> -----Original Message-----
> Subject: Re: Applet-servlet doPost using ObjectStreams and MS Personal
> Web server
>
>
> Some time ago on a similar project we on serialized vectors. 
>    it was much
> faster than trying to send recordsets back and forth.
>
> You can write a "recordset like" wrapper around the incoming
> vector if you
> need more traversing features than vectors accommodate
>
> regards,
> john d. haro
> AGENCY.COM

Reply via email to