Lets say you have the following table:

CREATE TABLE MYTABLE {
ID numeric (9, 0) IDENTITY NOT NULL,
FIELD1 varchar(50),
FIELD2 varchar(50),
FIELD3 varchar(50),
....
FIELD10 varchar(50),
}

And lets say you have two views of that data. One, is a table displaying all rows (or pages) of data, butonly displaying the ID, FIELD1 and FIELD2. The second view is a view of all the columns of an individual row.

Is this possible in Hibernate? Suggestions? Pointers in the right direction?

Thanks.

-bryce

If I understand you correctly:

The first senario would be a Object containing 3 fields, and a mapping to that table and three of the colums. You would access this by individual IDs.

The second senario is a similar Object (A devrived class maybe? Composite? Decorator?) containing all 11 fields, and a mapping to that table with all the collums. You would access this via the equlivent of a 'select *' statement to get a list of all rows in the table.

projection
one-to-one
lightweight pattern

PS: in most cases returning all the properties does not decrease performance.