However, I also tried the same file from a version of Slide that was just using a file store for everything and that worked fine in Webfolders and in Office, so I still think it has something to do with how my store is set up.
This is the part of my Domain.xml that configures my store:
<definition>
<store name="MySqlStore">
<nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</parameter>
<parameter name="driver">com.mysql.jdbc.Driver</parameter>
<parameter name="url">jdbc:mysql://localhost/slide</parameter>
<parameter name="user">luke</parameter>
<parameter name="dbcpPooling">false</parameter>
<parameter name="maxPooledConnections">10</parameter>
<parameter name="isolation">SERIALIZABLE</parameter>
<parameter name="compress">false</parameter>
</nodestore>
<contentstore classname="org.apache.slide.store.txfile.TxFileContentStore">
<parameter name="rootpath">store2/content</parameter>
<parameter name="workpath">work2/content</parameter>
</contentstore>
<securitystore>
<reference store="nodestore" />
</securitystore>
<lockstore>
<reference store="nodestore" />
</lockstore>
<revisiondescriptorsstore>
<reference store="nodestore" />
</revisiondescriptorsstore>
<revisiondescriptorstore>
<reference store="nodestore" />
</revisiondescriptorstore>
</store>
<scope match="/" store="MySqlStore"/>
</definition>
Cheers
Luke. -----
Hoi Chong wrote:
Hi, Have you tried with DAVExplorer or WebDrive (www.webdrive.com)?
It could be WebFolders & Office being buggy.
Cheers.
----- Original Message ----- From: "Luke Noel-Storr" <[EMAIL PROTECTED]>
To: "Slide Users Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, May 12, 2004 5:22 PM
Subject: Re: Strange problem with files over 64K and Webfolders/Office
replaceSorry, if you had read all my email you'd have seen that I tried this already, and that now I'm not even storing the file content in the MySQL database. Also, the files work fine when accessed via our client code or a browser (both of which I guess just do a simple http get), just not through web folders or Office (which I guess use the webdav get method).
Thanks anyway.
Cheers
Luke. ------
Jacob Lund wrote:
Hi Luke!
MySQL has as 64K limit in blob fields! Change the database scheme -
blob with longblob!
/jacob
----- Original Message ----- From: "Luke Noel-Storr" <[EMAIL PROTECTED]>
To: "Slide Users Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, May 12, 2004 11:12 AM
Subject: Strange problem with files over 64K and Webfolders/Office
Hi,
I have a slide repository set up in MySQL, but with the content stored in a file store (I set it up this way due to problems with large files and MySQL).
There now seems to be a problem with files over 64K, when we access them via our client code - they work fine, when downloaded from a URL, they work fine, when opened in Office, or copied from a webfolder, they cut off at 64K.
Anyone else had this problem? any ideas?
I had initial problems with files over 64K and MySQL in that only the first 64K was being stored in the blob, I then changed the blob fields to long blobs, this worked but caused out of memory exceptions for files over a few MB, so I then changed to storing the content in a file store outside of MySQL, however I'm now having problems with files over 64K in Office and Webfolder. Hair is being torn out and help would be greatly appreciated.
Cheers
Luke. -----
(ps, and many thanks to Ingo and others with my sessions problem; I have
now *greatly* reduced the number of sessions being spawned)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
