October 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2246) Incorrect results with TIMESTAMPDIFF

by Van Halbert (JIRA)

Van Halbert created TEIID-2246: ---------------------------------- Summary: Incorrect results with TIMESTAMPDIFF Key: TEIID-2246 URL: https://issues.jboss.org/browse/TEIID-2246 Project: Teiid Issue Type: Feature Request Components: Server Affects Versions: 7.4.4 Reporter: Van Halbert Assignee: Steven Hawkins 2 issues with TIMESTAMPDIFF: 1. select TIMESTAMPDIFF(SQL_TSI_DAY,parseDate('2012-01-01', 'yyyy-MM-dd'),parseDate('2304-04-12', 'yyyy-MM-dd')); result = 106751 If you increase the end date by 1 day: select TIMESTAMPDIFF(SQL_TSI_DAY,parseDate('2012-01-01', 'yyyy-MM-dd'),parseDate('2304-04-13', 'yyyy-MM-dd')) result = -106751. I would expected the answer to be 106752 2. Both MS Excel and Oracle give the number of days between 1-Jan-2012 and 12-Apr-2304 as 106752, not the 106751 that EDS is reporting. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

4
12
0 / 0

[JBoss JIRA] (TEIID-2277) Error Executing WS Translator

by Ted Jones (JIRA)

Ted Jones created TEIID-2277: -------------------------------- Summary: Error Executing WS Translator Key: TEIID-2277 URL: https://issues.jboss.org/browse/TEIID-2277 Project: Teiid Issue Type: Bug Components: Connector API Affects Versions: 8.2 Reporter: Ted Jones Assignee: Steven Hawkins When executing against a web service source, I encounter the following exception: 13:19:19,493 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue5) Connector worker process failed for atomic-request=8ZMXsaZy+Sme.0.9.1: org.teiid.translator.TranslatorException: Error reading XMLStreamReader. at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:139) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:255) [teiid-engine-8.2.0.Beta2.jar:8.2.0.Beta2] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:457) [teiid-engine-8.2.0.Beta2.jar:8.2.0.Beta2] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:177) [teiid-engine-8.2.0.Beta2.jar:8.2.0.Beta2] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:174) [teiid-engine-8.2.0.Beta2.jar:8.2.0.Beta2] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.6.0_24] at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.6.0_24] at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) [teiid-engine-8.2.0.Beta2.jar:8.2.0.Beta2] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:250) [teiid-engine-8.2.0.Beta2.jar:8.2.0.Beta2] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.2.0.Beta2.jar:8.2.0.Beta2] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.2.0.Beta2.jar:8.2.0.Beta2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.6.0_24] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24] at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24] Caused by: javax.xml.ws.soap.SOAPFaultException: Error reading XMLStreamReader. at org.apache.cxf.jaxws.DispatchImpl.mapException(DispatchImpl.java:285) at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:388) at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:241) at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:135) ... 13 more Caused by: org.apache.cxf.binding.soap.SoapFault: Error reading XMLStreamReader. at org.apache.cxf.binding.soap.interceptor.ReadHeadersInterceptor.handleMessage(ReadHeadersInterceptor.java:237) at org.apache.cxf.binding.soap.interceptor.ReadHeadersInterceptor.handleMessage(ReadHeadersInterceptor.java:60) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263) at org.apache.cxf.endpoint.ClientImpl.onMessage(ClientImpl.java:795) at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponseInternal(HTTPConduit.java:1626) at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponse(HTTPConduit.java:1493) at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1401) at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:56) at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:648) at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:62) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263) at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:531) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:461) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:364) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:317) at org.apache.cxf.endpoint.ClientImpl.invokeWrapped(ClientImpl.java:352) at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:381) ... 15 more Caused by: com.ctc.wstx.exc.WstxEOFException: Unexpected EOF in prolog at [row,col {unknown-source}]: [1,0] at com.ctc.wstx.sr.StreamScanner.throwUnexpectedEOF(StreamScanner.java:677) at com.ctc.wstx.sr.BasicStreamReader.handleEOF(BasicStreamReader.java:2104) at com.ctc.wstx.sr.BasicStreamReader.nextFromProlog(BasicStreamReader.java:2010) at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1102) at com.ctc.wstx.sr.BasicStreamReader.nextTag(BasicStreamReader.java:1125) at org.apache.cxf.binding.soap.interceptor.ReadHeadersInterceptor.handleMessage(ReadHeadersInterceptor.java:138) ... 31 more 13:19:19,511 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue6) TEIID30020 Processing exception 'TEIID30504 stateService: Error reading XMLStreamReader.' for request 8ZMXsaZy+Sme.0. Exception type org.teiid.core.TeiidProcessingException thrown from com.ctc.wstx.sr.StreamScanner.throwUnexpectedEOF(StreamScanner.java:677). Enable more detailed logging to see the entire stacktrace. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

3
14
0 / 0

[JBoss JIRA] (TEIID-2233) Improve parser errors

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2233: ------------------------------------- Summary: Improve parser errors Key: TEIID-2233 URL: https://issues.jboss.org/browse/TEIID-2233 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 It would be good if the parser reported more of the sql where the parse error occurred. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
4
0 / 0

[JBoss JIRA] (TEIID-2245) Limit pushdown of nulls first/last

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2245: ------------------------------------- Summary: Limit pushdown of nulls first/last Key: TEIID-2245 URL: https://issues.jboss.org/browse/TEIID-2245 Project: Teiid Issue Type: Enhancement Components: Connector API Affects Versions: 7.4.4 Reporter: Steven Hawkins Assignee: Johnathon Lee Priority: Critical Fix For: 7.4.5 Add the ability to configure how nulls first/last will be handled. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
10
0 / 0

[JBoss JIRA] (TEIID-2230) VDB with only VDB Imports Never Loads

by Ted Jones (JIRA)

Ted Jones created TEIID-2230: -------------------------------- Summary: VDB with only VDB Imports Never Loads Key: TEIID-2230 URL: https://issues.jboss.org/browse/TEIID-2230 Project: Teiid Issue Type: Feature Request Components: Server Affects Versions: 8.1 Reporter: Ted Jones Assignee: Steven Hawkins When creating a preview VDB in Designer with two VDB imports, the VDB never becomes active. It remains in "LOADING" status. Adding a model to the VDB in addition to the two VDB imports allows the VDB to deploy in "ACTIVE" status. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
1
0 / 0

[JBoss JIRA] (TEIID-2226) Validate that result sets returned from a procedure match the expected metadata

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2226: ------------------------------------- Summary: Validate that result sets returned from a procedure match the expected metadata Key: TEIID-2226 URL: https://issues.jboss.org/browse/TEIID-2226 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 Very little validation is performed to ensure that the proper resultset is returned from a procedure. for example: {code}create virtual procedure vproc (x integer) returns table (y integer) as begin if (x = 1) select 1; else select 1, 2; end;{code} will return an incorrect result if anything but 1 is passed in, which will cause downstream errors, such as exceptions during serialization (if mismatched types) or npes if too few columns. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1064) Create connector for Google Spreadsheets.

by John Doyle (JIRA)

Create connector for Google Spreadsheets. ----------------------------------------- Key: TEIID-1064 URL: https://jira.jboss.org/jira/browse/TEIID-1064 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 7.1 Reporter: John Doyle Assignee: John Doyle Connectivity to Google spreadsheets for Teiid was identified as a desirable feature. I've hacked together a little prototype code that can access Google Spreadsheets through the Table feed. http://code.google.com/apis/spreadsheets/data/3.0/developers_guide_java.h... I envision the connector as driven by a text file for it's metadata just like the Text connector is. I imagine it would be possible to create some tooling that could define a model from the same text file, but that is out of the scope of this Jira. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

6
13
0 / 0

[JBoss JIRA] (TEIID-2210) Create Object Translator to support Infinispan and other Map oriented data sources

by Van Halbert (JIRA)

Van Halbert created TEIID-2210: ---------------------------------- Summary: Create Object Translator to support Infinispan and other Map oriented data sources Key: TEIID-2210 URL: https://issues.jboss.org/browse/TEIID-2210 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Reporter: Van Halbert Assignee: Steven Hawkins Create the Object-translator that can support map oriented data sources (i.e., Infinispan, Coherence, etc.). The OBJECTABLE function can be used to tabularize the object once retrieved from the translator. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
11
0 / 0

[JBoss JIRA] (TEIID-2224) public int TeiidResultSet.available()

by Mark Addleman (JIRA)

Mark Addleman created TEIID-2224: ------------------------------------ Summary: public int TeiidResultSet.available() Key: TEIID-2224 URL: https://issues.jboss.org/browse/TEIID-2224 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Mark Addleman Assignee: Steven Hawkins Expose a new method in TeiidResultSet: int available() to return the number of rows available in the result set before blocking (contract similar to InputStream available) See https://community.jboss.org/thread/205559?tstart=0 for more context -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
3
0 / 0

[JBoss JIRA] (TEIID-2170) Teiid Hibernate Dialect needs to be updated for Hibernate 4.x

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2170: ----------------------------------- Summary: Teiid Hibernate Dialect needs to be updated for Hibernate 4.x Key: TEIID-2170 URL: https://issues.jboss.org/browse/TEIID-2170 Project: Teiid Issue Type: Enhancement Components: JDBC Driver Affects Versions: 8.1 Reporter: Ramesh Reddy Currently Hibernate dialect is compiled with 3.5.2, running an example with latest 4.1.6 version, I see errors such as {code} Exception in thread "main" java.lang.NoSuchFieldError: DOUBLE at org.teiid.dialect.TeiidDialect.<init>(TeiidDialect.java:64) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at java.lang.Class.newInstance0(Class.java:372) at java.lang.Class.newInstance(Class.java:325) at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:156) {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

3
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2012