Sorting db data

[martygod]

Hi everybody,

Using JBoss since 6 months,
just wondering if someone has a good method to perform sorting of db data per column from servlets...

[danch1]

Well, in BMP, you can make the sort order be one of the finder parameters.
In CMP, you'll probably need one finder per possible sort, or use BMP style finders.

[martygod]

I use BMP and I have 2 parameters for my finders : the column and the sort order
I was wondering if there were a nicer solution because that's hard to manage (especially when the sort column is not part of the database table of the BMP but from another table...)