2 Replies Latest reply on Aug 24, 2012 2:49 PM by daniel.siwiec

    QueryParserException when invoking web service from generated WAR

    daniel.siwiec

      Hi,

       

      I created a simpe web service and auto-generated WAR for it. When invoking the service, here's the exception I'm getting. Any ideas are greatly appreciated, as I've been struggling with it for a while now.

      This is the configuration I'm using: Jboss 5.1 + teidd 7.7 + designer 7.8

       

      Thanks,

      Daniel

       

      2012-08-23 21:03:18,619 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Processing exception 'Parsing error: Encountered "null" at line 1, column 6.

      Was expecting:

          <ID> ...

          ' for request U4R+MUgcJQDI.0.  Exception type org.teiid.api.exception.query.QueryParserException thrown from org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:194). Enable more detailed logging to see the entire stacktrace.

      2012-08-23 21:03:18,664 SEVERE [org.teiid.soap] (http-127.0.0.1-8080-1) Exception in executeDataservice: {0}

      java.lang.Throwable: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

      Was expecting:

          <ID> ...

         

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:194)

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316)

                at org.teiid.soap.provider.Customers.invoke(Customers.java:22)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:616)

                at org.jboss.wsf.container.jboss50.invocation.InvocationHandlerJSE.invoke(InvocationHandlerJSE.java:108)

                at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:222)

                at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:474)

                at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:295)

                at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:205)

                at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:131)

                at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(AbstractEndpointServlet.java:85)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

                at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

                at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

                at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

                at java.lang.Thread.run(Thread.java:679)

      Caused by: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

      Was expecting:

          <ID> ...

         

                at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

                at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

                at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:624)

                at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:72)

                at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:539)

                at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

                at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

                at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

                at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:220)

                at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:255)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:616)

                at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:110)

                at $Proxy291.read(Unknown Source)

                at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:349)

                at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:548)

                at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:211)

                at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:299)

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124)

                ... 34 more

      Caused by: [QueryParserException]Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

      Was expecting:

          <ID> ...

         

                at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:194)

                at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:148)

                at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:124)

                at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:309)

                at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:384)

                at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:138)

                at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459)

                at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:516)

                at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276)

                at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

                at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)

                at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)

                at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)

                at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

                ... 1 more

      2012-08-23 21:03:18,677 ERROR [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] (http-127.0.0.1-8080-1) SOAP request exception

      java.lang.RuntimeException: javax.xml.ws.soap.SOAPFaultException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

      Was expecting:

          <ID> ...

         

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:318)

                at org.teiid.soap.provider.Customers.invoke(Customers.java:22)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:616)

                at org.jboss.wsf.container.jboss50.invocation.InvocationHandlerJSE.invoke(InvocationHandlerJSE.java:108)

                at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:222)

                at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:474)

                at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:295)

                at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:205)

                at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:131)

                at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(AbstractEndpointServlet.java:85)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

                at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

                at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

                at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

                at java.lang.Thread.run(Thread.java:679)

      Caused by: javax.xml.ws.soap.SOAPFaultException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

      Was expecting:

          <ID> ...

         

                at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248)

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201)

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316)

                ... 33 more