hi,

by these select I have selected a list of net.sf.hibernate.type.Type object:

List typeList = session.find("SELECT B.id, B.name " +
"FROM Brand B, RelBrand RB WHERE RB.study = ?" +
"AND B.id = RB.brand.id", new Object[] { idStudy },
new Type[] { Hibernate.LONG, Hibernate.STRING });


How can I get java.lang.Long and java.lang.String from net.sf.hibernate.type.Type[] array, without mapping to object ??

Note that the role of the type array is not to specify the types of the params you receive in return, but the ones you are setting as parameters in the query!!


So if you are casting the result to Type[] objects it will probably give you a classcastexception. I don't remember what type you should be receiving as list elements, though, maybe Object[]?

you will receive an Object[] containing java.lang.Longs and java.lang.Strings

besides that, i think your query won't run like this. you are missing a space at the end of the second line behind "study = ?" ;-)

Actually while i'm looking at it, it won't run like this at all. Hibernate determines return types using the mapping files. you don't need to spacefiy them, in fact you can't.

And what about this RelBrand? Is it an attribute of Brand? Since i don't know for sure how they are related i just left this bit, but besides that your query should actually look like this:

List typeList = session.find(
"SELECT B.id, B.name FROM Brand B, RelBrand RB "
+ "WHERE RB.study = ? "
+ "AND B.id = RB.brand.id",
idStudy,
Hibernate.LONG);

(assuming that idStudy is a Long)

Only if you have several parameters you need the Object[] and Type[].

As the result of that query you will receive a List with Object[]s each containing an id and a name.

Maybe you might wanna do it like this instead:

List typeList = session.find(
"SELECT B FROM Brand B, RelBrand RB "
+ "WHERE RB.study = ? "
+ "AND B.id = RB.brand.id",
idStudy,
Hibernate.LONG);

which will return a List with the Brand objects you are looking for. This is more object oriented and how we usually do it.