The sqlce database was created using SchemaUpdate or SchemaExport or did you
work with an already created DB? maybe the limit is in the column
definition.

If you are creating the schema using one of those i will recommend removing
the hint every string greater than 4000 is supposed to be understand as
ntext definition for MsSqlCe dialect

Gustavo.

On Mon, Dec 29, 2008 at 10:35 PM, jeff.jarrell <[email protected]>wrote:

>
> I have been working with a mapping where I am storing an xml fragment
> in an NText field.  The xml is about 28k bytes.  If I am working in
> MsSql it works fine.
>
> When I change the dialect to go against MsSql Ce I get an
> InvalidOperationException.  When I look at the stack trace i get
> System.InvalidOperationException : @p1 : String truncation: max=4000,
> len=20595, value='<FlexP...
>
> Where is the max = 4000 coming from?  I am using the SchemaExport tool
> to drive table creation from the mapping.
>
> Here is the mapping...
> <?xml version="1.0" encoding="utf-8" ?>
> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
>  <class
> name="Crestron.Tools.DeviceLibrary.PanelDesign.DisplayElement,
> Crestron.Tools.PanelDesigner.UnitTests" table="PanelDesign">
>    <id name="Id" column="Id"  type="String" unsaved-value="" length
> ="16"
>      access="field.camelcase-underscore">
>      <generator class="Crestron.Tools.Core.Data.IdGenerator,
> Crestron.Tools.Core"/>
>    </id>
>
>    <!-- String on the DBSide, Enum in class, note use of EnumMapper --
> >
>    <property name="DisplayElementType" length="20"
>
>
> type="Crestron.Tools.DeviceLibrary.PanelDesign.DisplayElementTypeEnumMapper,
> Crestron.Tools.PanelDesigner.UnitTests"
>              />
>
>    <property name="PropertyXml" type="String" length="30000">
>      <column name="PropertyXml" sql-type="ntext"/>
>    </property>
>
>    <property name="DeviceId" type="String"/>
>
>  </class>
> </hibernate-mapping>
>
> Thanks,
> jeff
> >
>

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