Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1547

Cannot call web service which is created from model without primary key

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.7
    • 7.7.1
    • Web Services Support
    • None
    • Hide
      1. Create a Teiid project.
      2. Import -> File Source (flat) >> Sorce and View Model
      3. Create Web Service from View Model
      4. Create VDB and add View Model Web Service resources.
      5. Deploy VDB
      6. Generate JBossWS-CXF War and deploy
      7. Call JBossWS-CXF war using Soap UI or JMeter and so on.
      Show
      Create a Teiid project. Import -> File Source (flat) >> Sorce and View Model Create Web Service from View Model Create VDB and add View Model Web Service resources. Deploy VDB Generate JBossWS-CXF War and deploy Call JBossWS-CXF war using Soap UI or JMeter and so on.
    • Workaround Exists
    • Hide

      If you need to get all data via Web Service.

      1. Create a Teiid project.
      2. Import -> File Source (flat) >> Sorce and View Model
      3. Add primary key (or Acess Pattern) to View model
      4. Create Web Service from View Model
      5. Edit Web Service Procedure.
        ex)=====
        CREATE VIRTUAL PROCEDURE
        BEGIN
        SELECT * FROM <modele name>_Output_View.<model name>_OutputView;
        END
        ========
      6. Create VDB and add View Model Web Service resources.
      7. Deploy VDB
      8. Generate JBossWS-CXF War and deploy
      9. Call JBossWS-CXF war using Soap UI or JMeter and so on.
      Show
      If you need to get all data via Web Service. Create a Teiid project. Import -> File Source (flat) >> Sorce and View Model Add primary key (or Acess Pattern) to View model Create Web Service from View Model Edit Web Service Procedure. ex)===== CREATE VIRTUAL PROCEDURE BEGIN SELECT * FROM <modele name>_Output_View.<model name>_OutputView; END ======== Create VDB and add View Model Web Service resources. Deploy VDB Generate JBossWS-CXF War and deploy Call JBossWS-CXF war using Soap UI or JMeter and so on.

      The web service which is created from model without primary key (or Access Pattern) cannot be called by the following exceptions. 

      org.apache.cxf.interceptor.Fault: No binding operation info while invoking unknown method with params unknown.
  at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:60)
  at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
  at java.util.concurrent.FutureTask.run(FutureTask.java:138)
  at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
  at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)
  at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:243)
  at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:111)
  at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:99)
  at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:431)
  at org.jboss.wsf.stack.cxf.ServletControllerExt.invoke(ServletControllerExt.java:173)
  at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:61)
  at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:185)
  at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179)
  at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:103)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
  at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159)
  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:183)
  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
  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.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.internalProcess(ActiveRequestResponseCacheValve.java:74)
  at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:47)
  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:599)
  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
  at java.lang.Thread.run(Thread.java:662)

        1. TEIIDDES-1547_reproducer.zip
          58 kB

              rhn-engineering-tejones Edwin Jones
              rhn-support-enagai Eiichi Nagai (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: