Stack Overflow
Stack Overflow

Questions tagged [teiid]

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.

http://www.jboss.org/teiid

158 questions
0
votes
1 answer

Teiid embedded cache max entries

We are using query caching with Teiid embedded. But it is limited to 1024 resultset. In teiid standalone we can change this property in the file standalone-teiid.xml. But how can we change it in teiid embedded?
MTawk
  • 11
  • 2
0
votes
1 answer

DayOfWeek function in teiid depends on locale when pushed down to Oracle

In the teiid documentation the following definition is stated for the DayOfWeek function Return day of week (Sunday=1, Saturday=7) But when the teiid is pushed down to Oracle the dayOfWeek output differs depending on locale US Locale Sunday:…
Iman
  • 1
0
votes
1 answer

When I try to install teiid in domain mode, teiid-jdbc socket-binging portall 31000 is not opened

My server group is using ha-sockets, and configuration in domain.xml is as following, after start server and slave, ss -lnap check the opened port, 31000 is not in list. …
Wang Rui
  • 1
0
votes
1 answer

Extract and process select/update query constraints in Teiid ddl in Virtual DB

I am using Teiid vdb model where i need to extract query constraints inside the ddl and use it in a stored procedure to fetch results of my choice. For example, if I run following query : select * from Student where student_name = 'st123', i want to…
Hamza Idrees
  • 89
  • 7
0
votes
1 answer

Datasource updation on adding new properties

Is there any teiid admin api to update a datasource with new properties? For e.g. I have created a datasource with some properties and now I want to add some connection properties to it, then is there a way to update the existing datasource or we…
Manoj Majumdar
  • 505
  • 1
  • 4
  • 23
0
votes
1 answer

TEIID30492 Non-comparable expression of type object cannot be used in comparison

I am using setObject in Preparedstatement for the query SELECT * FROM table_name where column_name = ?. The column is of type DateTimeOffset of SQL Server and the object is OffsetDateTime. But it is giving me the following error: TEIID30492…
Manoj Majumdar
  • 505
  • 1
  • 4
  • 23
0
votes
1 answer

teiid sql join one row only

I have 2 tables in teiid vdb table a and table b, for every row in table a the table b can contain one or multi rows, how to join these 2 tables such that for every record in table a there is one match from table b? if table b contains more than…
Vaibav
  • 77
  • 1
  • 7
0
votes
1 answer

Connection url not visible while creating xa datasource mysql using Teiid

I am trying to create a mysql xa datasource, but am unable to mention connection url properties in it. I have used property names such as "URL" and "connection-url", but the property is not visible in datasource. Also when I explicitly make a…
Manoj Majumdar
  • 505
  • 1
  • 4
  • 23
0
votes
1 answer

Teiid Query Parser not identifying quoted identifiers

I am using Teiid's query parser. For the sql used in my below given code, although the identifiers are ansi-quoted, query parser is not splitting them into schema, tableName and FieldName correctly. Here is my Code: String sqlToParse = "Select…
M S
  • 1
  • 1
0
votes
1 answer

How to build conditional flat file import with fixed length columns

I'm using Teiid 9.3.7 with Wildfly 10 due to Teiid Designer version compatibility. I'm trying to build a view out of a flat file. There are two different types of entries in the file. Each type of entry has a key attribute that I need in order to…
dinky
  • 1
  • 1
0
votes
1 answer

Cannot insert null in datetimeoffset column in SQL Server using Teiid

I am using Teiid to insert null value in a datetimeoffset column, but the PreparedStatement.setNull(index, Types.TIMESTAMP) is not inserting null. The error which I am getting is this: Caused by: java.sql.SQLException: Remote…
Manoj Majumdar
  • 505
  • 1
  • 4
  • 23
0
votes
2 answers

How to connect NIFI to Teiid data virtualization using SSL configured in teiid?

We have a Teiid 12.3 server running which is configured using ssl. We are able to connect this teiid server using tools like pentaho etl, squirrel sql client, Tableau etc. we are using trustore file to connect these tools. But we are not able to…
Amar Kale
  • 1
  • 1
0
votes
1 answer

Teiid QueryParser not parsing SELECT TOP number|percent column_name(s)

When I try to parse a Select query with TOP clause , for e.g. SELECT TOP 10 * FROM Customers Getting the below error message: java.lang.Exception: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "SELECT TOP…
M S
  • 1
  • 1
0
votes
2 answers

TEIID Springboot integration

i read about Teiid and i liked it, but because it has a lot of changes, i got some problems first to deal with it, but what i understand now is the following: 1- teiid wildfly and thorntail are going to be obsolete, so, i will not use them. 2- teiid…
Mostafa Rizk
  • 11
  • 3
0
votes
1 answer

Delegate Translator Chaining

I am trying to delegate a translator by chaining in the VDB.xml but getting an error after making a call. The delegate translator suppose intercept calls to the actual delegate translator underneath and performs a calculation. Calculation is driven…
ASAFDAR
  • 19
  • 1
  • 7
1 2 3
…
10 11