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]
