[teiid-issues] [JBoss JIRA] Commented: (TEIID-1647) TeiidComponentException from generated web service

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12610447#comment-12610447 ] 

Steven Hawkins commented on TEIID-1647:
---------------------------------------

It looks like a socket connection is being used to Teiid.  If that's the case, that is causing unnecessary lob streaming.  A local connection would be a much better choice.

With a socket connection, it is possible for there to be a timing issue.  We send the result back before adding them to the results buffer which means that the lob reference may not yet be populated.  I'll look into fixing that.

> TeiidComponentException from generated web service
> --------------------------------------------------
>
>                 Key: TEIID-1647
>                 URL: https://issues.jboss.org/browse/TEIID-1647
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 7.3
>         Environment: Runtime environment: JBoss AS 5.1, Teiid 7.3, JBossWS-CXF 3.2.1, MySQL 5, mysql-connector-java-5.1.10-bin.jar
> Development environment: Teiid Designer 7.3 installed into Eclipse Helios 3.6.2; SoapUI 2.5 as a test client
>            Reporter: Scott Dawson
>            Assignee: Steven Hawkins
>             Fix For: 7.5
>
>         Attachments: MySQL_local.zip, MySQL_WS_VDB.war, stacktrace.txt
>
>
> 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)

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira