Thanks, Olga, for your suggestion, I tried following things but that did't work:
1) Created a XmlTypeJdbcQueryExecuter class and factory classes as well that extends JRJdbcDataSource that returns JRXmlDataSource.
public class XmlTypeJdbcQueryExecuter extends JRJdbcQueryExecuter ......
2) Registered a new language sqlXML using these classes.
3) Created a report template using sqlXML language where I define a DB SQL that returns XMLType and a set of fields with XPath expression
3) tryed to execute report, not data displayed on report, bank page got created., not sure JRXmlDataSource got used or not, configured SQL executed properly, How this data would be available to report? I didn't add any PARAMETER_XML_DATA_DOCUMENT at all.
4) I tried to wrap XMLType data in JRXmlDataSource and pass to report fill manager that didn't work either, If I am passing JRXmlDataSource as report data, do I need to specify PARAMETER_XML_DATA_DOCUMENT with Xpath based template or this only needed if feeding data as DOM object.
Not sure how I can debug or where things are wrong.
I appreciate your help and assistance.