[squeak-dev] [ANN] - SqueakDBX first stable version 1.0!!!

Mariano Martinez Peck marianopeck at gmail.com
Tue Apr 21 12:27:23 UTC 2009


On Tue, Apr 21, 2009 at 2:04 AM, Bèrto ëd Sèra <berto.d.sera at gmail.com>wrote:

> Hi!
>
> Multistatement is okay, that's just to make sure the API knows what to do.
> But beware that retrieving TEXT/BLOB fields as parameters sometimes may be
> far from easy, due to the fact that you have no idea of the actual lenght.
> PHP basically cannot do it, so I wonder if openDBX can. Let me know.
>

As I can figure out from your email, you know far much more than I in SP.
However, I think we are mixing two things:

1) SP support: This SHOULD be as I told you: enableMultistatement and just
query the resutls. But, it was never tested so we don't know if it works. I
don't know how input and oput variables should be managed. I will give it a
try.

2) Long fields support: OpenDBX support large objects (TEXT/BLOC...). We
(right now) do not. This is also planned. You can see it here:
http://wiki.squeak.org/squeak/6106
We have to map from string (openDBX) to objects (squeak). You can read here:
http://wiki.squeak.org/squeak/6075 how we do this.

There it says:

"Large objects like CLOB, NCLOB and BLOB are not still supported. However,
this is actually not true. OpenDBX has several functions to use a RDBMS.
And, it also has another functions to specially manage large objects. But
OpenDBX doesn't ALWAYS use those special functions for large objects. It
depends on the backend. Some backends need to use those functions, and with
others you can just use the standard functions. So, what SqueakDBX actually
doesn't support right now are those special functions for large objects.
Thus, it doesn't support large objects for the backends that need the
special functions. For more information, see
http://www.linuxnetworks.de/doc/index.php/OpenDBX/C_API/1.2.
Example: If you see DBXPlatform #createDataTypesMap you will see that CLOB
is not supported. But for Sqlite3 you can use the normal functions, so,
actually squeakDBX supports that. DBXSqlitePlatform overrides that method
and map a CLOB to a String.
"


Once we get 1) and 2) working, I think we can have the mix of them: SP that
use large objects.

What do you think ?




>
> Berto
>
> 2009/4/21 Mariano Martinez Peck <marianopeck at gmail.com>
>
>
>>
>> On Mon, Apr 20, 2009 at 7:25 PM, Bèrto ëd Sèra <berto.d.sera at gmail.com>wrote:
>>
>>> Hi!
>>>
>>> Compliments! FMI, is there any support for stored procedures, stored
>>> functions and IN OUT parameter passing with MySQL 5.1?
>>>
>>
>> Thanks! More or less. At least, it is not tested. However, as you can see
>> in: http://wiki.squeak.org/squeak/6106 we plan to do it in a future.
>>
>> When I asked Norbert (openDBX author) about openDBX store procedure
>> support, he told me "You have to enable the multi-statement option and
>> retrieve all result sets using odbx_result. ". This, in SqueakDBX means:
>> DBXConnection #enableMultiStatements and then do #execute: aSQLString.
>>
>> I guess in this case aSQLString can be the call string to SP, but I really
>> don't know.
>>
>> So, perhaps we do support SP but we don't know it. Is just a matter of
>> testing. If you want I can google and see how to create a simple SP and see
>> If I can call it and retrieve the results.
>>
>> Cheers,
>>
>> Mariano
>>
>>
>>> Thanks
>>> Berto
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
>
> --
> ==============================
> Constitution du 24 juin 1793 - Article 35. - Quand le gouvernement viole
> les droits du peuple, l'insurrection est, pour le peuple et pour chaque
> portion du peuple, le plus sacré des droits et le plus indispensable des
> devoirs.
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeak-dev/attachments/20090421/4a15663a/attachment.htm


More information about the Squeak-dev mailing list