Apr 16th, 2008, 09:10 AM
Help returning XML
I would like to use OracleXmlQuery to return Xml from a normal sql query and then return it as part of the SpringWS response. But it's not clear how to assign the Xml to a response element in a manner consistent with the WSDL.
Does anyone have any experience with this - or suggestions for the next step?
Apr 18th, 2008, 05:15 AM
Reading XML from the database is possible with JDBC 4, the SQLXML type, but I am not sure whether Oracle supports it yet. We are probably going to add support for it in Spring 3.0, but in the mean time, you will have to use the native Oracle mechanism.