Dynamic VDB adding a resource jar file

[teiiduser]

I have a dynamic VDB XML and wish to point a jar file in it as a resource.

Instead of module.xml I want to package it in the vdb itself. So my vdb folder should have  a lib folder with my jar file and the dynamic XML file that will be pointing to this jar file.

Can we do this ?

Thank you!

[shawkins]

Yes that is possible using a zip deployment with your vdb.xml.

Create:

foo.vdb

  /lib/some.jar

  /META-INF/vdb.xml

The deployer will scan the lib and add all jars to the vdb classpath.  However this will not work yet in Teiid Embedded as it does not perform the same classpath management.

[teiiduser]

Thank you for the reply. What do you mean by Teiid Embedded? Do you mean that it will not work with Dynamic VDB XML ?

I am doing this basically for my UDF jar file.

I tried creating a folder with

/lib/some.jar

  /META-INF/myvdb.xml

and then zipped it and renamed as vdb. Copied this to the deployments folder. It does not get deployed.

[shawkins]

> What do you mean by Teiid Embedded?

It's our embeddable server environment.  It's clear though that you are using the full AS based server.

> It does not get deployed.

In a zip deployment we expect name vdb.xml. You cannot use myvdb.xml.

[rareddy]

Dynamic VDB you can not define JAR file as is, as defined in here VDB Definition - Teiid 8.8 (draft) - Project Documentation Editor

you can define the following in the your -vdb.xml file

<property name ="lib" value ="{module-name}"></property>

where you need to create a JBoss AS7 module with your JAR file and define the module name in the above property. At the time of the deployment the defined module is made available to the VDB.

If you are using Designer based VDB, then you need to follow what Steve is saying, place the jar archive in "lib" folder of the VDB archive. Then at deployment time the deployer will load these JAR files into VDB's classpath.

If you are using "embedded", you can just place it your VM's classpath, both the above techniques will not work as Teiid unaware of the host environment to access and load. It can possibly done for Designer based VDB as Steve is eluding to, but it is not available yet.

Ramesh..

[shawkins]

Ramesh, it doesn't matter whether the vdb comes from designer or not.  We'll process the dynamic aspects of the deployment all the same.

[teiiduser]

I could deploy using what Steven suggested. Only thing I had to 'Add' it using console. The directory scanner did not pick up the vdb for automatic deployment. Is it how this is supposed to be?

Thank you!

[rareddy]

if place the file in the "deployments" directory, you can either also place another marker file with "youvebname.vdb.dodeploy" or add the .vdb files to list of deployments that does not need marker files. Checkout the README.txt file there for instructions.

[teiiduser]

I came across :

https://docs.jboss.org/author/display/teiid84final/Dynamic+VDBs

How exactly does separating the DDL from XML improve the memory footprint?

Thanks!

[shawkins]

When the DDL is part of the vdb.xml we not only hold the runtime schema objects in memory, but the DDL as well.  Albeit that shouldn't be too much of an overhead in most cases.

[madhu.garimilla]

Hi Ramesh,

If i have some .txt files inside a jboss module and i try to add that module to VDB using

<property name ="lib" value ="{module-name}"></property>

Then Would i be able to access the contents of the .txt file inside my VDB ?

[shawkins]

Continued on how to access a resource(.txt) file , present in a jboss module, from a vdb.xml?

Sorry, we didn't mean to leave this unanswered.