The code doesn't do that today, but you could definitely create a
modified version that did.
-jh-
On May 7, 2009, at 7:41 PM, Tim Meagher wrote:
Can it return a serialized xml data type value as introduced in SQL
Server
2005?
Thanks,
Tim Meagher
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Jason
Hunter
Sent: Thursday, May 07, 2009 10:15 PM
To: General Mark Logic Developer Discussion
Cc: Sunil_Chengalva
Subject: Re: [MarkLogic Dev General] Issue with MLSQL Servlet while
fetchingbinary data from SQL Server
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
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
