Hi.

Im trying to execute a query (using org.hibernate.Query.createSQLQuery()) that contains the following snibbet:



Hibernate fails with:



Is there really no way at all to turn off this bloody parameter parsing?

cheers,
mg

To those that may come later:

Seems to me that the only solution to this problem is to wrap the whole SQL statement into a stored procedure and then call it.

cheers,
mg

Hi all,

Does any one know how to deal with this? The code below run successfully in MySQL but throwing exception in hibernate.org.hibernate.
QueryException: Space is not allowed after parameter prefix ':‘. I understand that := conflicts with the parameter settings.
Nevertheless, I can't simply create procedure/function since the query where clause is provided by the user.

This works in MySQL:
select row,der.plotno from(SELECT @row := @row + 1 as row, t.*FROM entry t, (SELECT @row := 0) r where plotno < 00009) as der where der.plotno = "00001"

Please advise.

Thanks,
Lanz