I am not a NH expert but I would suggest to install NHProf or configure Log4Net in you app to see what SQL statments NH issues from client side.
NHProf is really a amazing tool on through which u can visualize what NH does behind the scenes. On Thu, Mar 3, 2011 at 8:22 PM, Daniel Smith <[email protected]>wrote: > The mapping file is set up as follows: > (Apologies for bad formatting) > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > assembly="PaymentService.Core" > namespace="PaymentService.Core.Domain"> > <class name="RegisteredKiosk"> > <id name="Id" column="idRegisteredKiosk"> > <generator class="guid.comb" /> > </id> > <property name="SerialNumber" > type="System.String" > not-null="true" /> > <property name="KioskName" > type="System.String" > not-null="true" /> > <bag name="Transactions" lazy="true" cascade="all-delete-orphan"> > <key column="idTransaction" /> > <one-to-many class="KioskTransaction" /> > </bag> > </class> > </hibernate-mapping> > > I am trying to select a "registeredkiosk" by its ID > (idRegisteredKiosk) which is a GUID. > However, although NHibernate has successfully inserted the > information, in this case the ID: 31E06EE26FB7994392DB9E9B00E13718, if > I try and select this Guid from the table, using NHibernate, 0 rows > are returned. I can manually execute my own query against the table > and see the row is there. My query is the following: SELECT * FROM > RegisteredKiosk WHERE idRegisteredKiosk = > UNHEX('31E06EE26FB7994392DB9E9B00E13718'); > > I am using NHibernate 3.0.0 on a MySQL Database (using the InnoDB > Engine) I have added "Old Guids=true" to the MySQL connection string > in order to get it to insert (otherwise it would error saying that the > field wasn't long enough) > > Any light you could shed on this issue would be appreciated > > Dan > > -- > 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. > > -- 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.
