How to create VDB from WS resource in embedded mode?

[matejuh]

I'm trying to get working embedded Teiid with XML Rest resource.

I used resource from this dissussion:

https://community.jboss.org/thread/201199?start=0&tstart=0

So bassically, the definition of VDB table should be:

SELECT

        long_name AS long_name, short_name AS short_name, type AS type

    FROM

        (EXEC geocode.invokeHttp('GET', null, 'http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=true')) AS f, XMLTABLE('/GeocodeResponse' PASSING XMLPARSE(DOCUMENT result) COLUMNS long_name string PATH 'result/address_component/long_name/text()', short_name string PATH 'result/address_component/short_name/text()', type string PATH 'result/address_component/type/text()') AS A

The thing is, that I don't know where to put it into my code (taken from Teiid embedded example):

https://gist.github.com/matejuh/5196313

I tried to set it as model schema, but it's not working.

xmlModel.setSchemaText("SELECT" +

        "long_name AS long_name, short_name AS short_name, type AS type" +

         " FROM " +

        " (EXEC Csm.invokeHttp('GET', null, 'http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=true')) AS f, XMLTABLE('/GeocodeResponse' PASSING XMLPARSE(DOCUMENT result) COLUMNS long_name string PATH 'result/address_component/long_name/text()', short_name string PATH 'result/address_component/short_name/text()', type string PATH 'result/address_component/type/text()') AS A");

How to get it working?

Thanks.

[rareddy]

See https://docs.jboss.org/author/display/TEIID/DDL+Metadata on what kind of DDL statements are allowed and how they are used.

[matejuh]

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?

[rareddy]

Have you seen the example in the embedded kit as to how to define a VDB? If not I suggest you start there first.

[matejuh]

Yes, I have... The example is working... My code based on that with WS ended with:

WARNING: TEIID30020 Processing exception 'Group does not exist:

[rareddy]

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..

[matejuh]

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?

[rareddy]

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..

[matejuh]

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...

[rareddy]

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"

[shawkins]

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.

[matejuh]

Steven, thanks. Stupid mistake. I had to be blind! You saved me...