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

Jboss keeps using up the max memory with large dataset

I'm new to JBOSS and I have a memory issue with a JVM (running under JBoss) and I wanted to see if you could help? My JBOSS server running Teiid has been running out of memory when querying against a large table (130 million rows with 45 columns).…
Tom
  • 1
  • 1
0
votes
1 answer

Installation error of Teiid Designer to eclipse

while trying install Teiid Designer to eclipse the below message is displaying. it is not allowing me to go forward Cannot satisfy dependency: From: JBoss Tools Common Core 3.5.2.Final-v20140302-2358-B158 (org.jboss.tools.common.core…
0
votes
1 answer

Can't resolve teiid-parent maven heirarchy

What do repositories must I add need to enable consumption of teiid-admin via maven? Why does a released version of teiid depend on a pre-release ancestor pom (org.jboss.as:jboss-as-parent:pom:7.5.0.Final-redhat-15 pom file in the jboss "Product…
Peter Kahn
  • 12,364
  • 20
  • 77
  • 135
0
votes
1 answer

Error on groovy script (Admin Shell) for Teiid

I have this teiid.groovy script to execute an SQL query on a Teiid VDB: sql=connect(${jdbc:teiid:PREVIEW_d3cd3bd1-7b0a-4ca0-94f9-84e37ce7b106_iCare_P5_project.1@mm://localhost:31000}, {$user1}, ${user2014!}); sql.execute("select * from ( exec…
Mardwan
  • 139
  • 3
  • 14
0
votes
1 answer

Teiid Instance in JBoss DV 6.0 cannot connect in JBDS

I am working on Teiid Designer in JBoss Developer Studio, and to perform "Execute VDB" it says that an instance of teiid must be running, so I start JBoss DV 6.0 Server, and test the connection on Teiid Instance view of the server, the tests "Test…
Aguaka MPA
  • 43
  • 1
  • 4
0
votes
1 answer

Caching Issue with Teiid Virtual DB with ODATA Query

I have a business scenario where, whenever a new record is loaded into a DB table, a) A notification will be sent to the client. Notification message is to convey data is loaded and ready for querying. b) Upon receiving the…
user3061250
  • 960
  • 8
  • 9
0
votes
1 answer

Refresh materialized view in teiid

I have created a teiid vdb with sql server data source. The view model contains a materialized view, need to know how to refresh the materialized view manually(like daily or hourly basis) or automatically? Is there any sql command to trigger the…
lourdh
  • 449
  • 2
  • 12
  • 30
0
votes
1 answer

How to reference top table in UPDATE in Teiid

Is there any way to reference updatable table in UPDATE statement in Teiid (8.4)? For example: i have table (tag_id, value, time, active_ind). I'd like to mark all tags with non-max time. UPDATE BUFFER buf SET active_ind = 'N'; WHERE "time" NOT IN…
nidu
  • 549
  • 2
  • 18
0
votes
1 answer

Maven dependency is downloading only pom not jar for newer version

I have a dependency on JBoss's teiid framwork. If I add the dependency on older version it downloads the jar file while if I add dependency on newer version it only downloads pom file. below is my pom config repository:
Manoj
  • 814
  • 8
  • 7
0
votes
1 answer

Integrated Authentication in Jboss Teiid

I want to use Integrated authentication using jdbc connector in Teiid. I have tried to create a connecton to Database using: 1. Create Teiid Model Project-> Source ->Import->JDBC Connection 2. I see a feature called integrated security checkbox in…
madhurika
  • 191
  • 1
  • 8
0
votes
1 answer

Why does Odata (through Teiid) only display certain tables and not others?

I set up a Teiid instance to view a variety of tables. When I set up the VDB, I specified a number of tables to show up: However, when I view the XML in chrome (http://www.someserver.com:8080/odata/JTrac) only SDM_2D_LINE_TRACKER shows up: Any…
Slothario
  • 2,830
  • 3
  • 31
  • 47
0
votes
2 answers

Create a schema to be used with MongoDB and Teiid that has a mongo array in the document

I have the following document in MongoDB: { "_id" : ObjectId("529632350083bc14d145bb56"), "CaseId" : "8f68cf65-80ad-4950-88d5-e322d0296461", "CaseAddressString" : "527 Irving Avenue, Rivereno", "CaseOpenDatetime" :…
user179981
  • 167
  • 2
  • 5
  • 11
0
votes
1 answer

Teiid sql query with chinese character

I want to ask a question about a data virtualization system called teiid, When I create a query like this: SELECT teiid2602.KC.{**some chinese character**} FROM teiid2602.KC WHERE teiid2602.KC.id is not null; the teiid system returns the…
0
votes
1 answer

How to consumeTEIID Web service model operations using OData

I have a Web service model (with CRUD )deployed on JBoss EAP 6.1 which I can access using SOAPUI. I have created a SOAP consumer model project using TEIID designer to consume the WS operations defined in the aboce WS model and I am trying to access…
0
votes
1 answer

Updating model extension properties in Teiid fails

I'm having issues updating Teiid 8.6 model extension properties via JDBC. I can query the metadata, but I get an error while trying to issue an UPDATE command. update "SYS"."Properties" set "Value" = 'VAL1' where "Name" =…
Alex Khvatov
  • 1,415
  • 3
  • 14
  • 23
1 2 3
10
11