Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1647

TeiidComponentException from generated web service

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.4.1, 7.5
    • 7.3
    • Server
    • None
    • Hide

      This is the process I used in Eclipse to create the web service application:
      1. File / New / Model Project
      2. Import / Metadata from JDBC Database
      3. Right click on the 'user' table within the source model in Model Explorer and choose 'Modeling / Create Web Service'
      4. Manually create input schema
      5. Edit SQL, inputs, etc. for web service
      6. Create VDB by right-clicking on WS model in Model Explorer, then 'New / Teiid VDB'
      7. Deploy VDB to Teiid server
      8. In Teiid view, create data source for VDB
      9. Create the web service application by right-clicking on the VDB in Model Explorer and selecting 'Modeling / Generate JBossWS-CXF War'
      10. Deploy the generated warfile to app server and test with SoapUI
      The table in MySQL is very simple:
      mysql> use test;
      Database changed
      mysql> desc user;
      -------------------------------------+

      Field Type Null Key Default Extra

      -------------------------------------+

      id int(11) NO PRI NULL  
      name varchar(25) YES   NULL  
      role varchar(25) YES   NULL  

      -------------------------------------+

      Show
      This is the process I used in Eclipse to create the web service application: 1. File / New / Model Project 2. Import / Metadata from JDBC Database 3. Right click on the 'user' table within the source model in Model Explorer and choose 'Modeling / Create Web Service' 4. Manually create input schema 5. Edit SQL, inputs, etc. for web service 6. Create VDB by right-clicking on WS model in Model Explorer, then 'New / Teiid VDB' 7. Deploy VDB to Teiid server 8. In Teiid view, create data source for VDB 9. Create the web service application by right-clicking on the VDB in Model Explorer and selecting 'Modeling / Generate JBossWS-CXF War' 10. Deploy the generated warfile to app server and test with SoapUI The table in MySQL is very simple: mysql> use test; Database changed mysql> desc user; ------ ----------- ---- --- ------- ------+ Field Type Null Key Default Extra ------ ----------- ---- --- ------- ------+ id int(11) NO PRI NULL   name varchar(25) YES   NULL   role varchar(25) YES   NULL   ------ ----------- ---- --- ------- ------+

    Description

      I'm using the 'Generate JBossWS-CXF War' feature of Teiid Designer to expose a MySQL table as a web service. Everything deploys normally and about half the time the web service works correctly, however, I often get the exception shown below when I call the service. It seems to be fairly random as to whether or not it works or throws the exception. Everything is running on one laptop including the client and the database.

      I'm attaching my Eclipse project, warfile and a more complete stack trace. See 'Steps to Reproduce' for my development process and a description of the DB table.

      17:46:20,833 SEVERE [org.teiid.soap] Exception in executeDataservice:

      {0}

      java.lang.Throwable: java.sql.SQLException: Unable to read data from the stream: [TeiidComponentException]Wrong type of data found or no data found; expecting streamable object from the buffer manager.
      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.MySQL_local_user.invoke(MySQL_local_user.java:22)
      at org.teiid.soap.provider.MySQL_local_user.invoke(MySQL_local_user.java:15)
      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:597)
      at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:166)
      at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:82)
      at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:55)
      at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:68)
      at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

      Attachments

        1. MySQL_local.zip
          32 kB
        2. MySQL_WS_VDB.war
          303 kB
        3. stacktrace.txt
          16 kB

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            scottdawson_jira Scott Dawson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: