CustomType("TimeAsTimeSpan") should work fine; are you sure this error is
being caused by your mappings and not some other issue?
You can export the mappings FNH produces, that might help highlight any
issues. Either WriteMappingsTo on the PersistenceModel or ExportTo on the
FluentMappings call in Fluently.Configure.
As an aside, Access.Property() is unneeded as that's the default behaviour.
On Mon, Aug 17, 2009 at 10:20 AM, skinnydan72 <danielsolo...@gmail.com>wrote:
>
> Hi
>
> Basically I am making use of the new SQLServer time(7) type to store
> time spans. (NOTE I know I can stick with the hbm for this one class
> map but just thought I'd check if I'm missing something...)
>
> In hbm I have this, which works well when I insert a new factor with
> the use of the new NHIbernate type="TimeAsTimeSpan"
>
> <?xml version="1.0" encoding="utf-8" ?>
> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" auto-
> import="true" namespace="MyApp.Model" assembly="MyApp.Model">
> <class table="race_videos" name="RaceVideo" lazy="false">
> <id name="Id" access="property" column="id">
> <generator class="native"/>
> </id>
> <property name="FileName" access="property"
> column="filename" />
> <property name="Source" access="property" column="source" />
> <property name="GateOpenTime" access="property"
> column="gate_open_time" type="TimeAsTimeSpan"/>
> <property name="WinnerFinishTime" access="property"
> column="winner_finish_time" type="TimeAsTimeSpan" />
> </class>
> </hibernate-mapping>
>
> where-as I can't seem to specify the type attribute in Fluent. Custom
> type isn't it as this TimeAsTimeSpan isn't an IUserType implementor.
> Any ideas? SetAttribute would have been handy now I guess...
>
> public class RaceVideoFluentMap : ClassMap<RaceVideo>
> {
> public RaceVideoFluentMap()
> {
> Table("race_videos");
> Not.LazyLoad();
> Id(x => x.Id)
> .Column("id")
> .GeneratedBy.Native();
> Map(x => x.FileName)
> .Column("filename")
> .Access.Property();
> Map(x => x.Source)
> .Column("source")
> .Access.Property();
> Map(x => x.GateOpenTime)
> .Column("gate_open_time")
> .CustomType("TimeAsTimeSpanType")
> .Access.Property();
> Map(x => x.WinnerFinishTime)
> .Column("winner_finish_time")
> .CustomType("TimeAsTimeSpan")
> .Access.Property();
> }
> }
>
> with error below where you can see NHibernate is generating an insert
> with a string the is a datetime rather than time...
>
> INSERT INTO race_horse_factors (FactorName, time_in, time_out, weight,
> other_excuse, user_id, race_horse_id) VALUES (@p0, @p1, @p2, @p3, @p4,
> @p5, @p6); select SCOPE_IDENTITY();@p0 = 'UnderPressure', @p1 =
> 1/1/1753 12:00:00 AM, @p2 = 1/1/1753 12:00:03 AM, @p3 = 0, @p4 =
> 'UnderPressure', @p5 = 1, @p6 = 1
> NHibernate: INSERT INTO race_horse_factors (FactorName, time_in,
> time_out, weight, other_excuse, user_id, race_horse_id) VALUES (@p0,
> @p1, @p2, @p3, @p4, @p5, @p6); select SCOPE_IDENTITY();@p0 =
> 'UnderPressure', @p1 = 1/1/1753 12:00:00 AM, @p2 = 1/1/1753 12:00:03
> AM, @p3 = 0, @p4 = 'UnderPressure', @p5 = 1, @p6 = 1
> 2009-08-17 19:11:29,464 [Agent: adapter run thread for test
> 'CanAddFactor' with id 'da90bc10-c88e-4f0c-b7a1-6ba34f98f51b'] DEBUG
> NHibernate.Transaction.AdoTransaction - Enlist Command
> 2009-08-17 19:11:29,663 [Agent: adapter run thread for test
> 'CanAddFactor' with id 'da90bc10-c88e-4f0c-b7a1-6ba34f98f51b'] ERROR
> NHibernate.AdoNet.AbstractBatcher - Could not execute query: INSERT
> INTO race_horse_factors (FactorName, time_in, time_out, weight,
> other_excuse, user_id, race_horse_id) VALUES (@p0, @p1, @p2, @p3, @p4,
> @p5, @p6); select SCOPE_IDENTITY()
> System.Data.SqlClient.SqlException: String or binary data would be
> truncated.
> The statement has been terminated.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To post to this group, send email to fluent-nhibernate@googlegroups.com
To unsubscribe from this group, send email to
fluent-nhibernate+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/fluent-nhibernate?hl=en
-~----------~----~----~----~------~----~------~--~---
