where :valueWhere is the condition?
The exception come from RDBMS.
2009/5/13 abragg <[email protected]>
>
>
>
> IN converting over a legacy application we need to convert named query
> to nhibernate. The problem is that the where clause is being set.
>
> here is the mapping
>
> <resultset name="PersonSet">
> <return alias="person" class="Person">
> <return-property column="id" name="Id" />
> <return-property column="ssn" name="Ssn" />
> <return-property column="last_name" name="LastName" />
> <return-property column="first_name" name="FirstName"/>
> <return-property column="middle_name" name="MiddleName" />
> </return>
> </returnset>
>
> <sql-query name="PersonQuery" resultset-ref="PersonSet" read-
> only="true" >
> <![CDATA[
> SELECT
> person.ID as {person.Id},
> person.SSN as {person.Ssn},
> person.LAST_NAME as {person.LastName},
> person.MIDDLE_NAME as {person.MiddleName},
> person.FIRST_NAME as {person.FirstName},
> FROM PERSONS as person
> where :value
> ]]>
> </sql-query>
>
> and the c# code: String query = "person.LAST_NAME = 'Johnson'";
> HibernateTemplate.FindByNamedQueryAndNamedParam("PersonQuery",
> "value", querry);
>
> the error: where ?]; ErrorCode []; An expression of non-boolean type
> specified in a context where a condition is expected, near '@p0'.
>
> >
>
--
Fabio Maulo
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
