[Patch] File support for MySql

[Ludovic Maitre <lu...@free.fr>]

Hi all,

The class File must be patched to be usable with MySql, which doesn't 
use the broker.blobHack method.
Also one function must be changed in conf/db.properties:
mysql.core.file.prep.blob={call sp_tmc_prep_file_content(?,EMPTYBLOB)}
must be changed to:
mysql.core.file.prep.blob={call sp_tmc_prep_file_content(?,?)}
Sorry to not being able to put a patch for this last.
Best regards,

-- 
Cordialement,
Ludo - http://www.ubik-products.com
---
"L'amour pour principe et l'ordre pour base; le progres pour but" (A.Comte) 

Re: [Patch] File support for MySql

[Steve Toback <to...@apache.org>]

Hi Ludovic

On 9/27/06, Ludovic Maitre <lu...@free.fr> wrote:
> The class File must be patched to be usable with MySql, which doesn't
> use the broker.blobHack method.

I'm a little cautious of this.  The blobHack method came about because
oracle expects an empty blob to be inserted before inserting a new
blob.  And the size of the blobs typically added as files exceed the
limit for objects passed to stored procedures.

> Also one function must be changed in conf/db.properties:
> mysql.core.file.prep.blob={call sp_tmc_prep_file_content(?,EMPTYBLOB)}
> must be changed to:
> mysql.core.file.prep.blob={call sp_tmc_prep_file_content(?,?)}
> Sorry to not being able to put a patch for this last.

No worries, I'll catch it.

Steve