You should use ntext instead. ntext is a variable length data type. /jacob
----- Original Message ----- From: "Michael Gluckman" <[EMAIL PROTECTED]> To: "Slide Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, July 16, 2004 11:51 AM Subject: RE: MSSql error - String or binary data will be truncated > Yes you can use nvarchar(4000) which roughly equates to 60 versions before > truncating. Is this a DAV requirement > to store the entire "version-set" property value as one large String? > > Regards > Michael > > > > -----Original Message----- > From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] > Sent: 16 July 2004 11:23 > To: Slide Users Mailing List > Subject: Re: MSSql error - String or binary data will be truncated > > > This is a problem that showed up in all ports of the database store. The > problem is that properties can only store up to 255 characters and the > history of versiones is stored in a property. Then when it gets too long > it is truncated. > > The solution is to change the schema to either a longer value or to use > another datatype that is unlimited in size which would be more > appropriate! Do you know such a datatype for MS SQL Server? If so I will > change the schema ASAP. > > Oliver > > Michael Gluckman wrote: > > > Hi > > I have a file under version control /slide/files/a/test.txt > > Everytime the file reaches revision 1.4 and I try to add another revision > it > > gives me the following error: > > > > I am using slide 2.0 and SQLServer 2000 > > > > ERROR FROM DAVEXPLORER: > > org.apache.slide.common.ServiceAccessException: Service > > org.apache.slide.store.i > > [EMAIL PROTECTED] access error : [Microsoft][SQLServer 2000 > Driver > > for > > JDBC][SQLServer]String or binary data would be truncated. > > at > > org.apache.slide.store.impl.rdbms.SQLServerRDBMSAdapter.createExcepti > > on(SQLServerRDBMSAdapter.java:64) > > at > > org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevision > > Descriptor(StandardRDBMSAdapter.java:657) > > at > > org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionD > > escriptor(StandardRDBMSAdapter.java:1251) > > at > > org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionDes > > criptor(AbstractRDBMSStore.java:760) > > at > > org.apache.slide.store.AbstractStore.storeRevisionDescriptor(Abstract > > Store.java:1096) > > at > > org.apache.slide.store.ExtendedStore.storeRevisionDescriptor(Extended > > Store.java:794) > > at > org.apache.slide.content.ContentImpl.store(ContentImpl.java:1013) > > at > > org.apache.slide.webdav.util.VersioningHelper.checkin(VersioningHelpe > > r.java:1291) > > at > > org.apache.slide.webdav.util.VersioningHelper.checkin(VersioningHelpe > > r.java:1088) > > at > > org.apache.slide.webdav.method.CheckinMethod.executeRequest(CheckinMe > > thod.java:136) > > at > > org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebda > > vMethod.java:343) > > at > > org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:165) > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > > icationFilterChain.java:284) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > > ilterChain.java:204) > > at > > org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:139) > > > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > > icationFilterChain.java:233) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > > ilterChain.java:204) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV > > alve.java:257) > > at > > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > > eContext.java:151) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav > > a:567) > > at > > org.apache.catalina.core.StandardContextValve.invokeInternal(Standard > > ContextValve.java:245) > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextV > > alve.java:199) > > at > > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > > eContext.java:151) > > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica > > torBase.java:587) > > at > > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > > eContext.java:149) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav > > a:567) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j > > ava:184) > > at > > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > > eContext.java:151) > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j > > ava:164) > > at > > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > > eContext.java:149) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav > > a:567) > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal > > ve.java:156) > > at > > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > > eContext.java:151) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav > > a:567) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) > > > > at > > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:20 > > 6) > > at > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java > > :833) > > at > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce > > ssConnection(Http11Protocol.java:732) > > at > > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java > > :619) > > at > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP > > ool.java:688) > > at java.lang.Thread.run(Thread.java:534) > > > > > > Thanks > > Michael > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
