Hi, I'm using hibernate 3.0 in a project and need to call some native sql query..

I use createSQLQuery(queryString) and in hibenrate version 3.0 I'm forced to use addScalar(String, Type) with SQLQuery.. But i query each time a different table and some tables have a string id and other have a long id. Since I don't know the id's type, I cannot use provided addScalar method.

Is there any common way to get general object type?

..i get
java.lang.UnsupportedOperationException: object is a multicolumn type
when trying to set Hibernate.OBJECT in setScalar

thx, libor

hi again,
i have just found that i can set Hibernate.STRING as a result type even if the appropriate column is of numeric type.
it's not the best solution but for now, i can't see any better and would appreciate any help :)