How to Specify Component Data Source in a Virtual Data Source?
Quote from kilian.folger on 18. March 2026, 18:30I just created two identical JDBC data adapters pointing at a Foodmart database in PostgreSQL, named them foodmart and foodmart2, and then created a virtual data source based on them. Now I can't select anything from that VDS because of the following error:
org.teiid.jdbc.TeiidSQLException: Group specified is ambiguous, resubmit the query by fully qualifying the group name: employeeMakes sense. But now how do I "fully qualify" the group name? I found https://docs.jboss.org/teiid/6.2/reference/en-US/html/sql_support.html saying you can specify a table as <model>.<table>, where <model> must somehow correspond to the component data source (foodmart/foodmart2), but
select * from foodmart.employees select * from foodmart.public.employeesboth won't work. Does anyone know how to find the right model name?
I just created two identical JDBC data adapters pointing at a Foodmart database in PostgreSQL, named them foodmart and foodmart2, and then created a virtual data source based on them. Now I can't select anything from that VDS because of the following error:
org.teiid.jdbc.TeiidSQLException: Group specified is ambiguous, resubmit the query by fully qualifying the group name: employee
Makes sense. But now how do I "fully qualify" the group name? I found https://docs.jboss.org/teiid/6.2/reference/en-US/html/sql_support.html saying you can specify a table as <model>.<table>, where <model> must somehow correspond to the component data source (foodmart/foodmart2), but
select * from foodmart.employees select * from foodmart.public.employees
both won't work. Does anyone know how to find the right model name?