• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SortedRowSet & FilteredRowSet

 
Feyna Reendrina
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
guys, i need your help....

i want to display my database with filter and sorter....
to filter i have been using filteredrowset
but to sort it, i don't know what class that i can use....

i try to find at internet.. and i found sortedrowset (weblogic.jdbc.rowset.SortedRowSet)....

but i can't get import of it...
i try using :


but it is ended by error...

is i must install the package??
but i can't get any packages download...

Can you help me??

Thx..
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35269
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Feyna,
Traditionally, people sort in the actual SQL statement. If you want to use a WebLogic specific library, then you need to have WebLogic's jar for it in your classpath for the import to work.
 
Feyna Reendrina
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i need to make it fast...
is select using SQL faster than sorted rowset??
how about if database that used is in server??

any one know where i can get WebLogic's jar???

thx..
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35269
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Feyna Reendrina:
i need to make it fast...
is select using SQL faster than sorted rowset??
how about if database that used is in server??

On the initial query, it is faster to sort in SQL. If the user sorts the existing result again (while it is in memory), it is faster to sort in the rowset. However, the rowset uses up a lot of memory. So if you don't have enough free memory, it will page to disk. Making things slower again.

If the database is on the same server as the app server, the difference in time is even smaller.


any one know where i can get WebLogic's jar???
thx..

Presumably it is in the WebLogic app server.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic