June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2709) Quickstart - drools-integration uses drools 5 instead of drools 6

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2709?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2709: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1022650|https://bugzilla.redhat.com/show_bug.cgi?id=1022650] from ON_QA to VERIFIED > Quickstart - drools-integration uses drools 5 instead of drools 6 > ------------------------------------------------------------------- > > Key: TEIID-2709 > URL: https://issues.jboss.org/browse/TEIID-2709 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > > The drools-integration quick start uses drools 5, instead of drools 6. > And its not a matter of swapping out the versions due to api changes drools 6. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3617) Provide an option to Limit per user based connections

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3617?page=com.atlassian.jira.plugin... ] Kylin Soong reassigned TEIID-3617: ---------------------------------- Assignee: Kylin Soong (was: Steven Hawkins) > Provide an option to Limit per user based connections > ----------------------------------------------------- > > Key: TEIID-3617 > URL: https://issues.jboss.org/browse/TEIID-3617 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Xian Liu > Assignee: Kylin Soong > Fix For: 9.1 > > > we deploy teiid for users to get data, but some users will create many connections to teiid and they are not necessary, I need to find a good way to limit each user account can only get like 50 connections or so -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4268) Add OAuth JWT documentation

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4268?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4268. --------------------------------- Resolution: Done For 8.12 I added at https://docs.jboss.org/author/display/teiid812final/Salesforce+Data+Sources https://docs.jboss.org/author/display/teiid812final/Data+Source+Security For 9.1 https://teiid.gitbooks.io/documents/content/admin/Salesforce_Data_Sources... https://teiid.gitbooks.io/documents/content/security/Data_Source_Security... > Add OAuth JWT documentation > --------------------------- > > Key: TEIID-4268 > URL: https://issues.jboss.org/browse/TEIID-4268 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.1, 8.12.5 > > > Move the docs from JIRA here https://issues.jboss.org/browse/TEIID-3618 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4238: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1347847 Bugzilla Update: Perform > Remove need for quotes around cursor name declarations/fetches > -------------------------------------------------------------- > > Key: TEIID-4238 > URL: https://issues.jboss.org/browse/TEIID-4238 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1 > > > Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur. > [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" at line 1, column 1. > Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4245: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1347841 Bugzilla Update: Perform > Add support for fetch syntax "FETCH cursorname" > ----------------------------------------------- > > Key: TEIID-4245 > URL: https://issues.jboss.org/browse/TEIID-4245 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1 > > > Executing syntax "FETCH cursorname" results in parsing error like [1]. Instead, syntax like "FETCH 1 IN cursorname" has been used as a workaround. > [1] > org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]FETCH[*] mycursor" at line 1, column 1. > Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4264) PI: Verify the connectivity with PI Server

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4264?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4264. --------------------------------- Fix Version/s: 9.1 Resolution: Done I installed PI database in AWS on Windows 2012 server and was able to successfully connect to PI from Windows based Teiid Server. I had issues connecting from Linux based Teiid server to the Windows based PI server, as this uses HTTPS/SOAP and I have not resolved the issue. The documentation is at https://teiid.gitbooks.io/documents/content/reference/OSISoft_PI_Translat... > PI: Verify the connectivity with PI Server > ------------------------------------------ > > Key: TEIID-4264 > URL: https://issues.jboss.org/browse/TEIID-4264 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Affects Versions: 8.12 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.1 > > > Verify > * connectivity > * metadata import > * query execution -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4187) Extend support for PI OLEDB Enterprise Queries in OSI PI Translator

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4187?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4187. --------------------------------- Fix Version/s: 9.1 Resolution: Done All the requested features are implemented > Extend support for PI OLEDB Enterprise Queries in OSI PI Translator > ------------------------------------------------------------------- > > Key: TEIID-4187 > URL: https://issues.jboss.org/browse/TEIID-4187 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.13.3 > Reporter: Al S > Assignee: Ramesh Reddy > Priority: Minor > Fix For: 9.1 > > Attachments: PI-OLEDB-Enterprise-2012-User-Guide.pdf > > > Background - PI OLEDB queries go against the PI Data Archive whereas PI OLEDB Enterprise go against PI AF, which is a metadata layer that sits atop the PI Data Archive. Both sets of queries are now accessible from the PI JDBC adapter. > Please add the following enhancements to allow the OSI PI translator to work more effectively with OLEDB Enterprise queries. > 1) Import table valued functions as Teiid procedures > 2) Allow the pushdown of nested table joins > 3) Update the PI translator to use the CROSS APPLY syntax. > 4) When importing schemas, importer.ImportKeys has to be set to false as otherwise we receive a DuplicateRecord exception since the table value function ft_GetPIPoint appears in more than one place in the AF schemas. Could we please put in a fix/workaround to address this? > Please refer to the OLEDB Enterprise Guide for query syntax and rules for more detail. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4278) MySQL 5.5 should support distinct aggregates

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4278: ------------------------------------- Summary: MySQL 5.5 should support distinct aggregates Key: TEIID-4278 URL: https://issues.jboss.org/browse/TEIID-4278 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 Older versions of mysql only supported distinct count, but later versions supported distinct with all relevant aggregates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4277) Infinispan Cache DSL translator: materialization incomplete results during view's loading

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4277?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4277: ------------------------------------ I'm looking. If the read and write are using the same cache, then there's a timing issue with the swapping of the alias caches. > Infinispan Cache DSL translator: materialization incomplete results during view's loading > ----------------------------------------------------------------------------------------- > > Key: TEIID-4277 > URL: https://issues.jboss.org/browse/TEIID-4277 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Van Halbert > Priority: Blocker > Attachments: test.log > > > When user tries to query materialized view in a moment when its loading is in progress, incomplete results are returned. The status of the view in corresponding status table is LOADING. > Vdb used: > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="jdg-remote" version="1"> > <description>For testing of materialized views</description> > <property name ="lib" value ="org.jboss.qe.jdg.pojos"></property> > <model name="jdgSource"> > <source name="jdgSource" translator-name="jdg-override" > connection-jndi-name="java:/jdg-mat-ds" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE CustomerReport( > customerId integer not null OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'int'), > totalAmount integer, > CONSTRAINT PK_ID PRIMARY KEY(customerId) > ) OPTIONS (NAMEINSOURCE '${db.table.prefix}jdg-mat', UPDATABLE TRUE);]]> > </metadata> > </model> > <model name="h2Source"> > <source name="h2Source" translator-name="h2" connection-jndi-name="java:/h2-ds" /> > </model> > <model name="View" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW external_long_ttl ( > customerId integer NOT NULL, > totalAmount integer > ) OPTIONS (MATERIALIZED 'TRUE', > MATERIALIZED_TABLE 'jdgSource.CustomerReport', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO jdgSource.CustomerReport(customerId,totalAmount) SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_STATUS_TABLE" 'h2Source.DB.PUBLIC.DV_MATVIEWS_STATUSTABLE', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute jdgSource.native(''truncate cache'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute jdgSource.native(''swap cache names'');', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT', > "teiid_rel:MATVIEW_TTL" 10000 > ) > AS SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id; > ]]> > </metadata> > </model> > <translator name="jdg-override" type="infinispan-cache-dsl"> > <property name="SupportsDirectQueryProcedure" value="true" /> > </translator> > </vdb> > {code} > Resource-adapter used: > {code:xml} > <resource-adapter id="jdg-mat"> > <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/jdg-mat-ds" enabled="true" pool-name="jdg-mat"> > <config-property name="ProtobufDefinitionFile"> > /org/jboss/qe/jdg/remote/protobuf/CustomerReport.proto > </config-property> > <config-property name="AliasCacheName"> > ${db.table.prefix}jdg-alias > </config-property> > <config-property name="MessageMarshallers"> > org.jboss.qe.jdg.pojo.CustomerReport:org.jboss.qe.jdg.remote.marshaller.CustomerReportMarshaller > </config-property> > <config-property name="RemoteServerList"> > [remote-server-address]:11322 > </config-property> > <config-property name="StagingCacheName"> > ${db.table.prefix}jdg-mat-stage > </config-property> > <config-property name="CacheTypeMap"> > ${db.table.prefix}jdg-mat:org.jboss.qe.jdg.pojo.CustomerReport;customerId > </config-property> > <config-property name="MessageDescriptor"> > org.jboss.qe.jdg.remote.protobuf.CustomerReport > </config-property> > <config-property name="Module"> > org.jboss.qe.jdg.pojos > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > Datasource used (tables that the view queries): > {code:xml} > <xa-datasource jndi-name="java:/h2-ds" pool-name="h2-xa-ds" enabled="true"> > <xa-datasource-property name="URL"> > jdbc:h2:tcp://localhost:9292/db;TRACE_LEVEL_FILE=4 > </xa-datasource-property> > <driver>h2</driver> > <security> > <user-name>sa</user-name> > </security> > </xa-datasource> > {code} > Query invoked to check current contents of materialized view: > {code:sql} > SELECT COUNT(*) FROM external_long_ttl; > {code} > And expected result is the same as count of DV_MATVIEWS_CUSTOMERS table from source h2Source. In my case 10. > But when I print out the result I get all numbers from 0 to 10 . See attached log output (search for 'check-count:') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4277) Infinispan Cache DSL translator: materialization incomplete results during view's loading

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4277?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-4277: ------------------------------------- Assignee: Van Halbert (was: Steven Hawkins) This looks to be specific to JDG as I'm seeing the appropriate behavior on other sources and all of the cardinalities shown in the log for the status update are 10. This could be due to not using a transaction to perform the read access and getting some form of weakly consistent results. [~vhalbert2] can you take a look? > Infinispan Cache DSL translator: materialization incomplete results during view's loading > ----------------------------------------------------------------------------------------- > > Key: TEIID-4277 > URL: https://issues.jboss.org/browse/TEIID-4277 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Van Halbert > Priority: Blocker > Attachments: test.log > > > When user tries to query materialized view in a moment when its loading is in progress, incomplete results are returned. The status of the view in corresponding status table is LOADING. > Vdb used: > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="jdg-remote" version="1"> > <description>For testing of materialized views</description> > <property name ="lib" value ="org.jboss.qe.jdg.pojos"></property> > <model name="jdgSource"> > <source name="jdgSource" translator-name="jdg-override" > connection-jndi-name="java:/jdg-mat-ds" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE CustomerReport( > customerId integer not null OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'int'), > totalAmount integer, > CONSTRAINT PK_ID PRIMARY KEY(customerId) > ) OPTIONS (NAMEINSOURCE '${db.table.prefix}jdg-mat', UPDATABLE TRUE);]]> > </metadata> > </model> > <model name="h2Source"> > <source name="h2Source" translator-name="h2" connection-jndi-name="java:/h2-ds" /> > </model> > <model name="View" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW external_long_ttl ( > customerId integer NOT NULL, > totalAmount integer > ) OPTIONS (MATERIALIZED 'TRUE', > MATERIALIZED_TABLE 'jdgSource.CustomerReport', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO jdgSource.CustomerReport(customerId,totalAmount) SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_STATUS_TABLE" 'h2Source.DB.PUBLIC.DV_MATVIEWS_STATUSTABLE', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute jdgSource.native(''truncate cache'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute jdgSource.native(''swap cache names'');', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT', > "teiid_rel:MATVIEW_TTL" 10000 > ) > AS SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id; > ]]> > </metadata> > </model> > <translator name="jdg-override" type="infinispan-cache-dsl"> > <property name="SupportsDirectQueryProcedure" value="true" /> > </translator> > </vdb> > {code} > Resource-adapter used: > {code:xml} > <resource-adapter id="jdg-mat"> > <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/jdg-mat-ds" enabled="true" pool-name="jdg-mat"> > <config-property name="ProtobufDefinitionFile"> > /org/jboss/qe/jdg/remote/protobuf/CustomerReport.proto > </config-property> > <config-property name="AliasCacheName"> > ${db.table.prefix}jdg-alias > </config-property> > <config-property name="MessageMarshallers"> > org.jboss.qe.jdg.pojo.CustomerReport:org.jboss.qe.jdg.remote.marshaller.CustomerReportMarshaller > </config-property> > <config-property name="RemoteServerList"> > [remote-server-address]:11322 > </config-property> > <config-property name="StagingCacheName"> > ${db.table.prefix}jdg-mat-stage > </config-property> > <config-property name="CacheTypeMap"> > ${db.table.prefix}jdg-mat:org.jboss.qe.jdg.pojo.CustomerReport;customerId > </config-property> > <config-property name="MessageDescriptor"> > org.jboss.qe.jdg.remote.protobuf.CustomerReport > </config-property> > <config-property name="Module"> > org.jboss.qe.jdg.pojos > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > Datasource used (tables that the view queries): > {code:xml} > <xa-datasource jndi-name="java:/h2-ds" pool-name="h2-xa-ds" enabled="true"> > <xa-datasource-property name="URL"> > jdbc:h2:tcp://localhost:9292/db;TRACE_LEVEL_FILE=4 > </xa-datasource-property> > <driver>h2</driver> > <security> > <user-name>sa</user-name> > </security> > </xa-datasource> > {code} > Query invoked to check current contents of materialized view: > {code:sql} > SELECT COUNT(*) FROM external_long_ttl; > {code} > And expected result is the same as count of DV_MATVIEWS_CUSTOMERS table from source h2Source. In my case 10. > But when I print out the result I get all numbers from 0 to 10 . See attached log output (search for 'check-count:') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016