March 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1941) Coherence Translator/Connector - Add the ability to issue UPDATE statements

by Van Halbert (JIRA)

Van Halbert created TEIID-1941: ---------------------------------- Summary: Coherence Translator/Connector - Add the ability to issue UPDATE statements Key: TEIID-1941 URL: https://issues.jboss.org/browse/TEIID-1941 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 7.7 Reporter: Van Halbert Assignee: Van Halbert Add the ability to support UPDATE statements -- 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, 6 months

1
1
0 / 0

[JBoss JIRA] (TEIID-1942) Coherence Translator/Connector - Add the support for using the Coherence JCA

by Van Halbert (JIRA)

Van Halbert created TEIID-1942: ---------------------------------- Summary: Coherence Translator/Connector - Add the support for using the Coherence JCA Key: TEIID-1942 URL: https://issues.jboss.org/browse/TEIID-1942 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 7.7 Reporter: Van Halbert Assignee: Van Halbert Add the support for using the Coherence JCA. -- 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, 6 months

1
1
0 / 0

[JBoss JIRA] (TEIID-1940) Coherence Translator/Connector - Make the read-only ability fully functional, out-of-the-box

by Van Halbert (JIRA)

Van Halbert created TEIID-1940: ---------------------------------- Summary: Coherence Translator/Connector - Make the read-only ability fully functional, out-of-the-box Key: TEIID-1940 URL: https://issues.jboss.org/browse/TEIID-1940 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 7.7 Reporter: Van Halbert Assignee: Van Halbert Make the read-only ability Coherence Translator/Connector fully functional. It currently supports the ability to read the root object and its attributes. However, it currently only supports a Map type attribute. Support for other types (i.e., Collections, Arrays) need to be added. -- 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, 6 months

1
6
0 / 0

[JBoss JIRA] (TEIID-1854) OData server

by Mark Addleman (Created) (JIRA)

OData server ------------ Key: TEIID-1854 URL: https://issues.jboss.org/browse/TEIID-1854 Project: Teiid Issue Type: Feature Request Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Minor Teiid should act as an OData server as well as a JDBC server. This is not TEIID-1757 as that is about Teiid being an OData client. -- 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, 6 months

2
1
0 / 0

[JBoss JIRA] (TEIID-1912) Issuing and inner merge join query produces IOException against PostgreSQL database

by Van Halbert (JIRA)

Van Halbert created TEIID-1912: ---------------------------------- Summary: Issuing and inner merge join query produces IOException against PostgreSQL database Key: TEIID-1912 URL: https://issues.jboss.org/browse/TEIID-1912 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 7.7 Environment: Teiid 7.7.0 (built with latest today) in JBoss AS 5.1 against Oracle 10 and PostgreSQL 9.4 databases Reporter: Van Halbert Assignee: Steven Hawkins Running the following inner merge query: SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY = ORDERS.O_CUSTKEY) AND (ORDERS.O_ORDERDATE < '1992-02-06 00:00:00') AND (CUSTOMER.C_ACCTBAL > 5100) produces exception: 1 [PSQLException]An I/O error occured while sending to the backend. 2 [IOException]Tried to send an out-of-range integer as a 2-byte value: 50000 at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:272) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:342) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:680) >From googling the exception, I found the suggestion (i've yet to find where Postgres specifically states the max allowable) to split the parameters into 30,000 chunks. So I changed the PostgreSQLExecutionFactory by adding the following the CTOR: setMaxDependentInPredicates(30); and this allowed the query to finish. Not to say this is the final solution, but it's an option that worked. -- 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, 7 months

2
12
0 / 0

[JBoss JIRA] (TEIID-1900) Teiid client jar file is not complete: NoClassDefFoundError: org/jboss/modules/ModuleLoadException

by Paul Nittel (JIRA)

Paul Nittel created TEIID-1900: ---------------------------------- Summary: Teiid client jar file is not complete: NoClassDefFoundError: org/jboss/modules/ModuleLoadException Key: TEIID-1900 URL: https://issues.jboss.org/browse/TEIID-1900 Project: Teiid Issue Type: Bug Affects Versions: 8.0 Environment: Fedora 16, IcedTea6 1.10.4 Reporter: Paul Nittel Assignee: Steven Hawkins After adding the Teiid driver in SQuirreL, I was unable to connect to the Teiid 8 server. Here's the stacktrace: java.lang.NoClassDefFoundError: org/jboss/modules/ModuleLoadException at org.teiid.jdbc.TeiidDriver.<init>(TeiidDriver.java:74) at org.teiid.jdbc.TeiidDriver.<clinit>(TeiidDriver.java:61) 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 net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.registerSQLDriver(SQLDriverManager.java:75) at net.sourceforge.squirrel_sql.client.gui.db.DataCache.registerDriver(DataCache.java:491) at net.sourceforge.squirrel_sql.client.gui.db.DataCache.loadDrivers(DataCache.java:388) at net.sourceforge.squirrel_sql.client.gui.db.DataCache.<init>(DataCache.java:119) at net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:744) at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:222) at net.sourceforge.squirrel_sql.client.Main$2.run(Main.java:118) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:226) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:647) at java.awt.EventQueue.access$000(EventQueue.java:96) at java.awt.EventQueue$1.run(EventQueue.java:608) at java.awt.EventQueue$1.run(EventQueue.java:606) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:105) at java.awt.EventQueue.dispatchEvent(EventQueue.java:617) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177) at java.awt.EventDispatchThread.run(EventDispatchThread.java:138) Caused by: java.lang.ClassNotFoundException: org.jboss.modules.ModuleLoadException at java.net.URLClassLoader$1.run(URLClassLoader.java:217) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:205) at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209) at java.lang.ClassLoader.loadClass(ClassLoader.java:321) at java.lang.ClassLoader.loadClass(ClassLoader.java:266) ... 30 more -- 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, 7 months

3
4
0 / 0

[JBoss JIRA] (TEIID-1801) Async Event Processing: Reset and Re-run plan

by Mark Addleman (Created) (JIRA)

Async Event Processing: Reset and Re-run plan ---------------------------------------------- Key: TEIID-1801 URL: https://issues.jboss.org/browse/TEIID-1801 Project: Teiid Issue Type: Feature Request Reporter: Mark Addleman Assignee: Steven Hawkins In order to processing a stream of events aggregated within a specified time window, the engine should provide some way of specifying the time period (analogous to a window), reset and re-rerun the plan for every time period. There should also be an engine to translator callback indicating that the plan has been reset as opposed to closed. -- 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, 7 months

8
10
0 / 0

[JBoss JIRA] (TEIID-1852) Salesforce Translator doesnt handle Time types

by Mark Drilling (Created) (JIRA)

Salesforce Translator doesnt handle Time types ---------------------------------------------- Key: TEIID-1852 URL: https://issues.jboss.org/browse/TEIID-1852 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 7.6 Reporter: Mark Drilling Assignee: Steven Hawkins Attachments: SFTestVDB.vdb Query the BusinessHours table imported from Salesforce, which contains columns with 'time' datatype. For example, the query: SELECT Name,CreatedDate,MondayStartTime FROM SFTest.salesforce.BusinessHours Results in: Error Code:ERR.003.029.0025 Message:Failed to transform String to Time. Expected format = hh:mm:ss for 08:00:00.000Z It looks like the code in QueryExecutionImpl.getCellDatum needs to handle translation of the salesforce time format -- 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, 7 months

6
7
0 / 0

[JBoss JIRA] Created: (TEIID-1326) API request: rewrite query/command before it reaches the teiid planner

by Mark Addleman (JIRA)

API request: rewrite query/command before it reaches the teiid planner ----------------------------------------------------------------------- Key: TEIID-1326 URL: https://jira.jboss.org/browse/TEIID-1326 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Mark Addleman Assignee: Steven Hawkins I'd like an API to inspect and rewrite a user query/command before it reaches the Teiid planner. The use case is to rewrite the query/command to implement view-like capabilities. For example: SELECT a,b,c FROM table1 AS t WHERE t.a='xyz' would be rewritten as: SELECT a,b,c FROM (SELECT a,b,c FROM table2 UNION SELECT a,b,c FROM table3) AS t I imagine this API would be similar to the translator API: it would receive a data structure representing the query/command and use a visitor to rewrite the query. As a convenience, it would be nice to have something similar to the SQLConversionVisitor. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 7 months

6
19
0 / 0

[JBoss JIRA] (TEIID-1869) Simple capabilities with PostgreSQL 8.3 using decodeinteger causes comm failure

by Paul Nittel (Created) (JIRA)

Simple capabilities with PostgreSQL 8.3 using decodeinteger causes comm failure ------------------------------------------------------------------------------- Key: TEIID-1869 URL: https://issues.jboss.org/browse/TEIID-1869 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.6 Reporter: Paul Nittel Assignee: Steven Hawkins We use PostgreSQL 8.3 twice: once to test push-down to the source and the other to test not-pushed-down queries. The following works fine with the push-down. It's not so good when we use simple-capabilities. The query is: SELECT IntKey, BooleanValue, DECODEINTEGER(BooleanValue, 'false,3,true,7') AS Decoded FROM BQT1.SmallA ORDER BY IntKey What happens is: $ ./RunQT jdbc:teiid:QT_PostgreSQL83@mm://localhost:31000 user user yes "SELECT IntKey, BooleanValue, DECODEINTEGER(BooleanValue, 'false,3,true,7') AS Decoded FROM BQT1.SmallA ORDER BY IntKey" Caught SQLException: [SingleInstanceCommunicationException] 1 [EOFException] In the case of query testing, all subsequent queries fail due to a closed socket error. Dev indicated "That's a bug with the rewriter. We are just converting the decode function into a searched case statement, but are leaving the then values as string - rather than converting them to integers. The pushdown works because the resulting string value is converted to an integer via the translator/driver logic." -- 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, 7 months

5
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2012