Log in to follow, share, and participate in this community.
Thread Update query to execute a method on a external Rest Controller via VDB
Update query to execute a method on a external Rest Controller via VDBHello to all, I developed a VDB that exposes a REST service as a Datasource. With a select on a view now I can invoke the Rest controller and get a result set. Now I'm looking for a way to invoke a method on the...
Ambiguos group error on queryHello, I have created a VDB that contains a data source (data_source.xmi) to a oracle database with JDBC connection. In the VDB there is a "metadata model" of type View that maps the JDBC data source. By running a q...
Thread Invoking a JDV Stored procedure with parameters with ODATA
Invoking a JDV Stored procedure with parameters with ODATAHi All, I created a stored procedure that that has several parameters. What i need clarity on is with is the correct syntax for the odata url when adding parameters. My current URL looks like: "localhost:8080/odata...
Deploy war file to JDV serverHi, As I'm following a Red Hat tutorial I am unable to deploy a war file using the JBOSS EAP Management Console. I created a .war file succesfully at an earlier stage. When adding a deployment (Runtime ->...
Thread VDB Service returns only few records not all
VDB Service returns only few records not allHi, I have created VDB and exposed rest web service using Red Hat Data Virtualization. But when i hit that url, it returns only few records. but we need all records or pagination. My Service URL is Like : htt...
Error validating SQL statementHi Folks, When I "preview data" at the "getTextFiles" procedure, using the SQL statement showed in screen1.png, it works well. But, when I use the same statement with the "validation button" (screen2.j...
Thread Sql server connection using Windows authentication is not working
Sql server connection using Windows authentication is not workingI am following this https://access.redhat.com/solutions/1134453. The problem statement is perfectly matching. I followed each and every steps mentioned there. there it was flagged as verified.But I am getting the f...
Thread Unable to import data services using Data Services Builder - Web UI
Unable to import data services using Data Services Builder - Web UIHello, I am getting an error when i try to import data services and also testing connection / connection for Administration and JDBC under User > Preferences link also is not working. When i click on ...
Teiid Impala Translator decimal pushdownI'm using the Impala translator and can't seem to get the decimal or bigdecimal data types to push down with aggregate functions. Here's my scenarios, the first of which using DOUBLE pushes down, the latter as D...
Thread java.lang.IllegalArgumentException: character to be escaped is missing
java.lang.IllegalArgumentException: character to be escaped is missingHello, I am trying to create a VDB to consume a REST based Web Service, using Teiid. I was able to create the view model and the view procedure, but when I try to preview the data, i get this: "ERROR: java.lan...
Thread How to get LIMIT to work as desired w/virtual procedure?
How to get LIMIT to work as desired w/virtual procedure?Hi there, Environment: JBoss EAP 6.1.0 (bundled with Jboss DV) Teiid Version 8.7.1 MSSQL Java 1.7.0/75 Windows 7/x64 We're trying to query from a RESTful service through to a database, limiting the...
Simple.OData.Client ExceptionHi All, We are writing a simple .NET (4.5) client App, which uses Simple.OData.Client library. Teiid server is 8.11 Final deployed on Ubuntu. The data model is fairly straightforward with two related entities F...
Data Virtualization failure preview dataHi I run Ubuntu 14.04 and I would like to try JBoss Data Virtualization. I download the JBoss Data Virtualization 6.1.0.GA (http://www.jboss.org/download-manager/file/jboss-dv-installer-6.1.0.redhat-3....
Thread Teiid: cannot create materialized view for table
Teiid: cannot create materialized view for tableHi. everybody! I'm using Teiid 8.8.1 and trying to enable caching for DB table via Teiid materialized view feature. I've got table t_currency (list of available currencies) in PostgreSQL DB and I want to put i...
Using jBoss Data Virtualization platformHi, I am fairly new to the entire jBoss middleware suite. I am working on an application in which I am looking to connect to disparate data sources. To save time, I am looking to implement some data vi...