Please let me know whether the MLSQL Servlet is capable of fetching
binary content from any RDMS or not.
If yes, kindly let me know how to fetch the binary data as well.
MLSQL was not written to support fetching binary objects (blobs) from
a relational database. It returns simple string representations of
column values.
Options:
1. Enhance MLSQL to support blobs. The project is open source, so
that's an approach you could take.
2. Use MLJAM (lets you script Java from XQuery). It supports
transferring binary objects over the wire, so you could write the JDBC
code to query and obtain the binary object and send it back to XQuery
via MLJAM.
3. Go your own way. Like make your own web service call out with
xdmp:http-get(). Or drive the move of content via Java instead of
XQuery.
-jh-
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
