Is there ability to add new table(s) to existing VDB other then via Designer or *VDB.XML?

Solution Verified - Updated -

Environment

  • JBoss Enterprise Data Services (JBEDS) 5.3
  • Red Hat JBoss Data Virtualization (DV) 6

Issue

  • Is there a way to add tables in a VDB, after the VDB was deployed more tables were created in the Datasource.

Resolution

Use Dynamic VDBs, they only reference the Model name not the tables underneath. Everytime the server is restarted or the VDB is redeployed it will re-read the metadata from the Physical Source.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.