[JBoss JIRA] Moved: (TEIIDDES-977) TeiidComponentException from generated web service
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-977?page=com.atlassian.jira.plug... ]
Steven Hawkins moved TEIID-1608 to TEIIDDES-977:
------------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-977 (was: TEIID-1608)
Affects Version/s: 7.3
(was: 7.3)
Component/s: Web Services Support
(was: SOAP Services)
> TeiidComponentException from generated web service
> --------------------------------------------------
>
> Key: TEIIDDES-977
> URL: https://issues.jboss.org/browse/TEIIDDES-977
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> 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
> Attachments: MySQL_local.zip
>
>
> 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' below 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
14 years, 10 months
[JBoss JIRA] Updated: (TEIIDDES-977) TeiidComponentException from generated web service
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-977?page=com.atlassian.jira.plug... ]
Steven Hawkins updated TEIIDDES-977:
------------------------------------
Assignee: Ted Jones (was: Steven Hawkins)
> TeiidComponentException from generated web service
> --------------------------------------------------
>
> Key: TEIIDDES-977
> URL: https://issues.jboss.org/browse/TEIIDDES-977
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> 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: Ted Jones
> Attachments: MySQL_local.zip
>
>
> 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' below 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
14 years, 10 months
[JBoss JIRA] Updated: (TEIIDDES-977) TeiidComponentException from generated web service
by Scott Dawson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-977?page=com.atlassian.jira.plug... ]
Scott Dawson updated TEIIDDES-977:
----------------------------------
Attachment: MySQL_local.zip
> TeiidComponentException from generated web service
> --------------------------------------------------
>
> Key: TEIIDDES-977
> URL: https://issues.jboss.org/browse/TEIIDDES-977
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> 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
> Attachments: MySQL_local.zip
>
>
> 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' below 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
14 years, 10 months
[JBoss JIRA] Created: (TEIIDDES-970) Fetch keyword not handled
by Joel Tosi (JIRA)
Fetch keyword not handled
-------------------------
Key: TEIIDDES-970
URL: https://issues.jboss.org/browse/TEIIDDES-970
Project: Teiid Designer
Issue Type: Bug
Components: Validation
Affects Versions: 7.2
Environment: JBDS 4.0
Reporter: Joel Tosi
Priority: Minor
Try to limit your query using native SQL construct fetch. While there are other ways to do this inside designer, support the native SQL construct for ease of use by data architects:
select * from SAMPLE_DATABASE fetch first 100 rows only
jBoss Designer error:
select * from SAMPLE_DATABASE fetch first 100 rows only
Remote org.teiid.api.exception.query.QueryParserException: Parsing error:
Encountered "fetch" at line 1, column 36.
Was expecting one of:
<EOF>
"group" ...
"having" ...
"intersect" ...
"limit" ...
"makedep" ...
"makenotdep" ...
"order" ...
"where" ...
"," ...
";" ...
"union" ...
"except" ...
"option" ...
"cross" ...
"right" ...
"left" ...
"full" ...
"inner" ...
"join" ...
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 10 months