[JBoss JIRA] Created: (TEIID-1704) if where clause contains more than one equal condition on the same column, no rows are returned for the count query
by Gaurav Chaudhary (JIRA)
if where clause contains more than one equal condition on the same column, no rows are returned for the count query
-------------------------------------------------------------------------------------------------------------------
Key: TEIID-1704
URL: https://issues.jboss.org/browse/TEIID-1704
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 7.3
Reporter: Gaurav Chaudhary
Assignee: Steven Hawkins
SELECT count(*) FROM "table1" as Something WHERE (Something."column1" = 'gaurav' AND Something."column1" = 'chaudhary')
does not return any row when this is fired through a prepared statement.
#Table table does not have any value given in the where clause
Though the query
SELECT count(*) FROM "table1" as Something WHERE (Something."column1" = 'gaurav')
works and returns a row with 0 as value.
Though this is a minor issue but due to this, our search is failing if the user gives matching columns in the criteria.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] Created: (TEIID-1652) ODBC Data Row results should be batched
by Ramesh Reddy (JIRA)
ODBC Data Row results should be batched
---------------------------------------
Key: TEIID-1652
URL: https://issues.jboss.org/browse/TEIID-1652
Project: Teiid
Issue Type: Enhancement
Components: ODBC
Affects Versions: 7.1.1
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Fix For: 7.4.1, 7.5, 7.1.1
Teiid currently writes one row at a time into the wire to send the ODBC data rows. Since the ODBC driver is capable of reading a stream of rows, it will be performant to batch multiple rows into single buffer before they can written to the wire. This will reduce the network fragmentation and result in fewer number of round trips and helps of network latency.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] Created: (TEIID-1608) TeiidComponentException from generated web service
by Scott Dawson (JIRA)
TeiidComponentException from generated web service
--------------------------------------------------
Key: TEIID-1608
URL: https://issues.jboss.org/browse/TEIID-1608
Project: Teiid
Issue Type: Bug
Components: SOAP Services
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
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
12 years, 4 months