Generate JBossWS-CXF jar disabled in teiid designer

[nagashree.b]

I am unable to expose the VDB as a webservice from the teiid designer. The VDB->Right Click->Modelling->Generate jbossWS-CXF war and the resteasy war options are both disabled. What could be the problem?

Do you need anything specific to be installed to use this option?

This is my environment -

I have teiid runtime 7.7, jboss 5.1 and teiid desinger 7.7. I also have jbossWS-CXF installed on my jboss 5.1.

Thanks

Nagashree

[blafond]

The logic for that action requires the selection to be a VDB and that the VDB contains at least 1 Web Services model.

Barry

[tejones]

Nagashree,

Also, for REST WAR generation, your VDB needs a model that contains at least one REST enabled procedure. See here: http://docs.jboss.org/teiid/designer/7.7/user-guide/en-US/html/metadata-specific-modeling-chapter.html#war-generation-section for details on both options.

Thanks,

Ted

[nagashree.b]

Barry,

  My VDB has - a View [Relational View Model for two datasources - one JDBC model and one webservice model]. So it wudnt work?.

I tried creating the webservice for the View, but that again generates a webservice model in Teiid.

[blafond]

I can't duplicate your issue.

What version of Designer are you running?

Barry

[tejones]

Nagashree,

Why are you creating a view that joins a web service model with a JDBC source? What is the source for your web service model? The typical use case is that a user has a source (that can join many sources) that they want to expose relationally as a web service and the web service models are generated to expose that. Can you please explain your use case? Perhaps we can suggest a better modeling approach.

Thanks,

Ted

[nagashree.b]

@Barry,

  I am using teiid Designer 7.7 on eclipse sdk 3.7.2

@Ted

   I am trying to pull data from MySQL and mongodb. Since mongodb doesnt have a jdbc driver and teiid doesnt have a connector for this[I guess a custom connector would be needed], I am using a webservice to pull data from mongodb using their java driver.

I read somewhere in the teiid designer help, using the view I can join data from multiple data sources. Hence tried created a relational view Model which works as desired.[checked the preview]

I added the view in the VDB.

Now there are 2 options for my app to fetch data from the VDB [Correct me if I am wrong]

a. jdbc way using teiid driver

b. expose the VDB as a webservice, deploy the webservice war on the JBoss AS and call the webservice from the app.

Pls suggest if there is a better way out to combine data from these DBs.

[tejones]

Nagashree,

So just to be clear, you wrote a web service that connects to the mongodb source? If so, you can create a view "A" using the WSDL to Source and View model importer from that WSDL. This will create a new view "A" and source model. Then you can create a  view "B" on top that joins your new view "A" (the web service exposed relationally) and the MySql source. With that in place, you can create a web service model that exposes the view "B" and generate your WAR file.

Thanks,

Ted

[nagashree.b]

Ted,

Yes the webservice can connect and retrieve data from mongodb.

   This is what I have done.

1. Imported a WSDL source/view model [I guess this is View A]

2. Imported JDBC Model.

3. Created a View using View A and the JDBC data source including the join [this is View B]

4. I created a VBD including view B in my VDB.

You are saying I should create a web service model using View B and then add the web service model in my VDB, then the webservice war can be created. right?

Thanks..

Nagashree

[rareddy]

Nagashree,

Yes, creating a web-service model based on ViewB and then creating WebService WAR based on that VDB should work.

Ramesh..

[nagashree.b]

Thanks Ted and Ramesh it works.