Teiid queries not never releasing the memory from heap resulting Garbage collection failures We have a federated VDB with a Views made from attributes from multiple Oracle data sources. The View results in 2 million records and it involves joining tables with 2 million records from two different data sources(... 
Forum Going Read-Only This forum will shortly be read-only. Please create new topics on StackOverflow. For now we'll just use the teiid tag for all topics. 
Teiid standalone - SQL Server insert into error We are encountering an error when using insert into select under SQL Server. The source table and the destination table are from 2 different databases under the same SQL Server. The exception is reproduced in the me... 
Teiid: How convert the existing vdb to DDL? Hi All, I am new to JDV development and I appreciate your help to learn and grow. 1. How to convert the exisiting vdb to ddl? (any steps in JBOSS TEIID environment)? 2. How to include it Spring Boot a... 
How to get metadata for View in db? Hi, All Can you help me with teiid-spring-boot and teiid-odata? 1. We have vertica db and jdbc connection for it. 2. teiid-spring-boot project with teiid-odata How we can get metadata for vertica Views? No... 
Teiid 12.2 dockerized unable to connect to mongodb instance on Atlas Hi, I'm back on Teiid since a long time, and now trying to deploy a wildfly server on docker with teiid 12.2 and the latest web console. Everything works quite smoothly: I can configure a mongodb RA c... 
create XA datasource for hive Hi, I am using teiid admin api 10.x . I need to setup connection with hive using XA datasource, Can you add an example how to connect with hive using xa datasource. Thanks, Kulbhushan Chaskar 
Access return header invokeHttp For a REST web service I want to consume I want to use pagination. However, for this specific web service this data is provided with by the return header. Is there someway to access this information using invokeHttp? ... 
Support for OData complex types? How can we provide/implement our own complex types when exposing an OData API from Teiid? For example, if I have a Postgresql table which has two underlying column names "PUBLISH_DATE_START" and "PUBLISH_DATE_... 
How to execute a virtual procedure from PHP? Hi, I'm trying to run a script enclosed within a BEGIN and END block from PHP. I'm using the pg_* functions to do this. I've also tried the odbc_* functions which result in the same error. pg_query for... 
How to fetch column data by table names from VDB using Teiid java api. I need to fetch columns of any particular tables by table name. I couldn't find any method in java documentation. Could you please suggest me any java method or any other solution to get column metadata? 
Teiid Error VDB Mysql <brCREATE VIEW tbl_permissions ( id string, slug timestamp, name string ) AS SELECT A.id, A.slug, C.name FROM Accounts.tbl_permissions A; ]]> This is error when trying to connect with Mysql VDB ... 
Teiid Spring Boot - JDBC connection? Hi Guys, After implementing a solution that has worked for us for a bit more than a year using Teiid Designer & Teiid on wildfly, I am thinking about updating said application. I am inclined to go with the Teiid... 
Does teiid-engine-9.1.1 jar required proj4j-0.1.0 Hi Team , We are using teiid-engine-9.1.1 jar in one of my project and we are getting the proj4j-0.1.0 jar as a dependency in my project. Does teiid-runtime-9.1.1 required proj4j-0.1.0 jar ?. Someone can help... 
Dynamic Datasource Hi, I have a requirement to add datasource that needs to keep updating if any new table is creating or table modified in source database. Basically they want this VDB to be a gateway for multiple datasource each of ... 
Beetle Studio Is beetle Studio still actively in development? And is it the strategic tooling for building VDB replacing Teiid designer? Thanks 
How to connect to json data file using ftp or sftp connection using teiid We need to query json data file kept at any location so can you please help us, how to connect to json file using teiid. To connect to text,csv file we were using HXTT driver but using HXTT driver we are unabl... 
TEIID request is getting terminated I am trying to insert larget number of records in Mysql database via TEIID and my request is getting cancelled. Below is a complete stacktrace. The request gets cancelled after inserting 5-7 Lakh records in sing... Does Teiid MongoDb has Pushdown Query capability Hi I am trying Teiid to query MongoDb, the data base has 1.5M document but with indexes. My query took a long time to return data even with accessing by indexed key fields. Teiid seems to retrieve all data from DB and... 
How to change Teiid ports We have an issue on running Teiid docker server which use port 8080 as http service port, but another application service already using it. How can we change Teiid to listening at different port for http service? or h...
Log in to follow, share, and participate in this community.