Ray,
thank you for your tips, we will evaluate it.
Markus
-------- Original Message --------
Subject: Re: Ordering (21-Sep-2001 1:01)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
> I use a stateful session bean ot manage the sort, keeping track of the
> index
> of the current page and next page. With this technique myltiple cli\ents
> can do different sorts simultaniously. Yes your SQL is how i store the
> info
> into the tmp table.
>
> Hope that helps
> RayM
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, September 20, 2001 7:45 AM
> Subject: Re-2: Ordering
>
>
> > So you do the sort by having an SB driving an SQL query like this: "INSERT
> INTO MyTempTable SELECT MyData FROM MyRealTable ORDER BY WhatEverIWant"?
> >
> > -------- Original Message --------
> > Subject: Re: Ordering (20-Sep-2001 16:28)
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> >
> > > Markus,
> > >
> > > I am doing something like this and what i do is i sort the data on the
> > > server and put the result in another table. When the user asks for the
> > > next
> > > set of results, i get the data from the alternate table. Using this
> > > technique, i can add whatever fields to the temporary table i want to
> > > manage
> > > the sort.
> > >
> > > Thanks
> > > RayM
> > > ----- Original Message -----
> > > From: <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, September 20, 2001 5:35 AM
> > > Subject: Ordering
> > >
> > >
> > > > I just thought of how to implement sorting. We are programming a
> client
> > > software that talks to a session bean to get a value object that
> consists
> > > of
> > > a collection of instances of a known class. Now we want to let the user
> of
> > > the client software to sort that data. Since that data can be huge, we
> only
> > > retrieve five instances at each call. So the sort needs to run on the
> > > server, since only the server knows all keys. My question is: Does
> anybody
> > > know of how to manage this? I mean, I do not want to have a server
> method
> > > that calls the finder, loads all entities, and then to sort it (what
> would
> > > clearly work, but would be very slow). Also I do not want to use special
> > > finders since then I would need to have one finder for every column the
> > > user
> > > can sort (findByXSortByA, findByXSortByB, findByXSortByC...). Does
> anybody
> > > have an idea or know an API for that? Maybe next generation EJB specs
> have
> > > something?
> > > >
> > > > Thank you
> > > > Markus
> > > >
> > > > ----
> > > > To unsubscribe, send email to [EMAIL PROTECTED] and
> > > > include in the body of the message "unsubscribe jonas-users".
> > > > For general help, send email to [EMAIL PROTECTED] and
> > > > include in the body of the message "help".
> > > >
> > >
> > > ----
> > > To unsubscribe, send email to [EMAIL PROTECTED] and
> > > include in the body of the message "unsubscribe jonas-users".
> > > For general help, send email to [EMAIL PROTECTED] and
> > > include in the body of the message "help".
> > >
> > > To: [EMAIL PROTECTED]
> > > [EMAIL PROTECTED]
> >
>
>
> To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
