Hi Jason, Thanks for your options. We are trying out with the 3rd option as per your mail below.
Regards, Joydeep -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jason Hunter Sent: Friday, May 08, 2009 7:45 AM To: General Mark Logic Developer Discussion Cc: Sunil_Chengalva Subject: Re: [MarkLogic Dev General] Issue with MLSQL Servlet while fetching binary 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 DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
