Unable to preview generated view in jboss data virtualization platform Hi, I am trying to create a view from an xml file using the JBoss Data Virtualization tool. I have followed all the steps outlined in the introductory videos on the JBoss website(1,2 and 3). After adding the XM... 
Remote connection to teiid server from designer Hi, I'm trying to connect from teiid designer 9.1.1 to a remotely installed teiid server version 8.9.1 but I cannot get it to work. My configuration is as follows. A Windows 2008 R2 Server has Teiid de... 
Non-whitespace character found Hi, As I have indicated before the help in this forum is much appreciated. I have a CSV with data to be inserted into MySQL. Some of the data is successfully inserted but some of the data generates the follow... 
Transformation query not generated after ddl view import. Hello, I am using TEIID designer 9.0.2. We exported the existing source and view model separately into ddl file. We imported source model ddl successfully without any issue. But while importing the view mo... 
Teiid parsetimestamp Hi all, Your help is much appreciated. I am using parsetimestamp to export data from CSV into MySQL. An example of date format on CSV is "Mar 17 2009 9:00PM" On teiid designer I h... Execute a virtual procedure from within another virtual procedure Hi, Much appreciate you all for your reliability and help. I have created a Teiid virtual procedure which I want to execute from within another procedure, as follows; CREATE VIRTUAL PROCEDURE BEGIN ... Teiid - Consume JSON tree from REST web service I am trying to consume the JSON data returned by REST WS, Essentially this data is a array with each element of array may be having one or more array with few attributes at each level. A sample data is attached with... 
suggestion for installation procedure teiid designer Hi, Just a small suggestion. In the Download and Install page for teiiddesigner in Luna, it says Install Teiid Designer 9.1. Might I suggest to explicitly indicate to install the runtime and clients? I first i... Teiid designer 9.1 exception String Index out of bounds Hi, I 've installed teiid designer 9.1. When I open an old project I get some errors for virtual procedures. eg: java.lang.StringIndexOutOfBoundsException: String index out of range: 1 ... Deploy and Activate VDB Hi, Thank you all for your support. I have a procedure on my Teiid designer that loops on data from a CSV and inserts to MySQL. I needed to automate the process so I used AdminShell to insert t... error while "Test JDBC Connection" in server Teiid instance Hello, I have created a new server in JBDS, and added it as the default server. In Teiid Instance tab, I am not able to make "Test JDBC Connection". It is giving error - Unable to establish connection to serv... 
DV is not suitable for recording the historic snapshots of data ! Hi guys, i am nearly new here and very interested in dv. Me and my boss are in conflict, because i dont understand, how ist possible to take snapshots with dv. It's very important for our use cases. I mean in... 
How to determine the query performance using Teiid Execution Plan Hi, How to determine the SQL query performance using Teiid Execution Plan I want to know the time taken of select, union, joins, where, order by....... 
Automate or Schedule VDB Deployment Hi, I have a working VDB that I use to insert data from CSV file to MySQL. I want to automate this task and schedule it to run everyday at midnight. How can I do this? Regards M... Integrate Teiid Designer with EAP6.3.0 I'm hoping you can help me with a problem I am having around server integration and Teiid designer. I must start by saying I'm not that familiar with this platform, this is a research project. So I've been hitting Goo... 
Error: GETTEXTFILES does not exists Hi Everyone, I am trying to create a vdb using flat file source in Teiid Designer. I have followed the steps mentioned in the link given How to create a virtual database from a text file using Teiid - Sergio Moral Ru... 
Teiid JDBC connection fails from Teiid Designer8.5 I am using EAP 6.1 Alpha with Teiid 8.7 final, I have deployed a static MySql VDB. Able to make a Teiid JDBC connection through Squirrel Client. Now When I try to create a Teiid JDBC connection through TeiidDesigne... 
Not able add hints in transformation query using TEIID Designer 8.5 Hello, I am using teiid designer 8.5 to create materialzed view on static VDB. We want to update the cache of materialized view for single row. To achieve this we tried adding hint /*+ cache(updatable) */. But ... What is the best way to assign primary keys to views for OData Hi- I am trying the expose the VDB as REST using OData. It works but I need advise for cases where I don't have primary keys. There are two cases- There is a table in the database with a primary key column, this tab... 
"Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer Hello, I've set up JBOSS AS 7.1 and Teiid 8.2 on WIndows. I've installed Teiid Designer 8.0 in Eclipse Juno sr1. All I'm trying to do is "Test JDBC Connection" and it gives me the message: unable to esta... 
Log in to follow, share, and participate in this community.