Hi Mariano > Hi Norbert! How are you ? Here with 7 cm of snow :)
Nice. Is that already more than you would like to have? ;-)
> 1) This depends just in the backend or also in the OS ? Is it possible
> that for a particular client library they behave different in different OS
> like the asynchronous queries for example ?
> or is it the same for all OS ?
It's only dependent on the backend.
> 2) I need to know for all the backends, which ones use normal functions and
> which ones the special functions
Firebird provides odbx_lo_* capabilites and Oracle could but I didn't get it
to work without segfault. All other backends use the regular functions to
manage large texts or blobs.
> 3) how do you know the answer to 2) ? Can I get it invoking some
> function, like odbx_get_option() for example ?
You can test with odbx_capabilites() for ODBX_CAP_LO. It will tell you if the
large object interface is supported or not. Please also refer to the
test/odbx-regression.{c,h} files if you would like to know how this could be
implemented.
> 4) Suppose I have a row with a CLOB field of 1Gb (to say something)....I
> would like to prevent to load such field in my Smalltalk image as it will
> probably crash everything. Is there a way to limit this, I mean, to put a
> maximum ? is there a way to ask the size before loading ? this depends on
> the way large objects are managed (normal or special functions) ?
You can only limit the retrieved size in the freetds based backends (mssql,
sybase). All others don't provide this functionality.
If the backend supports the odbx_lo_* functions, you can retrieve the the
content of the large object in chunks. Providing a function to retrieve the
size fails because Oracle has implemented its own semantic (returns number of
characters instead of number of bytes).
Norbert
--
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
