February 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1943) Create a JDBC Wrapper that will enable the creation of tables from a Java API via importing

by Van Halbert (JIRA)

Van Halbert created TEIID-1943: ---------------------------------- Summary: Create a JDBC Wrapper that will enable the creation of tables from a Java API via importing Key: TEIID-1943 URL: https://issues.jboss.org/browse/TEIID-1943 Project: Teiid Issue Type: Feature Request Components: Tools Reporter: Van Halbert Assignee: Van Halbert Create a JDBC wrapper that will enable someone to create tables from their Java API. This will assist in the modeling effort in order to use the Coherence translator. Additionally, this could be useful when Infinispan is supported. -- 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

11 years, 9 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1560) Add support for user defined / pushdown aggregate functions

by Steven Hawkins (JIRA)

Add support for user defined / pushdown aggregate functions ----------------------------------------------------------- Key: TEIID-1560 URL: https://issues.jboss.org/browse/TEIID-1560 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 Add support for user defined aggregate functions. This would also affect the function model metadata. Our aggregate handling logic will need to be generalized to make this possible. Starting with the parser we've got special handling for built-in aggregates. for user defined aggregate handling just a static method will not work as the function needs to retain state across each group. Could require that the implementing class extends AggregateFunction. Could also allow user defined aggregates to take an order by clause. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
4
0 / 0

[JBoss JIRA] (TEIID-1899) Getting Assertion when running running Inner Merge Join

by Van Halbert (JIRA)

Van Halbert created TEIID-1899: ---------------------------------- Summary: Getting Assertion when running running Inner Merge Join Key: TEIID-1899 URL: https://issues.jboss.org/browse/TEIID-1899 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4.1 Reporter: Van Halbert Assignee: Steven Hawkins When running the following query, it causing an ASSERTION (see attached log): SELECT COUNT(*) AS CNT FROM (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-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL < 9514.5)) AS T Note: this doesn't fail when SELECT COUNT(*) is 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

11 years, 9 months

5
19
0 / 0

[JBoss JIRA] Created: (TEIID-1328) API request: Programatically modify the VDB

by Mark Addleman (JIRA)

API request: Programatically modify the VDB -------------------------------------------- Key: TEIID-1328 URL: https://jira.jboss.org/browse/TEIID-1328 Project: Teiid Issue Type: Feature Request Components: AdminApi Affects Versions: 7.1 Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Minor I'd like an API to programatically modify the VDB. It would be ideal to modify the VDB using DDL through Teiid. Our primary use case is accessing a dynamic set of datasources through Teiid. When a datasource is added, we would INSERT the appropriate entries into MODEL, PROPERTIES, DATASOURCES tables. Teiid would reread the appropriate metadata from the associated translators. -- 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

11 years, 11 months

6
35
0 / 0

[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

11 years, 11 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

11 years, 11 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

11 years, 11 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

11 years, 11 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

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

3
4
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2012