[ http://wso2.org/jira/browse/WSAS-621?page=all ]
Charitha Kankanamge closed WSAS-621. ------------------------------------ Verified in WSAS-2.2-qabuild2 and closed the bug > Cannot use SQL not equal <> within a data service due to > com.ctc.wstx.exc.WstxUnexpectedCharException > ----------------------------------------------------------------------------------------------------- > > Key: WSAS-621 > URL: http://wso2.org/jira/browse/WSAS-621 > Project: WSO2 WSAS > Issue Type: Bug > Components: data-services > Affects Versions: Nightly > Environment: All > Reporter: Charitha Kankanamge > Assigned To: Saminda Wishwajith Abeyruwan > Priority: Critical > Fix For: 2.2 > > > I have a data service query as given below. > SELECT s.* FROM person p INNER JOIN shirt s ON s.owner = p.id WHERE p.name > LIKE 'Sum%' AND s.color <> 'white' > I'm getting the following exception when saving the data service. > ERROR [2007-11-28 11:24:56,937] > com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character > '>' (code 62) in content after '<' (malformed start element?). > at [row,col {unknown-source}]: [12,114] > org.apache.axiom.om.OMException: > com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character > '>' (code 62) in content after '<' (malformed start element?). > at [row,col {unknown-source}]: [12,114] > at > org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:239) > at > org.apache.axiom.om.impl.llom.OMElementImpl.getNextOMSibling(OMElementImpl.java:265) > at > org.apache.axiom.om.impl.traverse.OMChildrenQNameIterator.next(OMChildrenQNameIterator.ja > va:93) > at > org.wso2.wsas.admin.service.DataServiceAdmin.saveDataServiceContents(DataServiceAdmin.jav > a:119) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:194) > at > org.apache.axis2.rpc.receivers.RPCInOnlyMessageReceiver.invokeBusinessLogic(RPCInOnlyMess > ageReceiver.java:62) > at > org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:9 > 6) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145) > at > org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUt > ils.java:275) > at > org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j > ava:252) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.wso2.adminui.AdminUIServletFilter.doFilter(AdminUIServletFilter.java:142) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j > ava:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Htt > p11BaseProtocol.java:667) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.ja > va:80) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > at java.lang.Thread.run(Thread.java:595) > Caused by: com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character > '>' (code 62) in conte > nt after '<' (malformed start element?). > at [row,col {unknown-source}]: [12,114] > at > com.ctc.wstx.sr.StreamScanner.throwUnexpectedChar(StreamScanner.java:623) > at > com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2852) > at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1019) > at > org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:153) > ... 32 more > I know there is an alternative != can be used for sql not equals command. But > it will be better to allow users to define the available SQL commands within > data services. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://wso2.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Wsas-java-dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/wsas-java-dev
