Pretty new at Hibernate and right now I have create a testdatabase. Want to list out a select query containing several columns. One column works fine but how do I program to list out the answer with several columns?

This is my query & how the answer gets into an iterator:

Query q = session.createQuery("SELECT co.countryCode, st.storeNo FROM net.sf.hibernate.Country co, net.sf.hibernate.Store st WHERE co.countryCode=st.countryCode AND co.countryCode='DK'");

List list = q.list();
System.out.println("Found " + list.size() + " matching search criteria");
Iterator listIter = list.iterator();


Best Reg. Johan

Hey,

I've added some more code. I haven't really figured out how to take care of the [b]"storeNo"[/b] and "countryCode" the the SELECT statement returns.

session = sessionFactory.openSession(); //open sessions

Query q = session.createQuery("SELECT st.storeNo, co.countryCode FROM net.sf.hibernate.Country co, net.sf.hibernate.Store st WHERE co.countryCode=st.countryCode AND co.countryCode='DK'");

List list = q.list();

Iterator listIter = list.iterator();

System.out.println("COUNTRY");
System.out.println("--------");

while(listIter.hasNext()) {
String temp = (String) listIter.next();
System.out.println("StoreNo: " + temp);
}

session.flush();
session.connection().commit();
session.close();


What's wrong with my code? I get this fault:

java.lang.ClassCastException: java.lang.Object
at net.sf.hibernate.Test3.joinCountryStore(Test3.java:83)
at net.sf.hibernate.Test3.menu(Test3.java:56)
at net.sf.hibernate.Test3.main(Test3.java:121)
Exception in thread "main"


Br. Johan

Johan,



as I rember the list that you got via the code above, should contains elements of Object[2] array type, try the following:


I don't remember, but if Object[] obj = (Object[]) i.next(); throws ClassCastException, try List obj = (List) i.next();

Use your debugger with watch i.next().getClass().getName();

Best regards,
Leonid

Hey Leonid,

Thx a lot for that. It solved my problem.

/Johan