Hi - help

Anyone knows if it possile to select column list using Criteria? And if it is please give me an example

Hi

Try this out !!!
If the values in the column are static then u can do it this way or Load the values from the DataBase and put it in a a List and do it

ArrayList countryList = new ArrayList();
countryList.add("Switzerland");
countryList.add("Germany");
countryList.add("France");
Criteria critetria= session.createCriteria(Adress.class);
critetria.add(Expression.in("Country",countryList));
List <Adress>list = critetria.list();
for (Adress adress : list) {
// iterate through
}