[MBS] Blob (MBS Xojo Plugin Mailinglist archive)

Back to the thread list
Previous thread: [MBS] [ANN] 19.0pr7
Next thread: [MBS] ChartDirector interpolation


Re: [MBS] Extra PrefItems?   -   Garth Hjelte
  [MBS] Blob   -   8sens
   Re: [MBS] Blob   -   Christian Schmitz
    Re: [MBS] Blob   -   8sens
     Re: [MBS] Blob   -   Christian Schmitz
     Re: [MBS] Blob   -   Christian Schmitz

[MBS] Blob
Date: 04.01.19 15:24 (Fri, 4 Jan 2019 15:24:08 +0100)
From: 8sens
Hi,

We are using the SQL Plugin (version 18.3).

When we try to insert a "big" blob (±700MB) in the database it don't work but we don't have any error, and our database accept 2GB size blobs.

To insert the blob we proceed like this :

dim wPS as PreparedSQLStatement = db.Prepare("INSERT INTO " + aTab + "(" + aColID + "," + aColBlob + ") values ( ?, ?)")
wPS.BindType(0, SQLPreparedStatementMBS.kTypeString)
wPS.BindType(1, SQLPreparedStatementMBS.kTypeLongBinary)
wPS.SQLExecute aID.XStr, aBlob

Here aBlob is a string and the result of the binary stream of a file. And aID is an integer.

Does MBS limit the size of blobs ? or are we doing something wrong when we insert the blob in the database ?

Thanks for your help.

Cordialement,

<http://www.8sens.com/>
Logiciels de gestion MAC et PC
Benjamin Rault
Service développement

8sens
2 bis rue Léon BLUM
91120 Palaiseau
Tel. 01 69 32 21 03
<email address removed> <mailto:<email address removed>>
www.8sens.com <applewebdata://B444B0D1-661A-4889-BCDA-BEF28AC3F693/www.8sens.com>
N'imprimez ce message que si nécessaire, pensez à l'environnement.

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] Blob
Date: 04.01.19 15:31 (Fri, 4 Jan 2019 15:31:09 +0100)
From: Christian Schmitz


> Am 04.01.2019 um 15:24 schrieb 8sens <<email address removed>>:
>
> Hi,
>
> When we try to insert a "big" blob (±700MB) in the database it don't work but we don't have any error, and our database accept 2GB size blobs.

What database type?
32bit app?

> wPS.SQLExecute aID.XStr, aBlob

> Here aBlob is a string and the result of the binary stream of a file. And aID is an integer.
>
> Does MBS limit the size of blobs ? or are we doing something wrong when we insert the blob in the database ?

We don't limit them.
But you may run out of memory.

Did you check last error property for database?

Sincerely
Christian

Re: [MBS] Blob
Date: 04.01.19 15:38 (Fri, 4 Jan 2019 15:38:41 +0100)
From: 8sens

> Le 4 janv. 2019 à 15:31, Christian Schmitz <<email address removed>> a écrit :
>
>
>
>> Am 04.01.2019 um 15:24 schrieb 8sens <<email address removed>>:
>>
>> Hi,
>>
>> When we try to insert a "big" blob (±700MB) in the database it don't work but we don't have any error, and our database accept 2GB size blobs.
>
> What database type?
Sybase SQL Anywhere 17

> 32bit app?
Yes 32b app

>
>> wPS.SQLExecute aID.XStr, aBlob
>
>> Here aBlob is a string and the result of the binary stream of a file. And aID is an integer.
>>
>> Does MBS limit the size of blobs ? or are we doing something wrong when we insert the blob in the database ?
>
> We don't limit them.
> But you may run out of memory.
>
> Did you check last error property for database?
>
> Sincerely
> Christian
>
> --
> Read our blog about news on our plugins:
>
> http://www.mbsplugins.de/
>
>
> _______________________________________________
> Mbsplugins_monkeybreadsoftware.info mailing list
> <email address removed>
> https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info


Cordialement,

<http://www.8sens.com/>
Logiciels de gestion MAC et PC
Benjamin Rault
Service développement

8sens
2 bis rue Léon BLUM
91120 Palaiseau
Tel. 01 69 32 21 03
<email address removed> <mailto:<email address removed>>
www.8sens.com <applewebdata://9C97824C-0CDD-4717-A7FC-003A2EEFC47C/www.8sens.com>
N'imprimez ce message que si nécessaire, pensez à l'environnement.

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] Blob
Date: 04.01.19 18:58 (Fri, 4 Jan 2019 18:58:04 +0100)
From: Christian Schmitz

>> What database type?
> Sybase SQL Anywhere 17
>
>> 32bit app?
> Yes 32b app

Well, the string in Xojo, a copy in the plugin, another copy in the interface library, this adds up towards some 2 GB limit.

Does it work with 300 MB?

Otherwise you need to use a data provider class.
Or maybe I could add support for passing folderitem to stream a file?

Sincerely
Christian

Re: [MBS] Blob
Date: 04.01.19 20:20 (Fri, 4 Jan 2019 20:20:35 +0100)
From: Christian Schmitz


>> 32bit app?
> Yes 32b app
>

I have added a way to pass folderitem instead of string/memoryblock for blob fields, so the plugin can stream content. This should help with big blobs for 32-bit apps.

Sincerely
Christian