[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slide-user
Subject:    Re: Download of files that are larger than 65535 Bytes (63,9K)
From:       Oleg Rostanin <rostanin () dfki ! uni-kl ! de>
Date:       2004-04-28 7:45:38
Message-ID: 408F6122.6030100 () dfki ! uni-kl ! de
[Download RAW message or body]

Hey!, super,
it works really!

Thanx a lot.

Oleg

Ryan Rhodes wrote:

> I was intending to put something detailed together on this. The 
> problem is with MySQL 4.0. It only allows BLOB's up to 64k. I have 
> searched everywhere on MySQL lists and could not confirm this, but you 
> will notice that you can't even upload a file greater than 64k using 
> phpmyadmin.
>
> I don't know if this is a phpmyadmin problem (I created the tables 
> with phpmyadmin in the first place), a mysql driver problem, or just a 
> problem with 4.0 that has been fixed in 4.x > 0. I can't imagine 64k 
> is the correct max for blobs for such a popular database.
>
> The solution I used was to change the type of the CONTENT column in 
> the VERSION_CONTENT table from BLOB to LONGBLOB. I can no longer 
> browse this table with phpmyadmin (bug???), but I have tested 
> upload/download with 100 Meg files.
>
> Apparently, changing the type to LONGBLOB will break PROPPATCH 
> requests. Stuart MacPherson posted a patch for this sometime back. I 
> have not tested for the problem or applied the patch. I don't think 
> the patch or the change to the table structure ever got into the Slide 
> codebase.
>
> --hope this helps
>
> Ryan Rhodes
>
>
>
>> From: Oleg Rostanin <rostanin@dfki.uni-kl.de>
>> Reply-To: "Slide Users Mailing List" <slide-user@jakarta.apache.org>
>> To: Slide Users Mailing List <slide-user@jakarta.apache.org>
>> Subject: Re: Download of files that are larger than 65535 Bytes (63,9K)
>> Date: Tue, 27 Apr 2004 17:07:42 +0200
>>
>> Yes, it is correct
>>
>>
>> Ryan Rhodes wrote:
>>
>>> It sounds like you are using MySQL as your content store. Is that 
>>> correct?
>>>
>>>
>>>> From: Oleg Rostanin <rostanin@dfki.uni-kl.de>
>>>> Reply-To: "Slide Users Mailing List" <slide-user@jakarta.apache.org>
>>>> To: Slide Users Mailing List <slide-user@jakarta.apache.org>
>>>> Subject: Re: Download of files that are larger than 65535 Bytes 
>>>> (63,9K)
>>>> Date: Tue, 27 Apr 2004 16:46:08 +0200
>>>>
>>>> I have checked the Slide servlet with another client (DAVExplorer). 
>>>> It works correctly.
>>>> It means the reason must be hiding somwhere in webdav API
>>>>
>>>> Oleg Rostanin wrote:
>>>>
>>>>> Hello everyone,
>>>>>
>>>>> I'm writing a universal module for UP/Downloading files to/from 
>>>>> WebDAV repositories.
>>>>> I have encountered the strange problem that only files with the 
>>>>> size up to 65535 Bytes are uploaded/downloaded correctly.
>>>>>
>>>>> If a file is larger that only the first 65535 Bytes are uploaded 
>>>>> or downloaded.
>>>>>
>>>>> import org.apache.webdav.lib.*;
>>>>>
>>>>> public void downloadDocument(WebdavResource resource, File 
>>>>> localFile) throws Exception
>>>>> {
>>>>> if(!resource.isCollection())
>>>>> {
>>>>> resource.getMethod(localFile);
>>>>> }
>>>>> }
>>>>>
>>>>>
>>>>> can anybody help me?
>>>>>
>>>>>
>>>>> Best,
>>>>> Oleg Rostanin
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>>>>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>>>
>>>
>>> _________________________________________________________________
>>> Watch LIVE baseball games on your computer with MLB.TV, included 
>>> with MSN Premium! 
>>> http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/ 
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>
>
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar – get it now! 
> http://toolbar.msn.com/go/onm00200415ave/direct/01/
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]