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
