Is this happening only to me? What can be possibly wrong? Any idea?
On Thursday, July 12, 2012 8:59:11 AM UTC-3, abx78 wrote:
>
> I am experiencing a strange issue.
> I have a stored procedure that returns an xml record from a SQL Server DB.
> It's something like this:
>
> SELECT id, name, email
>> FROM employees
>> FOR XML PATH
>
>
> I fetch the result in this way:
>
> var constructor = typeof(XmlMapper).GetConstructor(new[] { typeof(string) });
>
> var query = session.GetNamedQuery("GetEmployees")
>
> .SetResultTransformer(Transformers.AliasToBeanConstructor(constructor))
> .UniqueResult<XmlMapper>();
>
>
> But when I run the test I get an error, because the result is not unique.
> I checked what's going on: the single xml field returning is split in
> chunks of 2033 chars.
> Here the hbm code:
>
> <!-- Employees --> <sql-query name="GetEmployeesXml"> EXEC
> proc_get_employees </sql-query>
>
>
> Any idea? Thanks
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/BOWfBVH1nesJ.
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.
