is it possible to use a named Native SQL query?

I tried placing a native query into my mapping file and got this error. It doesn't understand LEFT OUTER JOIN syntax, and i can see from the exception that it's expecting HQL.

[/code]

How do you define the query? Do you put it in a <sql-query ..> tag?




Farzad-

almost,

<query name="portfolio.find.by.groupId"><![CDATA[
...

]]>
</query>


Let me try what you said...

Just one thing, a sql-query needs more configuration in terms of what it returns and parameters. Make sure you will put in those things.



Farzad-

are you thinking of <return> configuration?

in my code i used an aliasToBean transformer, like this:
query.setResultTransformer(Transformers.aliasToBean(PortfolioQueryResult.class));

is it equivalent to:
<return alias="result" class="PrortfolioQueryResult">

or should i continue setting the transformer the way i have been?

I don't really have the answer to this. In HB code they look a little different but it might do the trick in your case. In any events, you are only seconds away from switching from one to the other. It's good if you share your experience here.



Farzad-

Thank you Farzad, you got me on the right path. It does indeed work and since i'm using a transformer, i did not need <return> configuration. Here's the result:

my queries are now in NamedQueries.hbm.xml:


in my DAO: