JDBC RQ Error: INVALID_CHARACTER_ERR: An invalid or illegal
Greetings,
I've created two JDBC requests and verified the connection is valid. Each request uses the same connection information, but has a different SQL query. When I run the test case, one JDBC request receives the "invalid or illegal XML character" error but the other doesn't. I've verified both are valid SQL statements using TOAD, and neither request has parametrized data. Requests and error message are below:
Request that does NOT yield the error:
Request that does yield the error:
Error:
Any thoughts?
SoapUI Pro, ver 3.5.1
I've created two JDBC requests and verified the connection is valid. Each request uses the same connection information, but has a different SQL query. When I run the test case, one JDBC request receives the "invalid or illegal XML character" error but the other doesn't. I've verified both are valid SQL statements using TOAD, and neither request has parametrized data. Requests and error message are below:
Request that does NOT yield the error:
SELECT UNIQUE
a.column1 as column1,
a.column2 as column2,
b.column1 as "B column1",
b.column2 as "B column2"
FROM table1 a
left outer join table2 b on b.column3 = a.column3 and b.column4 = 71
WHERE
b.column2 LIKE '123%45%6789'
order by a.column2
Request that does yield the error:
SELECT UNIQUE
a.column1 as column1,
a.column2 as column2,
c.column1 as "B column1",
c.column2 as "B column2",
c.column3 as "B column3"
FROM table1 a
left outer join table3 c on c.column3 = a.column3
WHERE
a.column1 = '123456'
order by a.column2
Error:
Fri Jul 09 08:30:45 MDT 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:1510)
at com.eviware.soapui.support.xml.XmlUtils.createJdbcXmlResult(XmlUtils.java:1444)
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:348)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:204)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:161)
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)
Any thoughts?
SoapUI Pro, ver 3.5.1
