Can't find the VDB

[nestordrod]

I'm trying out Teiid in our environment. I'm running on a Windows machine and using the 6.1.0 Embedded distro.

I've built and successfully tested a sample VDB (Partsdemo) in Teiid Designer. I placed a copy of the VDB in the deploy folder in the embedded core directory as indicated. I wrote a simple JDBC query Java program in Eclipse, added all the libraries, and linked the core directory as a source (using Eclipse's "Link Source" command).

When I try to run the code I get the following error:

com.metamatrix.common.application.exception.ApplicationInitializationException: Archive file "classpath:/Partsdemo.vdb" not found, failed to load the VDB.

I'm sure I'm missing something trivial, but nevertheless I'm stuck.

Help?

[rareddy]

Accessing VDB in the Teiid runtime is nothing different than accessing any other JDBC source. That said there are couple ways in the case Teiid "embedded", as to how to do this, there are explained here

http://www.jboss.org/community/wiki/TeiidEmbeddedDeploymentProfiles

We do recommend the "File Path" profile, as there is much less number of libraries you need to add into your client Java application.

From your message it looks like you are using "classpath" profile, and the program is complaining that it could not find the your vdb "Partdemo.vdb" in the classpath you defined for your application.

[nestordrod]

That was indeed the issue. I did not have the deploy-properties path included in the connection definition.

Thanks for the link. To be honest, I doubt I would have been able to find the reference if you hadn't pointed it out. I might humbly suggest that the wiki pages be a little more clearly organized to make critical information like this easier to locate.

[rareddy]

Below listed is main WIKI landing page that is accessible from the http://teiid.org

https://www.jboss.org/community/wiki/TheTeiidProject

This link I supplied is on this main page under Teiid Users. Do you think renaming this would have helped you to find it? Or may be providing a blurb on the main site's documentation page about more documentation on the WIKI etc. I am open for suggestions.

Thanks.

[nestordrod]

Well, the link to the wiki is under the "Commuity" tab instead of "Documentation" so it is not automatically clear that's where to go to get information on how to use the software. :)

In the wiki, the link to the page in question is sitting as the third item in a list with the vague title of "Deployment Profile." A little more description of the purpose of the item (and the list in general, now that we're talking about it) would be helpful.

[rareddy]

Thank you for the suggestions.

I have changed documents section to include the WIKI reference and re-named some of the articles on the WIKI to better represent what they do. Check out

http://www.jboss.org/teiid/docs.html

and let me know if this is any better.

Thanks again.

[nestordrod]

Greatly improved!

Thanks for your prompt response! :)