Hello guys...
I have a PK (character (10)), that is mapped like that:

<id name="ID" type="String">
      <generator class="assigned"/>
</id>

The load works fine with npgsql 1.0, the sql generated with loadbyid
is :
SELECT city0_."IDCity" as IDMu1_92_0_ FROM "tblCity" city0_ WHERE
city0_."IDCity"=E'BR420240'

Using npgsql 2.0. the sql generated is :
SELECT city0_."IDCity" as IDMu1_92_0_ FROM "tblCity" city0_ WHERE
city0_."IDCity"='BR420240'::text

So, I got ObjectNotFoundException, because that SQL returns 0
results...

Npgsql developer told-me to specify the exact type to the PK, in that
case : character(10)...

How can I do that using NH? I tried use sql-type, but I think it only
exist in Hibernate...

Thanks
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to