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

Exception at converting from string to xml

I try to convert from string into xml using teiid server but when I run query this error always appear "java.io.OptionalDataException" ..I don't understand what the wrong.thank you Iam trying to convert this simple string…
Aser
  • 27
  • 4
0
votes
1 answer

Native Function Return from Geography Data Type

I am creating a DDL file to be deployed as VDB using TEIID. The source model is MS SQl. In the source database there is geography data type column. I am trying to read the lat and long from geography data type. To retrieve the lat/long in sql…
ASAFDAR
  • 19
  • 1
  • 7
0
votes
1 answer

Cloning not happening between two xa datasources of SQL Server

I am trying to clone data(copy data from one database to another using) using Teiid (jtds 1.3.1 driver) from SQL Server 2012 to SQL Server 2012 (2 XA Datasources), but somehow it is giving me this error. 2020-04-03 09:28:28,702 WARN …
Manoj Majumdar
  • 505
  • 1
  • 4
  • 23
0
votes
1 answer

QueryParser not parsing sql statement with quoted identifiers other than ansi-quoted

I am using org.teiid.query.parser.QueryParser to parse a SQL string into Query object. It works fine for ansi quoted identifiers (double quotes). However, it is throwing error while parsing the identifiers quoted with square brackets, single quotes…
M S
  • 1
  • 1
0
votes
1 answer

Assigning row number without any order

How can I use row_number() function without any order Example Table: COL A COL B 42123345990000 0 42123345990000 0.33333334 42123345990000 0.6666667 42123345990000 1 42123345990000 0.86340976 42123345980000 0 42123345980000 …
ASAFDAR
  • 19
  • 1
  • 7
0
votes
0 answers

Extracting Double Values from Blob/Object to Rows

I have a query that is related to this topic: https://developer.jboss.org/thread/277610 Prior to reaching the comma separated values stage, the values are actually stored as a blob. There is a function fetchBlobtoString(Blob, string, VARIADIC…
ASAFDAR
  • 19
  • 1
  • 7
0
votes
1 answer

OData $search support in Teiid vs Jboss Data Virtualization

I'm looking to use Salesforce to, using Odata, connect to Teiid+Wildfly, which in turn connects to SQL Server. When I read the documentation for Teiid 13, under limitations, it says OData $search is not…
Mike Porter
  • 33
  • 3
0
votes
1 answer

Calling Oracle & MySQL Stored Procedures from Virtual Stored Procedure

All, I am new to TeiiD. I have Oracle and MySQL stored procedures (inserting records into tables) executing successfully from TeiiD VDB as separate procedures using call commands. I am using SquIrrel tool to execute them independently from Active…
Adinath
  • 1
0
votes
1 answer

Teiid Spring Boot, concerns regarding VDB being deprecated

I am working for my new project wherein I am required to interact with multiple data sources and execute join queries, I created VDB using Teiid Designer and deployed it on JBoss AS 15.0.1 and pulled data using separate Java / Spring Boot…
Purnima Das
  • 1
  • 1
0
votes
1 answer

Teiid Spring Boot @SelectQuery

I have configured 2 different data souces in my Teiid Spring Boot Application and have been following this example: https://github.com/teiid/teiid-spring-boot/blob/master/docs/UserGuide.adoc This example demonstrates a union query from Customer…
Purnima Das
  • 1
  • 1
0
votes
1 answer

Teiid Spring Boot - Configuring Multiple Data Sources

I started with Teiid Spring Boot simple example from the following url: https://github.com/teiid/teiid-spring-boot/blob/master/docs/UserGuide.adoc It uses two different data source to demonstrate Teiid Spring Boot's capability to interact and fetch…
Purnima Das
  • 1
  • 1
0
votes
0 answers

How to use salesforce translation cache?

If we use salesforce translator need to use cache for translation results (not for query results) for speed up of translation of SQL request to SOQL. How to use this in TEIID in spring-boot-teiid application?
3draven
  • 31
  • 4
0
votes
0 answers

Teiid 12.2.1 ClassCastException when I try to create vdb

I am trying out my first sample application with Teiid Designer and i am using Wildfly AS v15.0.1 and Teiid v12.2.1. I created Datasource, VirtualBaseLayer model and FederatedViews successfully, I then proceeded to create a .vdb file and this is…
Purnima Das
  • 1
  • 1
0
votes
1 answer

Teiid Spring Boot: @SelectQuery supports of where clause parameters

From my understanding, @SelectQuery will return all data of columns defined. What if I would like to restrict data return from the query by adding where clause with parameterized filter? For example, the following SQL query support filter by…
limcheekin
  • 144
  • 1
  • 12
0
votes
1 answer

explicitly call TEIID function

I would like to explicitly call a TEIID function instead of having it pushdown... Is there a way for me to explicitly call org.jboss.teiid.row_number() over (order by x), so that the row_number() function is at the TEIID layer, instead of getting…
apk
  • 1
1 2 3
…
10 11