Teiid is a data virtualization system by JBoss that allows applications to use data from multiple, heterogenous data stores.
Teiid is a data virtualization system by JBoss that allows applications to use data from multiple, heterogenous data stores.
Questions tagged [teiid]
158 questions
0
votes
2 answers
Error building Source for context item. org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 57; Content is not allowed in prolog
I am trying parse XML from invokeHTTP method that is returned in utf-16 encoding specified in the response.
I have tried below but I am still cannot get past this error
select request.* from (EXEC model.invokeHttp(action => 'POST', endpoint =>…
ASAFDAR
- 19
- 1
- 7
0
votes
1 answer
Teiid wildlfy - Table column encrypt/decrypt
I am using teiid-wildfly server odata4 services to perform CRUD operations. I need to store some of the table fields in encrypted format. Could be possible for configure teiid security functions(AES_ENCRYPT) in vbd.xml file to perform encryption…
AMITESH
- 5
- 2
0
votes
1 answer
Teiid User Defined Java Functions not visible
I am using teiid-wildfly servers. I followed the user defined functions example provided in teiid documentation. Below is my vdb file. Please let me know if I need to import any additional properties to view/access user defined functions. …
AMITESH
- 5
- 2
0
votes
1 answer
How to set max-source-rows-allowed Teiid Springboot
While scouting the documentation we found the following properties that we want to set.
max-source-rows-allowed
exception-on-max-source-rows
Found on the following…
Kusters
- 28
- 1
0
votes
1 answer
Teiid 2-way SSL- connection successful even without the Truststore
I have a teiid embedded server and I am trying to connect to a vds on that server through 2-way SSL from my remote client by passing the teiid SSL properties in SystemProperties as per the teiid documentation at:…
M S
- 1
- 1
0
votes
1 answer
Removing Invalid Characters from JSON response in TEIID
I have a json response generated from invokeHTTP function and then passing it to materialized view. Apparently there is control character embedded in the response. When converting to XMLTABLE I get below error:
at…
ASAFDAR
- 19
- 1
- 7
0
votes
1 answer
Teiid Client side SSL settings in System properties not working as expected
I have a teiid embedded server and I am trying to connect to a vds on that server through SSL from my remote client by passing the teiid SSL properties in SystemProperties as per the teiid documentation at:…
M S
- 1
- 1
0
votes
1 answer
Passing Comma Separated List to Function with VARIDIAC parameter as input
I have a user defined function that takes a VARIADIC parameter as an input:
func(name string, VARIADIC values double) returns Blob
Example: select func('abc', 35.2,35.3,35.5)
How can I pass row based float/double values to comma separated double…
ASAFDAR
- 19
- 1
- 7
0
votes
1 answer
Teiid 15 - Query planner seems to incorrectly optimize the query with inner joins
We have a custom translator written that extends the SQLServerExecutionFactory, since Teiid 9.1. We have overridden the following translator capabilities to avoid push down of these cases.
supportsUnions=false; …
0
votes
2 answers
Teiid not performing optimal join
For our Teiid Springboot project we use a row filter in a where clause to determine what results a user gets.
Example:
SELECT * FROM very_large_table WHERE id IN ('01', '03')
We want the context in the IN clause to be dynamic like so:
SELECT * FROM…
Kusters
- 28
- 1
0
votes
1 answer
Executing select with sub queries return null pointer exception in Teiid 12.x
We just upgraded Teiid from 9.1 to Teiid 12.0.2. In Teiid 9.1 we used to run select queries with lierals and subqueries like
insert into tableA(organization,empname,dept) values('ORG-X',(select emp_name from employee where emp_id='1'),'DIVISION-Y')…
0
votes
1 answer
Teiid Springboot security context in DDL
In our Teiid Springboot project we have Spring Security enabled which has roles in it. E.g. GrantedAuthorities.
How can use/read those roles into a DDL VDB? Is there a Teiid function to read those roles or do we have to create our own UDF?
Kusters
- 28
- 1
0
votes
1 answer
Teiid Springboot starter file datasource
Using Teiid Springboot I would like to consume xml files from disk. I used to work with the old EAP/Wildfly Teiid project and the way to solve this was to use a resource adapter and then call a procedure to read the data.
With Springboot what steps…
Kusters
- 28
- 1
0
votes
1 answer
How to get connection pool statistics from Teiid resource adapter?
I have resource adapter in wildfly-teiid-server with xml
3draven
- 31
- 4
0
votes
1 answer
TEIID Importing ddl into vdb ddl
Currently my VDB DDL file is getting quite big. I want to split into different files using the following.
IMPORT FROM REPOSITORY "DDL-FILE"
INTO test OPTIONS ("ddl-file" '/path/to/schema1.ddl')
However, this does not seem to work.
Can the DDL file…
Kusters
- 28
- 1