Forum Discussion

CARQUESTTechnol's avatar
CARQUESTTechnol
Contributor
16 years ago

JDBC Request and Count

I'm trying to get the count of the number of rows returned by a specific query to compare to a webservice. When I write the SQL: Select Count(*) from table where cat_id='-1' The query works in...
CARQUESTTechnol's avatar
CARQUESTTechnol
Contributor
15 years ago
Yes I do:

Tue Jan 11 15:33:03 EST 2011: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)


This is for the following Query:

Select Count(ACES.MAKE.MAKEID)
From ACES.MAKE

This query works when I preview it in the SQL builder.