Re: MSSql error - String or binary data will be truncated

Fri, 16 Jul 2004 02:23:02 -0700

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]

Reply via email to