-
1. Re: How to create VDB from WS resource in embedded mode?
rareddy Mar 19, 2013 10:11 AM (in response to matejuh)See https://docs.jboss.org/author/display/TEIID/DDL+Metadata on what kind of DDL statements are allowed and how they are used.
-
2. Re: How to create VDB from WS resource in embedded mode?
matejuh Mar 19, 2013 10:24 AM (in response to rareddy)Sorry, but I don't see any way, how your link can be usefull for my case and question. I am able to set model type, but I don't see any method how to add metadata into model with embedded server? Is this feature supported?
-
3. Re: How to create VDB from WS resource in embedded mode?
rareddy Mar 19, 2013 10:29 AM (in response to matejuh)Have you seen the example in the embedded kit as to how to define a VDB? If not I suggest you start there first.
-
4. Re: How to create VDB from WS resource in embedded mode?
matejuh Mar 19, 2013 11:09 AM (in response to rareddy)Yes, I have... The example is working... My code based on that with WS ended with:
WARNING: TEIID30020 Processing exception 'Group does not exist:
-
5. Re: How to create VDB from WS resource in embedded mode?
rareddy Mar 19, 2013 12:31 PM (in response to matejuh)Ok, good. In that case you defined the metadata for your VDB wrong in your code. It is telling you that the table you queried against does not exist. (Teiid has legacy issue where it used to call tables as groups in log messages)
Metadata is nothing but definition of your tables, views etc. The DDL Metadata link I provided above shows you all the options as to how to define a metadata for a VDB per model. The embedded kit example shows how to plug-in that metadata and how define the models, sources to create a VDB, deploy it and query it.
Ramesh..
-
6. Re: How to create VDB from WS resource in embedded mode?
matejuh Mar 20, 2013 8:21 AM (in response to rareddy)If I understand well, how to work with XML from documenation and examples, I have to specify native metadatamodel with connector into WS. Then I have to create a view over it as virtual metadatamodel. But when I tried it, I got:
TEIID40094 No metadata repository of type dll defined for model
Do I understand well, how to map xml into VDB?
-
7. Re: How to create VDB from WS resource in embedded mode?
rareddy Mar 20, 2013 10:10 AM (in response to matejuh)Matej,
I can not speak for yourself, but you are getting there. If you post your -vdb.xml file I probably can tell you what may be wrong with it.
Also why are you working with Embedded? Why not start with JBoss AS version, get your VDB defined correctly and your queries are working, then switch over to Embedded. Embedded Teiid is for an advanced user, who would like to "embed" Teiid runtime environment in host VM environment something other than JBoss AS.
Ramesh..
-
8. Re: How to create VDB from WS resource in embedded mode?
matejuh Mar 20, 2013 10:19 AM (in response to rareddy)I didn't define -vdb.xml. I think, in embedded Teiid it's useless and VDB are set up programatically? There are no -vdb.xml definitions in the embedded kit example, so I think so. I wanted to try, if it is possible to use embedded Teiid for testing purposes... I will probably try your advice and define it on JBoss AS and then try to integrate it as embedded...
-
9. Re: How to create VDB from WS resource in embedded mode?
rareddy Mar 20, 2013 10:29 AM (in response to matejuh)I think, in embedded Teiid it's useless and VDB are set up programatically?
Yes, you define metadata part using DDL.
There are no -vdb.xml definitions in the embedded kit example, so I think so. I wanted to try, if it is possible to use embedded Teiid for testing purposes...
Yes. You can do that. If download the source, there are examples using Embedded in test cases. See "TestASTQueries.java"
-
10. Re: How to create VDB from WS resource in embedded mode?
shawkins Mar 20, 2013 10:41 AM (in response to matejuh)I didn't see if you had noticed from the later messages, but DLL should be DDL. There is no DLL metadata repository and so you get an exception.
-
11. Re: How to create VDB from WS resource in embedded mode?
matejuh Mar 20, 2013 11:13 AM (in response to shawkins)Steven, thanks. Stupid mistake. I had to be blind! You saved me...