Hello,


What I am trying to do is select 2 fields from a table that has 8 fields.

Using the createQuery this is easy
session.createQuery("Select lname,fname from Person");
I get back an object and then I can select last name and first name using the first and second array

This is great because it creates a query for me that only select the 2 fields from the database (saving some resources)

Object[] row = (Object[]) iter.next();
System.out.println("First Name: " + row[0]);
System.out.println("Last Name: " + row[1]);



How would I do the same thing using session.createCriteria(Person.class)
I just want to select the first name and the last name from person.




Thank you








Hibernate version:3

i think this should work.

Golly97;

Define all but the two properties of the Person class as lazy="true". Something like this:



The your criteria query would look like this:




//Nicholas

thank you hubkabel
this works


NickMan,
this works, but the query fetched all the rows from the database, before i only displayed first and last name.