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