(in the DB) On Sat, Mar 7, 2009 at 5:35 PM, James Gregory <[email protected]>wrote:
> What is the type of your column? > > > On Sat, Mar 7, 2009 at 3:26 PM, dacanetdev <[email protected]>wrote: > >> >> No I don't have a NULL I have only 1 record with this value 07/03/2009 >> 07:56:51 a.m. >> >> I read that the problem is that NHibernate can't get miliseconds >> therefore it can't cast to DateTime. As I said I tried with Timestamp >> with same result. >> >> Thanks, >> >> On Mar 7, 9:20 am, Ken Egozi <[email protected]> wrote: >> > is it possible that you have a null value in the DB? (so it can't get >> casted >> > to dateTime?) >> > if so - either fix the DB (add NOT NULL constraint and fix the data) or >> use >> > a nullable datetime for the property >> > >> > On Sat, Mar 7, 2009 at 5:07 PM, dacanetdev <[email protected] >> >wrote: >> > >> > >> > >> > >> > >> > > I'm getting this error, could you please help me with this? >> > >> > > The problem is with the property FechaCreacion that it's a DateTime. I >> > > tried with Timestamp and also as string, still getting the error. >> > >> > > Thanks for your help >> > >> > > This is the error >> > >> > > NHibernate.PropertyAccessException: Invalid Cast (check your mapping >> > > for property type mismatches); setter of >> > > JCES.ControlObra.Entities.Obra ---> System.InvalidCastException: >> > > Specified cast is not valid. >> > > at (Object , Object[] , SetterCallback ) >> > > at NHibernate.Bytecode.Lightweight.AccessOptimizer.SetPropertyValues >> > > (Object target, Object[] values) >> > > at >> > > >> NHibernate.Tuple.Entity.PocoEntityTuplizer.SetPropertyValuesWithOptimizer >> > > (Object entity, Object[] values) >> > >> > > This is de Mapping file >> > >> > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" >> > > assembly="JCES.ControlObra.Entities" >> > > namespace="JCES.ControlObra.Entities"> >> > > <class >> > > name="JCES.ControlObra.Entities.Obra,JCES.ControlObra.Entities" >> > > table="Obra"> >> > > <id name="ObraId" column="ObraId" type="Int32" >> > > unsaved-value="0"> >> > > <generator class="native" /> >> > > </id> >> > > <property name="NumObra" column="NumObra" type="string" >> > > length="50" >> > > not-null="true" unique="true" /> >> > > <property name="NombreObra" column="NombreObra" >> > > type="string" >> > > length="400" not-null="true" /> >> > > <property name="FechaCreacion" column="FechaCreacion" >> > > type="DateTime" not-null="true" /> >> > > <property name="CostoEstatal" column="CostoEstatal" >> > > type="Decimal" >> > > not-null="false" /> >> > > <property name="CostoFederal" column="CostoFederal" >> > > type="Decimal" >> > > not-null="false" /> >> > > <property name="CostoOtros" column="CostoOtros" >> > > type="Decimal" not- >> > > null="false" /> >> > >> > > <many-to-one name="Municipio" class="Municipio" >> > > column="MunicipioId" /> >> > > <many-to-one name="Localidad" class="Localidad" >> > > column="LocalidadId" /> >> > > <many-to-one name="TipoObra" class="TipoObra" >> > > column="TipoObraId" / >> > >> > > </class> >> > > </hibernate-mapping> >> > >> > > This is the class >> > >> > > public class Obra >> > > { >> > >> > > private int obraId; >> > > private string numObra; >> > > private string nombreObra; >> > > private TipoObra tipoObra; >> > > private DateTime fechaCreacion; >> > > private Localidad localidad; >> > > private Municipio municipio; >> > > private double costoEstatal; >> > > private double costoFederal; >> > > private double costoOtros; >> > >> > > public Obra() >> > > { >> > >> > > } >> > >> > > public virtual int ObraId >> > > { >> > > get >> > > { >> > > return obraId; >> > > } >> > > set >> > > { >> > > obraId = value; >> > > } >> > > } >> > >> > > public virtual string NumObra >> > > { >> > > get >> > > { >> > > return numObra; >> > > } >> > > set >> > > { >> > > numObra = value; >> > > } >> > > } >> > >> > > public virtual string NombreObra >> > > { >> > > get >> > > { >> > > return nombreObra; >> > > } >> > > set >> > > { >> > > nombreObra = value; >> > > } >> > > } >> > >> > > public virtual TipoObra TipoObra >> > > { >> > > get >> > > { >> > > return tipoObra; >> > > } >> > > set >> > > { >> > > tipoObra = value; >> > > } >> > > } >> > >> > > public virtual Municipio Municipio >> > > { >> > > get >> > > { >> > > return municipio; >> > > } >> > > set >> > > { >> > > municipio = value; >> > > } >> > > } >> > >> > > public virtual Localidad Localidad >> > > { >> > > get >> > > { >> > > return localidad; >> > > } >> > > set >> > > { >> > > localidad = value; >> > > } >> > > } >> > >> > > public virtual DateTime FechaCreacion >> > > { >> > > get >> > > { >> > > return fechaCreacion; >> > > } >> > > set >> > > { >> > > fechaCreacion = value; >> > > } >> > > } >> > >> > > public virtual double CostoEstatal >> > > { >> > > get >> > > { >> > > return costoEstatal; >> > > } >> > > set >> > > { >> > > costoEstatal = value; >> > > } >> > > } >> > >> > > public virtual double CostoFederal >> > > { >> > > get >> > > { >> > > return costoFederal; >> > > } >> > > set >> > > { >> > > costoFederal = value; >> > > } >> > > } >> > >> > > public virtual double CostoOtros >> > > { >> > > get >> > > { >> > > return costoOtros; >> > > } >> > > set >> > > { >> > > costoOtros = value; >> > > } >> > > } >> > >> > > }//end Obra >> > >> > -- >> > Ken Egozi. >> http://www.kenegozi.com/bloghttp://www.delver.comhttp://www.musicglue.comhttp://www.castleproject.orghttp://www.gotfriends.co.il >> >> > > > > -- Ken Egozi. http://www.kenegozi.com/blog http://www.delver.com http://www.musicglue.com http://www.castleproject.org http://www.gotfriends.co.il --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
