CLOB data typeHi , If i create a VDB on top of Oracle DB having geometry data type. Would it be possible to fetch the data of this column by connecting to this VDB through teiid JDBC driver ? If yes what will be type ...
Issue using salesforce-34 apiHi, I am currently evaluating teiid and I am really excited. But now I have a strange issue. Maybe realted to https://developer.jboss.org/thread/263098 and [TEIID-3981] Salesforce-34 connector dependency on "com.forc...
Thread Group By and FORMATTIMESTAMP not translated
Group By and FORMATTIMESTAMP not translatedHi all, I am now trying to translate the below SQL to DB2 SQL. But seems the Group By clause and FORMATTIMESTAMP function was not translated successfully. Could you please help to check and guide what...
Teiid XML functions performanceI have a Teiid view definition where I use XML table to produce tabular output. My view definition is listed below: <metadata type="DDL">
...
Slow down when fetching large result setsThis issue was observed using an embedded Teiid server in version 8.13.2. It was triggered by bad sqoop performance, but can be reproduced directly with JDBC. An HSQL table is defined in the VDB. The tableR...
Thread Unable to import data services using Data Services Builder - Web UI
Unable to import data services using Data Services Builder - Web UIHello, I have setup Data Services Builder - Web UI to take a look at it but when i invoke http://localhost:8080/vdb-bench URL, getting an error "The host “http://localhost:8080/vdb-builder/v1' is no...
Thread Materialized view - Expected long, but was bigdecimal
Materialized view - Expected long, but was bigdecimalI'm using Teiid 9.0.0 Final i'm materializing a view on Oracle that contains a column using TIMESTAMPDIFF and the corresponding column in the materialized view is of type NUMBER(10) The materialization is done succe...
Thread Criteria on columns of different data types
Criteria on columns of different data typesSince we migrated to Teiid 9.0.0, we started to get errors whenever we have criterias comparing fields of different data types, varchar and integer for example. Those cases use to pass in teiid earlier version...
Thread Function in ORDER BY clause not being passed through to datamanager
Function in ORDER BY clause not being passed through to datamanagerGood day, We are using the Teiid embedded server with a VDB XML file. I have a HSQL DB with two custom functions defined. My VDB file defines the functions as follows: CREATE FOREIGN FUNCTION XSCORE()&...
Need to setup XA datasourceHi , I need to set-up XA-datasource using teiid adminapi. Currently we are creating non-xa datasource. Can we create using admin api ? What all properties specifically we need to set for creating XA-Dat...
Thread Facing issues while executing queries through teiid
Facing issues while executing queries through teiidHi , There are two issues I am facing. 1) Created one table on SQLServer though JDBC with ID column set as IDENTITY. CREATE TABLE Persons (ID int IDENTITY(1,1) PRIMARY KEY, LastName varchar(255)...
parsing json response having jsonarrI am having a json structure like { response:{ docs:[{ test1:"SOME_VALUE1", test2:"SOME_VALUE2" }, { test1:"SOME_VALUE3", test2:"SOME_VALUE4" } } I am using the following Create VIEW TestView (...