I am trying to use a SqlQuery which makes use of MySql user variables.
http://dev.mysql.com/doc/refman/5.0/en/ ... ables.html

The syntax is @myVar:=something.
However Hibernate uses :varName as its syntax for parameters. So when I try to run my query it complains that := is an invalid



Is there a simple way to escape this? I have tried \\:= without success.

Thanks,
Martin.

I have still not had any success finding any details about this. I have tried a number of sequences that I have found in examples such as a / or enclosing it in {} but neither works. Surely it must be possible to use a : in a statement?

Also when I use addJoin() the result of .list() becomes an array, with one element per those selected. Why is this? They are already correctly nested inside the base entity so why include them at the top level also?

Hi!

I am running into a very simlar problem when using sql-server 2008:



when doing so, hibernate will treat ":STGeomFromText" as variable replacing it with "?"

the resulting SQL will be:
insert into polygontest (id, name, geom) values
(2, 'TEST', GEOMETRY?('POLYGON((40.0 5.0, 60.0 55.0, 50.0 20.0, 40.0 5.0))', 0));

as a workaround I am using the following deprecated method:


is there a possibility to avoid the replacement?
any escape sequence?

thank you

Peter

So, is there anyway we can use the geometry::<anyfunction> in an hibernate query without having problems with the parameters replacement?!?! I've tried creating a synonym function like this:



But then indexes does not seem to be used or something else is going bad since queries take 15x more time to be executed...

I really need to find some kind of workaround... Anyone has any ideas, like a way to modify the parser itself or any other idea?!?!

Thank you!