I've debugged nhibernate, and in the function GetNamedQuery, the IQuery object that is returned contains a ReturnTypes property which throws an exception :
query must begin with SELECT or FROM: exec [exec sp_NH_GetCuttings] Whatever that means.... Can someone help ? On 25 mar, 09:46, graphicsxp <[email protected]> wrote: > Hi, > > I get an exception while calling a named query : > > <sql-query name="sp_NH_GetCuttings"> > <return class="DataTransfer.Cutting, DataTransfer" > > <return-property name="Cuttingid" column="CuttingID" /> > <return-property name="Headline" column="Headline" /> > </return> > exec sp_NH_GetCuttings > </sql-query> > > public IList<Cutting> getCuttings() > { > return _session.GetNamedQuery("sp_NH_GetCuttings").List<Cutting> > (); > } > > The exception inner message is not helpful : > > could not execute query > [ exec sp_NH_GetCuttings ] > [SQL: exec sp_NH_GetCuttings] > > and if I go deeper : > > column2_0_0_ > > The second one is even more useless... > > Here's the stored procedure : > > CREATE PROCEDURE sp_NH_GetCuttings > > AS > BEGIN > SELECT TOP 3 CuttingID, Headline FROM cutting > END --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
