Is there a way to sent raw sql in Hibernate 2.0.3? I have read about createSQLQuery around the forum but did not find any similarly clean way to do this in 2.0.3.

BTW, upgrade to 2.1 will not work for me :)..

Thanks...

You can only use session.connection().... in Hibernate 2.0.x.

Get the underlying SQL connection

And execute SQL code.
caution No object mapping is done this way.

Thanks christian. Guess will have to go that route? But here is another question, I am trying to send a query to the database (MSSQL Server) and I want to add a string to my query. Say I have the following query:

Select * from myTable where name like '%na%'

I want to send this down to the database as the following:

Select * from myTable where name like N'%na%'

This is required as I want to send UTF characters/strings to the database. I tried adding it to the query I use in session.find but that is not really doing it for me. I keep getting that the syntax is incorrect. What ways are available to me to customize the sql that is being passed to the database (especially my where clause).

When I send my query, for example,
Select count(*) from myClass as m where m.name like N'%na%'

It hits the database as the following:
Select count(*) from myTable as m where m.name like N '%na%'

It creates a space between N and '%na%'. Is this normal? This is causing the query to not execute due to syntax problems??

Are you sure your driver isn't doing this for you? I'm using jTDS and it appears to take care of that for me automatically. Not sure if other drivers do it. You can use SQL Server Profiler to check.

Joe

HIbernate does not support a N'foo' style string literal. So just use a query parameter instead of a literal and let the JDBC driver take care of it.