August 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3609) Teiid Connection import: driver field not populated for resource adapters

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3609?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3609. --------------------------------- Assignee: Ramesh Reddy Resolution: Rejected None of below configuration as is wrong, they all work, but it does change the default behavior with the tools. The issue is a given "resource-adpater" does let you define multiple connection-definitions. However, every time you add or delete a connection-definition to the resource-adapater, the server needs to be restarted. That how EAP's JCA sub-system is designed. Now, in Teiid it is very common to have different sources, adding and removing is quite a normal. However, restart each time is not accepted. So, the workaround that has been used is - use empty resource-adapter definition as "driver" definition to enable data source template definition through Admin API - Use a duplicated resource-definition with UNIQUE name and ONE connection-definition for every connection definition. This way server does not need to be restarted when a connection definition is added to the resource-adapter. > Teiid Connection import: driver field not populated for resource adapters > ------------------------------------------------------------------------- > > Key: TEIID-3609 > URL: https://issues.jboss.org/browse/TEIID-3609 > Project: Teiid > Issue Type: Bug > Reporter: Andrej Šmigala > Assignee: Ramesh Reddy > > When importing using Teiid Connection, the driver field is not populated for resource adapters when the pool name of the connection definition is the same as the id of the resource adapter itself. Except for the case that there is _another_ resource adapter defined for the same module _without_ any connection definitions. > In other words, when the following is included in standalone.xml, the driver field is not populated > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/file" enabled="true" pool-name="file"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > However, everything works as expected when the configuration is changed to this: > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/fileDS" enabled="true" pool-name="fileDS"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > Or this: > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > </resource-adapter> > <resource-adapter id="fileDS"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/fileDS" enabled="true" pool-name="fileDS"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > This might be related to TEIIDDES-1895 and is most likely the original cause of TEIIDDES-2563. > Clicking Next in the import wizard when such a datasource is selected causes the same error as described in TEIIDDES-2563. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3609) Teiid Connection import: driver field not populated for resource adapters

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIID-3609?page=com.atlassian.jira.plugin... ] Barry LaFond commented on TEIID-3609: ------------------------------------- Teiid Designer has a forked version of the AdminFactoryImpl. The method that's removing the resource-adapter, and hence not finding any driver/properties in Designer is in question. getResourceAdapterNames() is used to return property sets for deployed Data Sources. If user configures a resource adapter to use a pool name/JNDI name which is one of the names of the resource-adapters, it'll remove the name and hence not return any driver properties. {code} // :read-children-names(child-type=deployment) private Set<String> getResourceAdapterNames() throws AdminException { Set<String> templates = getDeployedResourceAdaptorNames(); templates.addAll(getInstalledResourceAdaptorNames()); //AS-4776 HACK - BEGIN Map<String, String> connFactoryMap = getConnectionFactoryNames(); for (String key:connFactoryMap.keySet()) { templates.remove(key); } //AS-4776 HACK - END return templates; } {code} > Teiid Connection import: driver field not populated for resource adapters > ------------------------------------------------------------------------- > > Key: TEIID-3609 > URL: https://issues.jboss.org/browse/TEIID-3609 > Project: Teiid > Issue Type: Bug > Reporter: Andrej Šmigala > > When importing using Teiid Connection, the driver field is not populated for resource adapters when the pool name of the connection definition is the same as the id of the resource adapter itself. Except for the case that there is _another_ resource adapter defined for the same module _without_ any connection definitions. > In other words, when the following is included in standalone.xml, the driver field is not populated > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/file" enabled="true" pool-name="file"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > However, everything works as expected when the configuration is changed to this: > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/fileDS" enabled="true" pool-name="fileDS"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > Or this: > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > </resource-adapter> > <resource-adapter id="fileDS"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/fileDS" enabled="true" pool-name="fileDS"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > This might be related to TEIIDDES-1895 and is most likely the original cause of TEIIDDES-2563. > Clicking Next in the import wizard when such a datasource is selected causes the same error as described in TEIIDDES-2563. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3609) Teiid Connection import: driver field not populated for resource adapters

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIID-3609?page=com.atlassian.jira.plugin... ] Barry LaFond moved TEIIDDES-2582 to TEIID-3609: ----------------------------------------------- Project: Teiid (was: Teiid Designer) Key: TEIID-3609 (was: TEIIDDES-2582) Affects Version/s: (was: 9.0.2) Component/s: (was: Teiid Integration) (was: Import/Export) > Teiid Connection import: driver field not populated for resource adapters > ------------------------------------------------------------------------- > > Key: TEIID-3609 > URL: https://issues.jboss.org/browse/TEIID-3609 > Project: Teiid > Issue Type: Bug > Reporter: Andrej Šmigala > > When importing using Teiid Connection, the driver field is not populated for resource adapters when the pool name of the connection definition is the same as the id of the resource adapter itself. Except for the case that there is _another_ resource adapter defined for the same module _without_ any connection definitions. > In other words, when the following is included in standalone.xml, the driver field is not populated > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/file" enabled="true" pool-name="file"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > However, everything works as expected when the configuration is changed to this: > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/fileDS" enabled="true" pool-name="fileDS"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > Or this: > {code:xml} > <resource-adapter id="file"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > </resource-adapter> > <resource-adapter id="fileDS"> > <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/fileDS" enabled="true" pool-name="fileDS"> > <config-property name="ParentDirectory"> > /home/ > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > This might be related to TEIIDDES-1895 and is most likely the original cause of TEIIDDES-2563. > Clicking Next in the import wizard when such a datasource is selected causes the same error as described in TEIIDDES-2563. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3608) Add a translator for memcached

by Kylin Soong (JIRA)

Kylin Soong created TEIID-3608: ---------------------------------- Summary: Add a translator for memcached Key: TEIID-3608 URL: https://issues.jboss.org/browse/TEIID-3608 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 8.12 Reporter: Kylin Soong Fix For: 9.x memcached can be thought as a standard in Cache area, there are lots of product support memcached, like: * Infinispan/JBoss Data Grid * Redis * Oracle Coherence * Cassandra * ... If we have a memcached translator, it will more flexible in intergrate/transfer data from cache product. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3607) Teiid Model import does not gather statistics when "Import Statistics = true"

by Tom Johnston (JIRA)

Tom Johnston created TEIID-3607: ----------------------------------- Summary: Teiid Model import does not gather statistics when "Import Statistics = true" Key: TEIID-3607 URL: https://issues.jboss.org/browse/TEIID-3607 Project: Teiid Issue Type: Bug Reporter: Tom Johnston Assignee: Steven Hawkins I imported using a Teiid Connection and set the Import Statistics property as true. ALL cardinality values resulted in -1. Also I saw no way to "Modeling--> Update data source statistics" on this model. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3606) TeiiD model import doesnt support UPATE

by Tom Johnston (JIRA)

Tom Johnston created TEIID-3606: ----------------------------------- Summary: TeiiD model import doesnt support UPATE Key: TEIID-3606 URL: https://issues.jboss.org/browse/TEIID-3606 Project: Teiid Issue Type: Feature Request Reporter: Tom Johnston Assignee: Steven Hawkins I imported a Teiid Model connection but saw no way to update the model. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3605) Relax hard coded restriction on accessnode parallelism

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3605?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3605. ----------------------------------- Resolution: Done Changed the logic to use effectively use 1/2 the user concurrent max if it is greater than 10. > Relax hard coded restriction on accessnode parallelism > ------------------------------------------------------ > > Key: TEIID-3605 > URL: https://issues.jboss.org/browse/TEIID-3605 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > There is currently a hard coded maximum of 10 parallel queries in the access node. This should be allowed to be higher either by direct configuration or just allowing the concurrent max to suffice. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3605) Relax hard coded restriction on accessnode parallelism

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3605: ------------------------------------- Summary: Relax hard coded restriction on accessnode parallelism Key: TEIID-3605 URL: https://issues.jboss.org/browse/TEIID-3605 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.12 There is currently a hard coded maximum of 10 parallel queries in the access node. This should be allowed to be higher either by direct configuration or just allowing the concurrent max to suffice. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3520) Extend the Swagger support in the WS Translator

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3520?page=com.atlassian.jira.plugin... ] Kylin Soong reassigned TEIID-3520: ---------------------------------- Assignee: Kylin Soong > Extend the Swagger support in the WS Translator > ----------------------------------------------- > > Key: TEIID-3520 > URL: https://issues.jboss.org/browse/TEIID-3520 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Kylin Soong > Fix For: 8.12 > > > http://swagger.io is popular REST service description framework, it defines a specification http://swagger.io/specification/ for REST service definition. > Teiid WS translator should add the ability to read this file (like WSDL) and provide the REST methods as endpoints that can be consumed from Teiid. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3580?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3580. ----------------------------------- Resolution: Migrated to another ITS See https://issues.apache.org/jira/browse/HIVE-11454 > Hive 0.13.1 JDBC jars makes queries run slow > -------------------------------------------- > > Key: TEIID-3580 > URL: https://issues.jboss.org/browse/TEIID-3580 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.3 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: threaddump-1437508266001.tdump > > > When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return. > The Hive JDBC jars for version 0.13.1 can be found here : > https://github.com/vchintal/hive-jdbc-jars-archive > Alternatively a ready-to-go modules can be downloaded from here for testing: > https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/ > Use the following driver snippet when using the above mentioned module: > <driver name="hive" module="org.apache.hadoop.hive:0.13.1"> > <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class> > </driver> -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2015