How to set the transaction timeout? We have some long running queries that will run in SEQUENCE(one after the other) and from time to time, the server will thow exceptions saying the transaction has been "aborted" when it try to get a managed connection... 
Modelling a Json entitty with array of "details" Dear Sirs, Perhaps one more novice question. I am still trying to get by Spring Boot/REST data source example work. The json return by my WS is this: { "recordsFiltered": 10, ... 
How to send the URI parameters to the REST web service via Teiid Spring Boot? My REST web service requires a couple of URI-embedded parameters. I was assuming (probably wrongly) that the query parameter will be embedded by Teiid into the Web service call as a URL parameter, but my DEBUG... Teiid connection timeout, only 2 connection in use - ARJUNA012117: TransactionReaper::check timeout We are trying to connect local db instances. we have user xa data-source for this. for small transaction it is working fine. but for large transaction > 1min. it gives ARJUNA012117: TransactionReaper::check timeout... 
Howto do efficent fulltext search in Teiid Hello together, I am trying to implement a full text search with Teiid, preferable in a materialized table. I have a mysql database below Teiid which supports FULLTEXT indexes which are used with a MATCH ... AGAINST ... 
Teiid exception handling Hello together, I am currently trying to understand how to deal with exception handling and would like to ask for some advice as it seems I do not get exceptions from the underlaying datasource forwarded. Here is an... Teiid exception, when setautocommit is false "TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000457" I am using teiid two datasources. when I set "setAutocommit=true" is work fine. But when I set "setAutocommit=false" is gives below error. ERROR c.b.t.d.i.b.DataCloningService.error(38) - TEIID30504 Remote org... Teiid Web Console with Wildfly and Teiid 12.2.0 Hello together, I am trying to add the Teiid Wildfly console to my docker image. I follow the docker file from Ramesh at teiid/Dockerfile at master · jboss-dockerfiles/teiid · GitHub and a... Teiid standalone stop client threads We have a web application deployed over Tomcat and it is using AdminAPI to administrate Teiid Standalone. Whenever we stop the web application, we are not able to terminate the threads created by Teiid client.... 
Error fetching materialized view on SQL Server We have a view materialized in SQL Server and reading from Oracle. In Oracle we have a column of type Number(38,0) which is considered a BigInteger in Teiid. So we created it of type BigInt in the materialized table ... Documentation Teiid Spring Boot annotations Hello, Could someone please kindly post a link to documentation for all Teiid Spring boot annotations? In particular, I am struggling to understand usage of "@RestConfiguration" annotation. One... Apparent bean collision Teiid/ Spring Boot Hello, I am new to Teiid, trying to integrate it into myApring Boot application and face the following issue: during application startup I get the following error signalling an apparent bean collision ... How do you get the query engine to push down a where clause when view has UNION ALL I have the following view CREATE VIEW PartMarriage ( src VARCHAR(6), --This is an inline comment in DDL metadata marriageType VARCHAR(6), masterSerialNo VAR... 
teiid 12.2.0 standalone-teiid.xml urn:jboss:domain:5.0 Hi, I was just comparing the wildfly 15 standalone.xml file with the one in teiid 12.2.0. The <server xmlns="urn:jboss:domain:5.0"> contains a reference to version 5 there. Is this an issue since in Wild... 
Granting Row Constraints in Teiid for CUD operations, hence except READ Hello together, I am trying to create a fine grained access priviledge for the following table: CREATE FOREIGN TABLE UserDefinedProducts ( fkProduct long NOT NULL OPTIONS(NAMEINSOURC... I am getting ModuleNotFoundException: com.oracle.ojdbc:main I have below configurations but still i see error. standalone.xml: <driver name="oracle" module="com.oracle.jdbc"> ... 
Cassandra table names case sensitivity we are querying Cassandra through Teiid and we are having the following error when the table name contains upper case characters. com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table cassandr... Use of JSONOPBJECT and JSONARRAY_AGG (TEIID30345 The command of this scalar subquery returned more than one value) I have a request to show Parent / Child information that could have multiple rows in the Parent tables and multiple rows in the child tables within a subquery. I attempted the following use of JSONOPBJE... 
Connecting CloudSQL via Teiid in SSL mode Hi, I am trying to connect to cloudSQL instance via teiid in SSL mode. Google is providing me three files for connection , 1. client-cert.pem( client certificate file) 2. &... 
How to pull master and details in a single json file I would like to pull the json data using Teiid JDV like the following {"college":"Department", "resultList":[{"id":"01","name":"Math"},{"id":"02","name":"Chemistry"}],"errorMsg":"No Error"} any sampl... 
Log in to follow, share, and participate in this community.