Hi

Right now I am doing the following in Hql:

String hqlquery ="select ms from ms in class com... where id<? and val=? ";
Object[] param = ...;
Type[] paramTypes = new Type[param.length];

for (int i = 0; i < paramTypes.length; i++) {
paramTypes[i] = Hibernate.STRING;
}

result = sess.find(hqlquery, param, paramTypes);

I need to pass that to sql, so createSQLQuery is my way. But I cannot see how I can use createSQLQuery with ? instead of named parameter, I could not find any example.

Is it possible?

tia

yes it is posssible - and look in the unit tests.

But why use ? parameters when you can get use (the IMHO better) named parameters?

thanks, I will look there?

The reason to use ? instead of named parameters is that I have a leghtly piece of code that creates an hql query based on the user selected stuff on the gui. It works, I will touch it as little as possible...