Forum Discussion

alibaba82's avatar
alibaba82
Super Contributor
15 years ago

sql server jdbc query throws error when using 'lower' funct

Hello,
I have using this query which works fine in sql server


select top 2 lower(master_title) from rehab.master_title (nolock)

using this in soapui 3.6 causes this error

Tue Oct 26 03:21:40 PDT 2010:ERROR:An error occured [INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified. ], see error log for detailsTue Oct 26 03:17:40 PDT

2010:ERROR:org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified.
org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified.
at org.apache.xerces.dom.CoreDocumentImpl.createElement(Unknown Source)
at com.eviware.soapui.support.xml.XmlUtils.addResultSetXmlPart(XmlUtils.java:1516)
at com.eviware.soapui.support.xml.XmlUtils.createJdbcXmlResult(XmlUtils.java:1449)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcResponse.<init>(JdbcResponse.java:36)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.createResponse(JdbcSubmit.java:329)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:198)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:160)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    15 years ago
    Hi,

    Could it be an option for you to change your SQL query to

    select top 2 lower(master_title) as some_alias from rehab.master_title (nolock)

    The thing is we are using org.w3c.dom.Document to parse SQL result as XML and parentheses seems to be a problem for XML (in column name).
    Please let us know if it works as well.

    Regards,
    Dragica
    /www.eviware.com